You are browsing archives for
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 […]
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’
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
