I spent a little time making an simple script that did this for me. It’s a WIP, but I stuck a (very ugly) webpage in front of it and it’s now hosted here if you want to try it: http://execsqlformat.herokuapp.com/ Sample input: exec sp_executesql N’SELECT * FROM AdventureWorks.HumanResources.Employee WHERE ManagerID = @level’, N’@level tinyint’, @level … Read more
Using a global temporary table in this scenario could cause problems as the table would exist between sessions and may result in some problems using the calling code asynchronously. A local temporary table can be used if it defined before calling sp_executesql e.g. CREATE TABLE #tempTable(id int); execute sp_executesql N’INSERT INTO #tempTable SELECT myId FROM … Read more
Here is a simple example: EXEC sp_executesql @sql, N’@p1 INT, @p2 INT, @p3 INT’, @p1, @p2, @p3; Your call will be something like this EXEC sp_executesql @statement, N’@LabID int, @BeginDate date, @EndDate date, @RequestTypeID varchar’, @LabID, @BeginDate, @EndDate, @RequestTypeID