Wednesday, January 7, 2009

Inserting in to a table



Now you have created your table here is a basic insert statement to show you how to insert data.

INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 1, 21 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 39, 21 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 1998, 2001 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 26, 2817 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 21, 2938 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 12, 21 )
go
INSERT INTO dbo.BRIAN ( a, b ) VALUES ( 3939, 4848 )
go

No comments:

Post a Comment