Click here to Skip to main content
15,118,172 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
what should i do is?
this value is taken from user interface
SQL
@Script="Select Person_Name from Person where Person_Id=3"


now i have to stored that Person_Name to database using stored procedure?
PLease Help!!!
Posted
Updated 3-Mar-12 19:26pm
v2
Comments
Mahmud Hasan 4-Mar-12 0:25am
   
please explain your question in more detail with some sample code and what you have already tried. It will help you to get good response.
sajan064 4-Mar-12 0:28am
   
how to stored EXEC('select ParamName from Parameter where ParaMId=32') value to any declare variable

1 solution

If the result is always a single row, you can store the value like this

SQL
DECLARE @PName VARCHAR(MAX)
SELECT @PName = Person_Name FROM Person WHERE Person_Id = 3
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900