Building SQL Within a Stored Procedure 1

[BoulderBum]

Is it possible to build a SQL string within SQL Server, then execute it only once at the end of proc?

E.G. Can I do something like:

SqlString = 'SELECT * FROM table'
IF NOT @filter IS NULL
SqlString = SqlString + ' WHERE filter = ' + @filter

//Run query according to SqlString

 

[JayKusch]

declare @sqlstring varchar(400)

SET @SqlString = 'SELECT * FROM table'

IF NOT @filter IS NULL

SET @SqlString = @SqlString + ' WHERE filter = ' + @filter

exec (@sql_string)

If @filter is a character string, you will need to enclose it in '' like so ...

SET @SqlString = @SqlString + ' WHERE filter = ' + '''' + @filter + ''''





Thanks

J. Kusch

 

[BoulderBum]

Perfect. I'll try that out.