Research and test the creation of a table variable, insert 3 records into it, and select all records. Use 3 columns and 3 records.
Declare @Frogs table
(
id int primary key identity(1,1) not null
, legs int
, color varchar(36)
, spots int
)
Insert into @Frogs (legs, color, spots) values (5, 'blue', 3)
Insert into @Frogs (legs, color, spots) values (4, 'red', 7)
Insert into @Frogs (legs, color, spots) values (8, 'purple', 22)
select * from @Frogs
No comments:
Post a Comment