sagar Bhosale

sagar Bhosale

  • NA
  • 179
  • 175.2k

how to insert value into temp table in encrypted format

Nov 12 2011 4:24 AM
how  to insert value  into temp table in encrypted format
this my sp i want to insert  my pwd in encrypted format plz help me
ALTER PROCEDURE [dbo].[QueryEditor]
  -- Add the parameters for the stored procedure here
 
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  -- Insert statements for procedure here
  Declare  @TempTable Table
   (
   
    LID varchar(50),PWD varchar(50) 
   )

  INSERT INTO @TempTable (LID,PWD) values ('Admin','Admin')
 
  SELECT * FROM @TempTable


 


END



Answers (1)