This trigger will act like version control on your database, After each release you have to set a Release Label, before release you can query by Release Label and date descending to populate all the changes done /****** Object: Table [dbo].[dbChangeLog] Script Date: 06/16/2010 17:32:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET [...]
Posts Tagged ‘sql’
29 Dec
T-SQL For Paging
I need this t-sql often. So I am saving the code block for future use. DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 2; SET @PageSize = 10; WITH OrdersRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, OrderID) AS RowNum ,OrderID ,OrderDate ,CustomerID ,EmployeeID FROM dbo.Orders ) SELECT * FROM OrdersRN WHERE [...]
