make SQL output so I can run it in SSMS
in the SQL output window instead - the parameters emitted as coments are not executable.
Putting them on separate lines with a declare in-front and the appropriate type in-front would be very useful
e.g. instead of
-- Region Parameters
-- @year_0='2024' (DbType = Int16), @period_1='5' (DbType = Int16)
-- EndRegion
output:
-- Region Parameters
-- declare @year_0 int ='2024' -- (DbType = Int16)
-- declare @period_1 int ='5' -- (DbType = Int16)
-- EndRegion
3
votes
Richard McCormack
shared this idea