Archives for: "September 2008"

Ultimate guide to the datetime datatypes

Posted on Sep 24, 2008 by in SQL Server
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 »
Tags: datetime
2 comments »

Cumulative Update package 1 for SQL Server 2008

Posted on Sep 23, 2008 by in SQL Server
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 »

List all tables with specified field

Posted on Sep 18, 2008 by in SQL Server
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 »
Tags: t-sql