/ Published in: SQL
sp_ColDefinition will use the metadata tables to create a table result that looks like this :
DECLARE
---------------------
@title_id varchar(6),
@title varchar(80),
@type char(12),
@pub_id char(4),
@price money,
@advance money,
@royalty int,
@ytd_sales int,
@notes varchar(200),
@pubdate datetime(8),
DECLARE
---------------------
@title_id varchar(6),
@title varchar(80),
@type char(12),
@pub_id char(4),
@price money,
@advance money,
@royalty int,
@ytd_sales int,
@notes varchar(200),
@pubdate datetime(8),
URL: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=549&lngWId=5