數(shù)據(jù)庫基本sql語句大全-資料下載頁
2025-07-21 10:07本頁面
【正文】 ogicalFileName, @NewSize)EXEC (@TruncLog) Wrap the log if necessary.WHILE @MaxMinutes DATEDIFF (mi, @StartTime, GETDATE()) time has not expiredAND @OriginalSize = (Select size FROM sysfiles Where name = @LogicalFileName)AND (@OriginalSize * 8 /1024) @NewSizeBEGIN Outer loop.Select @Counter = 0WHILE ((@Counter @OriginalSize / 16) AND (@Counter 50000))BEGIN updateInsert DummyTrans VALUES (‘Fill Log‘)Delete DummyTransSelect @Counter = @Counter + 1ENDEXEC (@TruncLog)ENDSelect ‘Final Size of ‘ + db_name() + ‘ LOG is ‘ +CONVERT(VARCHAR(30),size) + ‘ 8K pages or ‘ +CONVERT(VARCHAR(30),(size*8/1024)) + ‘MB‘FROM sysfilesWhere name = @LogicalFileNameDrop TABLE DummyTransSET NOCOUNT OFF說明：更改某個表exec sp_changeobjectowner ‘tablename‘,‘dbo‘存儲更改全部表Create PROCEDURE @OldOwner as NVARCHAR(128),@NewOwner as NVARCHAR(128)ASDECLARE @Name as NVARCHAR(128)DECLARE @Owner as NVARCHAR(128)DECLARE @OwnerName as NVARCHAR(128)DECLARE curObject CURSOR FORselect ‘Name‘ = name,‘Owner‘ = user_name(uid)from sysobjectswhere user_name(uid)=@OldOwnerorder by nameOPEN curObjectFETCH NEXT FROM curObject INTO @Name, @OwnerWHILE(@@FETCH_STATUS=0)BEGINif @Owner=@OldOwnerbeginset @OwnerName = @OldOwner + ‘.‘ + rtrim(@Name)exec sp_changeobjectowner @OwnerName, @NewOwnerend select @name,@NewOwner,@OldOwnerFETCH NEXT FROM curObject INTO @Name, @OwnerENDclose curObjectdeallocate curObjectGOSQL SERVER中直接循環(huán)寫入數(shù)據(jù)declare @i intset @i=1while @i30begininsert into test (userid) values(@i)set @i=@i+1end
法律信息相關(guān)推薦
鄂ICP備17016276號-1