February 27, 2008

DevX - Software Development Resource

Quickly Navigate VS 2005 IDE’s HTML Editor

You can spend a lot of time perusing your ASP.NET pages in HTML view?oftentimes, the amount of HTML makes it difficult to locate little details. But the Visual Studio 2005

DevX - Software Development Resource

Obtain Information About Table Columns in Microsoft SQL Server

To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view: SELECT COLUMN_NAME,columnproperty(OBJECT_ID(TABLE_NAME), COLUMN_NAME, ‘IsIdentity’) as IsIdentity,ORDINAL_POSITION, IS_NULLABLE, DATA_TYPE, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, COLLATION_NAME, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME