Browse by Tags

Temporary tables existence during Dynamic SQL usage in SQL Server

Published 13 November 8 1:33 AM | SqlServer-QA.net

Here is an interesting question posted in the forums here asking about: Lots of time I face the problem with dynamic sql that I cant get the temporary table with data created through dynamic sql. for instance: SET NOCOUNT ON DROP TABLE Employee CREATE...

Filed under: sql server, insert, tempdb, tsql, dsql, dynamicsql, temporary table

Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"

Published 2 June 8 4:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Error message when you run the bcp utility to copy a result set of a stored procedure that...

Filed under: sql server, kba, stored procedure, bcp, dynamic query, error message, dsql