摘要:
create table #ttt(id int,name nvarchar(10));merge into #ttt t using (select 1 as id ,'eee' as name ) b on (t.id = b.id) when matched then update set t... 阅读全文
摘要:
--方法1DECLARE @Table NVARCHAR(30)DECLARE tmpCur CURSOR FORSELECT name FROM sys.objects WHERE TYPE='U' AND name LIKE N'HSUPA%'OPEN tmpCurFETCH NEXT FROM... 阅读全文