Jump to content

does anyone know the answer to this question?

- - - - -

  • Please log in to reply
No replies to this topic

#1
mmo-dev

mmo-dev

    Learning Programmer

  • Members
  • PipPipPip
  • 87 posts
ok how can u put this mssql query into php login form can anyone help me please
DECLARE @RC int     
DECLARE @id varchar(13)     
DECLARE @pw varchar(13)     
DECLARE @depart varchar(32)     
DECLARE @class varchar(12)     
DECLARE @name varchar(12)     
DECLARE @birthday varchar(10)     
DECLARE @grade int     
DECLARE @subgrade int     
SELECT @id = 'Youre Login'     
SELECT @pw = 'Youre Password'     
SELECT @depart = 'none'     
SELECT @class = 'GM'     
SELECT @name = 'name'     
SELECT @birthday = 'None'
SELECT @grade
SELECT @subgrade 
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade     
DECLARE @PrnLine nvarchar(4000)     
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'     
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users