Monthly Archives: December 2007

When Execute() is better than sp_executesql()

Posted on December 21, 2007 by robkraftmsn

I usually use sp_executesql inside my stored procedures when I need to run some dynamic SQL.  But I recently came across a scenario where this didn’t work.  The maximum size of the input to sp_executesql is 4KB (2GB on 64bit though … Continue reading →

Posted in SQL Server | 1 Comment