how to save sql string result in a variable ?

Question

i have a text box from where the id of the user is taken  i wrote a sql query which return the id passed in text box is a teacher or student  i want to store the resulted string in a variable   eg. if  pass 101 in text box the query gives me a record saying role teacher this teacher value i want to store in a variable

Jignesh Kumar · Answer

Hi Subin,   You can use out parameter in SQL procedure   CREATE   PROCEDURE  dbo.uspGetRole @Id  int , @UserRole  int   OUTPUT    AS    SELECT  @UserRole = columnsName    FROM  TableName    WHERE  Id = @Id

Piyush Pansuriya · Answer

Hi Subin, Please share the code. So, we can help you.. Thanks

Shraddha Patel · Answer

you can try this code...... DECLARE  @sqlCommand nvarchar(1000)   DECLARE  @city  varchar (75)   declare  @counts  int    SET  @city =  'New York'    SET  @sqlCommand =  'SELECT @cnt=COUNT(*) FROM customers WHERE City = @city'    EXECUTE  sp_executesql @sqlCommand, N '@city nvarchar(75),@cnt int OUTPUT' , @city = @city, @cnt=@counts  OUTPUT    select  @counts  as  Counts

Subin Thomas · Answer

hey thanks piyush for the response i got the code eventually