Often you’ll want to compare datetime values based on the date only, ignoring the time. This is especially important when doing date ranges, where thinking like a human you might want ‘Select Accounts Join Offers Where SignupDate between 1st Jan and 31st Jan’. As a human we’re probably thinking ‘inclusive’. As a computer, SQL Server […]
You are browsing archives for
Month: January 2005
Snippet: Show full column names and data types for all user tables in a database
SELECT QUOTENAME( sysobjects.name ) + ‘.’ + QUOTENAME( USER_NAME( sysobjects.uid ) ) + ‘.’ + QUOTENAME( syscolumns.name ) AS [Name] , TYPE_NAME( syscolumns.xusertype ) AS [Type] , syscolumns.prec AS [Precision] , syscolumns.scale AS [Scale] FROM syscolumnsINNER JOIN sysobjects ON syscolumns.id = sysobjects.idLEFT OUTER JOIN systypes ON systypes.xtype = syscolumns.xtypeWHERE sysobjects.xtype = ‘U’
SQL Server 2000 Service Pack 4 ( SP4 ) is on the way
Microsoft Support has published knowledge base articles 888799 and 888800 on Dec 21st 2004 for SQL Server Service Pack 4 Beta and Analysis Services Service Pack 4 Beta. Details on how to participate in the Beta Details on how to download the latest SQL Server 2000 service pack