sql server 2005 triggers
in [Server Configuration]
|
From: Danny on 24 Dec 2009 05:37 I have one variable (ex. @var). I want to create table with the table name contained in the variable. How I can?
From: Uri Dimant on 24 Dec 2009 06:33 Danny Can you please explain why you need it? Do you hope to see the value of the variable as a name of table variable? "Danny" <Danny(a)discussions.microsoft.com> wrote in message news:1365C47A-0463-4E39-8100-03B0AE23B263(a)microsoft.com... >I have one variable (ex. @var). > I want to create table with the table name contained in the variable. > How I can?
From: Erland Sommarskog on 24 Dec 2009 10:41 Danny (Danny(a)discussions.microsoft.com) writes: > I have one variable (ex. @var). > I want to create table with the table name contained in the variable. > How I can? What are you actually trying to achieve? If you want to create tables dynamically, there is a fair chance that you have a flaw in your data model. The fact that the subject line says "SQL Server 2005 triggers" makes me even more nervous. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Pages: 1 Prev: SQL 2005 express database monitoring Next: error 25015 and 0x80121107 |