troubleshooting Question

SQL Server Stored Procedure.

Avatar of sfazal
sfazalFlag for Canada asked on
Microsoft SQL ServerASP.NETMicrosoft SQL Server 2005Microsoft SQL Server 2008SQL
7 Comments1 Solution541 ViewsLast Modified:
Hi.
I am trying TO call this sp AND it dont EXECUTE the @sql STATEMENT, IF i look it IN watch its EMPTY. what could be the reaosn FOR it.

EXEC Update_Transaction  '22','0',0

CREATE PROCEDURE [dbo].[Update_Transaction]
    @TransactionEntryID INT ,
    @UserID INT ,
    @ID INT OUT
AS
    BEGIN

      DECLARE       @sql VARCHAR(max);

    SET NOCOUNT ON;
        IF @UserID = 0
            BEGIN

                SET @UserID = NULL;

            END
               
                  BEGIN            

SET @sql = 'INSERT  INTO + table1' +
                '( TransactionEntryID ,
                  UserID ,
               
                )
   VALUES ('+ cast(@TransactionEntryID as varchar(100))+', '+ cast(@UserID as varchar(100))   +')'

                                                       EXEC (@sql)
END      
    END
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros