Column names, data types, and lengths
I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2003-05-05
166 reads
I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2003-05-05
166 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We are a team of 32 persons spread across the globe with supportive staff...
I am using SQL server 2008 R2 express edition. Out of below 3 method...
DBAs are being asked to know everything for 6 figures which cap out for...