gistfile1.txt

tsql -S mssql -U user_name

1> use database_name
2> select * from test;
3> go

1> insert into test (name,num) values ('foo', 1);
2> go

1> update test set name = 'bar' where id = 1;
2> go

1> delete from test where id = 1;
2> go

1> begin
1> commit
1> rollback

# mysql> show databases
1> select name from master.dbo.sysdatabases;
2> go

# mysql> show tables
1> select name from sysobjects where xtype = 'U' or xtype = 'V';
2> go

# mysql> desc table_name
1> sp_columns table_name
2> go