Browse by Tags

SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

Published 9 January 8 7:26 AM | SSQA.net

I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...

Filed under: sql server, databases, dba, function, requirement, tsql, tablename, constraint, values

How do I find the parameters for a specified stored procedure or function?

Published 10 December 7 5:21 PM | SSQA.net

USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , o . name AS object_name , o . type_desc , p . parameter_id , p . name AS parameter_name , TYPE_NAME ( p . user_type_id ) AS parameter_type , p . max_length , p . precision...

Filed under: sql server, function, stored procedure, tsql, schema, parameter

Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

Published 15 October 7 7:59 AM | SSQA.net

How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...

Filed under: sql server, function, system, stored procedure, tsql, best practice, information schema, views, triggers

Enhanced ISNUMERIC() Function

Published 15 July 7 4:14 AM | SSQA.net

It seems often users want to check whether the data has only numbers in a varchar type column. The commonly suggested one is to make use of SQL Server's ISNUMERIC() function. But the problem in using that function is that it will treat some alphabets...

Filed under: sql server, performance, function, tsql, isnumeric