Archives for: "September 2008"
Ultimate guide to the datetime datatypes
Sep 24th
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 »
Cumulative Update package 1 for SQL Server 2008
Sep 23rd
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
Sep 18th
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 »