generate storedprocedure based on table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Thomas Cournane » generate storedprocedure based on table

generate storedprocedure based on table

Rate Topic

Display Mode

Topic Options

Author

Message

jplebrasseur

Posted Friday, December 04, 2009 7:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 21, 2010 8:27 AM
Points: 1, Visits: 7

select '@' + c.name, col_definition =
case t.name
when 'bigint' then 'bigint,'
when 'int' then 'int,'
when 'smallint' then 'smallint,'
when 'tinyint' then 'tinyint,'
when 'bit' then 'bit,'
when 'decimal' then 'decimal,'
when 'numeric' then 'numeric,'
when 'money' then 'money,'
when 'smallmoney' then 'smallmoney,'
when 'float' then 'float,'
when 'real' then 'real,'
when 'datetime' then 'datetime,'
when 'smalldatetime' then 'smalldatetime,'
when 'sql_variant' then 'sql_variant,'
when 'timestamp' then 'timestamp,'
when 'uniqueidentifier' then 'uniqueidentifier,'
when 'xml' then 'xml,'
else t.name + '(' + cast(c.prec as varchar(50)) + '),'
end
from sysobjects s
inner join sys.syscolumns c on s.id = c.id
inner join sys.types t on t.user_type_id = c.xtype
where s.xtype='U'
and (s.name = 'ProductProv' or s.name = 'ProductStatus')
order by s.name , c.colid
go

Post #828872

« Prev Topic | Next Topic »

Permissions