[@ЕНЫ]

GM Accounts

UP2

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 = 'your 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_account].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_account.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

UP5,6 и 2.2.1, 2.2.2

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 = 'your 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)
PRINT @PrnLine

2.2.3 / 2.2.3.2

ECLARE @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)

Пригодится

//ragezone