Monthly Archives: August 2013

INFORMATION_SCHEMA.ROUTINE_COLUMNS

This query shows the Code behind  of INFORMATION_SCHEMA.ROUTINE_COLUMNS.

Posted in Database Administration, Information Schema | Leave a comment

INFORMATION_SCHEMA.COLUMN_PRIVILEGES

The next script is the Code behind of the INFORMATION_SCHEMA.COLUMN_PRIVILEGES view.

Posted in Database Administration, Information Schema | Leave a comment

COLUMN_DOMAIN_USAGE

Information Schema Views Code behind (INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE)!!!

Posted in Database Administration, Information Schema | Leave a comment

REFERENTIAL_CONSTRAINTS

Information Schema Views Code behind (INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS)!!!

Posted in Database Administration, Information Schema | Leave a comment

CHECK_CONSTRAINTS

Information Schema Views Code behind (INFORMATION_SCHEMA.CHECK_CONSTRAINTS)!!!

Posted in Database Administration, Information Schema | Leave a comment

COLUMNS

Information Schema Views Code behind (INFORMATION_SCHEMA.COLUMNS)!!!

Posted in Database Administration, Information Schema | Leave a comment

Parameter-driven ASC/DESC Sort ( CASE in ORDER BY )

This post is came up from a MSDN forum post that discussed last night . Problem was to write CASE in ORDER BY cluase without using dynamic sql. This is my solution that I just want to share it.

Posted in Joy of T-SQL, T-SQL Tips & Tricks | Leave a comment

TABLES

Information Schema Views Code behind (INFORMATION_SCHEMA.TABLES)!!!

Posted in Database Administration, Information Schema | Leave a comment