Stored Procedure Problem

Results 1 to 2 of 2

Thread: Stored Procedure Problem

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedure Problem

    This:<BR><BR>Alter PROCEDURE "rq_sp_exportfile"<BR><BR>AS<BR>--start the insert transaction<BR><BR>DECLARE @bcpCommand varchar(2000)<BR><BR>SET @bcpcommand=&#039;bcp rq_table OUT "outtext.txt" -T -c&#039;<BR><BR>EXEC(@bcpCommand)<BR><BR>RETURN<BR> <BR>Gives me this error:<BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use the OUTPUT option when passing a constant to a stored procedure. <BR><BR>Any ideas?

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure Problem

    bcp is not a t-sql statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts