SQL Query in table field

Question

SQL Query in table field

sql_prodigy

SSCrazy

Points: 2254
More actions
October 6, 2008 at 2:17 am

#193656

hi people.
is it possible to save a SQL Query into a table field
and then execute it when a condition arises?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

jacob sebastian SSChampion Points: 11822 More actions · Answer 1

Could you explain what you are trying to achieve?

You could create a TRIGGER on the table and SQL Server will execute the trigger when data is modified (insert/update/delete). Add your code to the trigger that checks for the given condition and execute the desired TSQL statements.

.

Quatrei.X SSCrazy Points: 2697 More actions · Answer 2

Hi there,

Hope this helps...

First lets create some sample data...

CREATE TABLE SprocTable

(

IDINTIDENTITY,

SprocVARCHAR(MAX)

)

GO

CREATE PROC USP_Hi

AS

SELECT 'Hi'

RETURN

GO

CREATE PROC USP_Hello

AS

SELECT 'Hello'

RETURN

GO

INSERT INTO SprocTable

SELECT 'USP_Hi'

UNION

SELECT 'USP_Hello'

SELECT * FROM SprocTable

like so...

Now lets execute our sproc

DECLARE @sproc VARCHAR(MAX)

SELECT @Sproc=Sproc FROM SprocTable WHERE ID = 1

EXEC @Sproc

Please tell me if this was helpful

_____________________________________________
[font="Comic Sans MS"]Quatrei Quorizawa[/font]
:):D:P;):w00t::cool::hehe:
MABUHAY PHILIPPINES!

"Press any key...
Where the heck is the any key?
hmmm... Let's see... there's ESC, CTRL, Page Up...
but no any key"
- Homer Simpson

sql_prodigy SSCrazy Points: 2254 More actions · Answer 3

thanks thats fantastic. exactly what i was looking for...

ChiragNS One Orange Chip Points: 26137 More actions · Answer 4

ChiragNS

One Orange Chip

Points: 26137

October 6, 2008 at 3:26 am

#881006

why do u need such a thing ?

"Keep Trying"

Seggerman-675349 Hall of Fame Points: 3563 More actions · Answer 5

if your proc is not too large, isn't it faster to make it

DECLARE @strSQL NVARCHAR(MAX)

SELECT @strSQL = kode FROM table

EXECUTE sp_executesql @strSQL