Given database, owner, table, and column names, this procedure returns one from among several column attributes such as type definition, defaults, and other types of constraints. E.g., to retrieve the type definition of the 'pubs' database's 'author.address':DECLARE @attrib VARCHAR (500) , @msg VARCHAR (8000)EXEC p_get_column_attribute 'TYPEDEF' […]
2002-07-24
115 reads
Scalar function 'f_contains' counts the number of times the first argument occurs within the second argument.Given: @arg1, @arg2 (both VARCHAR), @cnt INTSELECT @cnt = dbo.f_contains (@f_search_for = @arg1 , @f_container = @arg2)
2002-07-22
356 reads
Scalar function 'f_delimited' slices out of a passed-in string, from a specified position inside the string, that segment of it which is delimited on one or both sides by a specified delimiter.Example: Print out a segment of a 'syscomments.text' column for a stored procedure 'p_proc', representing a line of code (i.e., the segment of 'syscomments.text' […]
2002-07-22
93 reads
Procedure 'p_find_string' allows users to specify any database on a server in searching for a specified character string. Supported for string-searching: table columns, view columns, trigger, function, and procedure code. Produces a report showing: object type, owner, object name, column id (for tables and views) or what line number (for triggers, functions, and procedures), and […]
2002-07-22
90 reads
This function was written to supplant cumbersome age-at calculations. To execute, simply set a local INT variable equal to the output of the function. For example, the following, given my birthdate, computes my own age: DECLARE @age_at INT SET @age_at = dbo.f_age_at ('2/16/1954', GETDATE ())
2002-05-09
651 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no...
Comments posted to this topic are about the item Coping with a working life...
Hi, In my sql table, there is a column which have string of text...
Ask SSC