Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
CREATE PROCEDURE SMI_P100_Student_Download_TEST @SessionID INT AS DECLARE @tab table (i int identity, DownloadID INT, CustomerID VARCHAR(20)) DECLARE @rows int INSERT INTO @tab SELECT DownloadID, CustomerID FROM [dbo].[DOWNLOAD] WHERE [SessionID] = @SessionID AND [Status] IS NULL SET @rows = @@Rowcount WHILE @rows > 0 BEGIN SELECT... FROM... WHERE... AND DownloadYear = ????? AND CustomerID =????? AND CustLoc = ????? SET @counter = @counter + 1 END
|How can i use insert and update together by merging two tables?||9||30|
|SQL create line numbers for data sampling||11||27|
|RAISERROR WITH NOWAIT||2||16|
|Using T-SQL (SQL Server 2008 R2) to determine whether file exist on server and delete it||4||29|