Posted on July 18, 2012, in SQL Server. Bookmark the permalink. Leave a Comment.
-
Recent Posts
-
-
SethThanks Mark - You have a good point - I like this better: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA
-
MarkSeth, why do you use the system tables and not the information_schema views? I thought best practice
-
alexthanks ! VERY HELPFUL !
-
SethThanks Owen. I found this KB article that might help: http://support.microsoft.com/kb/208946
-
OwenGreat post. I believe MS Access does not support ROW_NUMBER, but do you know any work-around to achi
-
VoicuThank you!
-
RonaldFaster would be to use the PIVOT function in T-SQL select * from (select isnull(Color, 'NULL') as Co
-
mountain girlWow! This sounds cool, even for the non-technical among us! Congrats on the new blog!
- SQL Server 2008 Prevent Saving Changes Setting (2)
- Grouping with ROW_NUMBER (2)
- Get List of Columns in a Table (2)
- USING MYSQLDUMP (1)
- HOW TO GET CONDITIONAL SUM AGGREGATES IN A RECORDSET USING THE CASE STATEMENT (1)
- SQL SERVER 2008 COMPREHENSIVE REFRESHER BY PINAL DAVE (0)
- Copy table schema only (0)
- Increasing the mimimum memory used per query (0)
- Grant permissions to SQL Server database users on specific objects (0)
- XQuery Lab 1 (0)
- July 2012 (2)
- June 2012 (1)
- May 2012 (2)
- February 2012 (1)
- November 2011 (1)
- October 2011 (1)
- June 2011 (2)
- July 2010 (2)
- May 2010 (1)
- April 2010 (3)
- March 2010 (3)
- February 2010 (2)
- January 2010 (5)
exec find xml columns get all xml columns list all columns list all columns except one list columns list sql columns list xml columns minimum memory per query min memory sql server prevent saving changes prevent saving changes sql Prevent saving changes that require the table re-creation saving changes is not permitted sql columns sql fieldnames sql server stored prodedure execution sys.columns sys.objects table columns UAC user access control Windows 7- Everything Else (2)
- Linux Administration (2)
- MySQL (1)
- SQL Server (20)
- Uncategorized (1)
-
Blogroll
Top Rated



development and administration, he enjoys C#.NET and Linux development.
Leave a Comment
Comments (0)