Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:
DECLARE @sql VARCHAR(100)
DECLARE @pk INT
SET @pk = 2
SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)
EXEC (@sql)
EXEC sp_sqlexec @SQL
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.