What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Alter PROCEDURE dbo.csp_moveDocumentFromDatabasetoThis ( @@idoldfile as int ,@@iduser as int = 1 ,@@fileextension as nvarchar(32) ,@@filetype as int ,@@compressed as int = 0 ,@idnewFile INT OUTPUT ) AS BEGIN SET NOCOUNT ON; INSERT INTO lime_sammanslagning_destination.dbo.[file] /* EDIT HERE, Destination */ ([filetype], [status], iduser, fileextension, [compressed]) VALUES (@@filetype, 0, @@iduser, @@fileextension, @@compressed) Select @idnewFile = SCOPE_IDENTITY() UPDATE lime_sammanslagning_destination.dbo.[file] /* EDIT HERE, Destination */ SET [data] = ( Select [data] From lime_sammanslagning_destination.dbo.[file] /* EDIT HERE, Source */ Where idfile = @@idoldfile ) Where idfile = @idnewFile END GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.