SQL Server programming and training continues...

SQL programming never ends. The basics are just as important as the advanced.

 

If you like, just open us SSMS and do a quick T-SQL example like below; do this by heart and memorization and you will be already one up from most just trying to do some basic I/O;

 

the key example methods are : Create, Insert, Update, Delete, Drop

 
create database test2;

use test2;

create table test1 (
row_id    int    identity,
num1    int    null,
num2    int    null,
text1    varchar(255) null,
text2    varchar(255) null,
money1    money null,
money2    money null,
float1    float null,
float2    float null
)

select * from test1;

insert into test1 (num1) values(1);

declare @i int;
select @i = 0;
while (@i < 100)
Begin
    insert into test1 (num1, num2) select rand() * 100, rand() * 1000
    Select @i = @i + 1
End

more to come...