Anonymous Test User


Technical Article

Retrieve column attributes

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'              […]

5 (1)

2002-07-24

120 reads

Technical Article

Slice out string from within specified delimiters

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

99 reads

Technical Article

String-search on objects in a specified database

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

105 reads

Technical Article

Scalar Function to Determine Age at a Given Date

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

978 reads

Blogs

Is Cataloging Your Data Important?

By

Data continues to be the lifeline for companies across the globe. As maturity levels...

Daily Coping 20 Mar 2023

By

Today’s coping tip is to get outside and notice how the weather feels. This...

Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023

By

 Hello Dear Reader!  What an incredible week we had.  I started off traveling on...

Read the latest Blogs

Forums

Data Problem

By immad

This is the Data ID ----- Date From ------   Date To    ------- 2 ...

Centralized SSIS Server?

By Brandie Tarvin

Has anyone every created / managed a centralized SSIS server? We have a virtualized...

Azure SQL - Restore to lower enviornment

By PJ_SQL

Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers