https://skysigal.com/ 2026-05-04T10:52:04+00:00 https://skysigal.com/ https://skysigal.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-11-04T23:31:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/sql_server/howto/sql/dml/selects/home?rev=1699140670&do=diff IT:AD:SQL Server:HowTo:SQL:DML:Selects Related: * UP * IT:AD:SQL Server:HowTo:SQL:DML:Selects/Joins Selects Paging Data 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 RowNum BETWEEN (@PageNum - 1) * @PageSize + 1 AND @PageNum * @Page… text/html 2023-11-04T23:31:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/sql_server/howto/sql/dml/selects/join_across_different_collation?rev=1699140672&do=diff IT:AD:SQL Server:HowTo:SQL:DML:Selects:Join Across Different Collation Related: * Selects ---------- Just ran into a cute error message doing a join across two databases that had different collation: Msg 468, Level 16, State 9, Line 15 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CI_AI" in the equal to operation. when I ran the following: select top 10 BlahBlah from Tbl1 c left outer join Tbl2 a on c.ClientId = a.ClientId inner join … text/html 2023-11-04T23:31:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/sql_server/howto/sql/dml/selects/joins?rev=1699140671&do=diff IT:AD:SQL Server:HowTo:SQL:DML:Selects/Joins Related: * UP