SqlServer Util Command

Last Update: 2011/06/16 11:06+08

---取得連線資訊---------------------
Use master
Select * From sysprocesses


---Foreach table------------------
Use []
--請注意唷, 下面指令會刪除All table
Exec sp_MSforeachtable @command1 = "DROP TABLE ?"


---Limit---------------------------
select * from (select row_number() over (order by ac_id) as row_num,* from account)
 t where row_num between 1 and 30