wnjnfn的博客

SQL server中实现Sleep类似的功能

1.删除指定数据库下所有表use mastergoDECLARE MyCursor cursor for select 'drop table ['+name +']; ' from sys.tables where type = 'u' open MyCursordeclare @SQL varchar(200)fetch next from MyC

SELECTName,--视图名字Definition --视图内容FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_idWHERE o.[type] = 'v' and name like '%pre%' or name like '%post%'order by name

--锁表（其它事务不能读、更新、删除）BEGIN TRANSELECT * FROM <表名> WITH(TABLOCKX);WAITFOR delay '00:00:20'COMMIT TRAN--锁表（其它事务只能读，不能更新、删除）BEGIN TRANSELECT * FROM <表名> WITH(HOLDLOCK);WAITFOR delay ...