I am creating one Stored Procedure where want to use concatination in that. For that I had written the query but I am unable to do it, so I need help for this.
My SQL query is:
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE Team
SELECT * FROM Emp WHERE ID = @Int + '@str'
In @str is we are passing the value at run time (like @str =AND NAME = 'Test')
Actuall quey is:
SELECT * FROM Emp WHERE ID = 1 AND NAME = 'Test'
Thanks in advance
View Complete Post