Ars Technica

MSSQL: sp_executesql - Need to see the TSQL it generates to execute...

I have a weird issue (well weird to me).<BR><BR>I'm using SSSRS and I'm using multivalued parms so people can select multiple values to pass for a single parameter. (i.e. EntryTypeId and they get a ...
Ars Technica

Simple question (maybe?): Why use EXEC on a SQL stored procedure call?

Hi Everyone,<BR><BR>I have (I hope) a simple question: why use EXEC when calling a stored procedure (Microsoft SQL 2005) from a SQL query window?<BR><BR>I can do this:<BR> sp_LinkedServers<BR><BR>or I ...
Houston Chronicle

How to Change an Execute SQL Task in SSIS

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to store ...