摘要:
-- 声明变量 DECLARE @Id NVARCHAR(100) DECLARE @index int set @index=1 -- 声明游标 DECLARE MyCursor CURSOR FOR select Id from Sheet3 -- 打开游标 OPEN MyCursor -- 从 阅读全文
摘要:
1、Oracle 连表修改 merge into t_user t1 using (select * from t_class) t2 on(t1.userId=t2.userId) when matched then update set t1.name=t2.name 2、Sql server 阅读全文
摘要:
--查看被锁表: select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' order 阅读全文