Tibor Karaszi has updated his Ultimate guide to the datetime datatypes for SQL Server 2008!Remember - SQL Server MVP Frank Kalis, has translated this article to German.http://www.karaszi.com/SQLServer/info_datetime.asp
CU
tosc more »
The Cumulative Update package 1 for SQL Server 2008 (Build 10.00.1763.00) is now available:
http://support.microsoft.com/kb/956717/en-us
CU
tosc more »
DECLARE @COL_NAME NVARCHAR(50)
SET @COL_NAME = '%SOMESTRING%'
SELECT DB_NAME(DB_ID()) AS DatabaseName,
B.name AS TableName,
A.name AS ColumnName
FROM sys.syscolumns AS A INNER JOIN
sys.sysobjects AS B ON… more »