How to run a script contained in a Table?

[ton12]

I have a script contained
in a table called TABA.

How can I run the content of a table TABA?
It contains the following script:

CREATE PROCEDURE PROCTest

AS

CREATE TABLE TESTA
--
--

I would like to create a stored Procedure
PROCTEST and a Table TESTA.

Thanks for your suggestions.

Ton

 

[mrdenny]

Take the value of the field and put it into a variable, then execute the variable.

declare @cmd varchar(8000)
SELECT @cmd = Col3
FROM table
WHERE ID = 1
exec (@cmd)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog