摘要:
create table #temp ( dbname nvarchar(50))declare @xname nvarchar(50)declare @rowCount intdeclare mycur cursor for select name from sys.databases where owner_sid <> 0x01open mycurfetch next from ... 阅读全文
摘要:
清除表:truncate table 【tablename】; 建立存储过程: create proc procname as .. go 建立游标: declare cursorName cursor for sqlsentence --定义游标 open cursorName--打开游标 fetch next from cursorName into --执行查询 close... 阅读全文
摘要:
--创建测试表 [CREATE] TABLE t1(ID int IDENTITY,A int) GO --插入记录 INSERT t1 VALUES(1) GO --1. 将IDENTITY(标识)列变为普通列 [ALTER] TABLE t1 ADD ID_temp int GO UPDATE t1 SET ID_temp=ID [ALTER] TABLE t1 DROP COLUMN ID ... 阅读全文