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

FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

Published 27 October 7 9:45 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, function, bcp, native client, length-prefix, terminator

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

How to find the dependencies on a specified function?

Published 23 July 7 4:29 AM | SSQA.net

Version: SQL Server 2005 Change Database name & function name within the query. USE <database_name>; GO SELECT OBJECT_NAME(object_id) AS referencing_object_name ,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name...

Filed under: function, tsql, dependancies

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

Using table-valued functions (TVF) in SQL Server

Published 29 June 7 3:13 AM | SSQA.net

I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular...

Filed under: sql server, performance, memory, function, tvf, feature, table-valued, .NET