GM Account Rf 2.2.3

 GM Account Rf  2.2.3 BSB

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 = 2    
SELECT @subgrade = 4    
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)