Re: Problem with boolean return parameter of CallableStatement.exe ... Looks like the Sybase driver is wrong. ... parameter and it does no updating, so the execute method should return true. ... result set and checks that the boolean return parameteris true before then ... Please also show the text of the stored procedure.... (microsoft.public.sqlserver.jdbcdriver)
RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ... (microsoft.public.sqlserver.dts)
RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Variable ... With stored procedures, the other connection... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ... At the end of the process, the created audit record will be ... (microsoft.public.sqlserver.dts)
RE: MS Query "Connections" ... handle that with my connection string.... for using the stored procedure route is that it is faster. ... If you truly want to pass in the query string,... (microsoft.public.excel.programming)
Re: How to navigate recursive stored procedures results ...connection is inherited by the next user, ... beforehand so any residual #Temp tables would be dropped. ... the identity is not "flow"ing to the SQL Server - ... union a SQL query and the results of a stored procedure.... (microsoft.public.dotnet.framework.adonet)