摘要:
查找阻塞进程: SELECT blocking_session_id '阻塞进程的ID', wait_duration_ms '等待时间(毫秒)', session_id '(会话ID)' FROM sys.dm_os_waiting_tasks 杀死阻塞进程: KILL 57 阅读全文
摘要:
像Major表里面批量插入数据演示: 代码如下: Declare @I int Set @I=0 Begin Tran InsertData: Insert into Major values(@I,'hello') Set @I=@I+1 if @I<10000 Goto InsertData C 阅读全文