Click here to Skip to main content
15,436,489 members

Articles by reshi999 (Tip/Trick: 1)

Tip/Trick: 1

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 5.00

Database Development
26 Apr 2011   Updated: 28 Apr 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 10,390     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.