Remaining Part of Dynamic SQL

declare

@a nvarchar(1024),@b nvarchar(256)

set

@a = 'rulename'

set

@b ='stauts =N' + quotename('true','''' )

print

@a

set

@a = 'select ' + @a + ' from [Rule]' + 'where' + ' ' +@b

exec

(@a)

 

 

set

@a = ' select varname + N' + quotename(' ', '''') + ' + operation + N' + quotename(' ', '''') + ' + varvalue + N' + quotename(' ', '''') + 'as Condition , Connector from rulevariables where ruleid=20'

exec

(@a)

--
Regards,
Munish Kalra