ALTER PROCEDURE sp_GetLoginInformation ( @userid int output, @UserName nvarchar(50), @Password nvarchar(50) ) as
begin
  ------ VARIABLE TO STORE INFORMATION FROM SELECT STATEMENT
  DECLARE @COL VARCHAR(50);
  IF EXISTS (Select @userid=UserId from tblLoginInfo where UserName=@UserName COLLATE SQL_Latin1_General_CP1_CS_AS and Password=@Password COLLATE SQL_Latin1_General_CP1_CS_AS)
  BEGIN
  ------ ASSIGNING THE VALUE IN DECLARED VAARIABLE THROUGH SELECT STATEMENT
     Select @COL=Column_NAME from tblUserInformation where UserId=@userid;
  END
------------------ USE OF THE DECALRED VARAIBLE IN OTHER QUERY -------------
  INSERT INTO DUMMY_TABLE(DUMMY_COLUMN) VALUES (@COL);

END