1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE PROCEDURE dbo.W90Pisces_InsertCountry
@countryName as varchar(255),
@zoneID as int,
@currencyKey as INT,
@UpdatedBy as varchar(50),
@InsertListKey as int,
@sessionID as varchar(100)
AS
declare @CountryKey int,
@GroupId as int,
@ClientID as int,
@ClientDb as varchar(50),
@SQL as varchar(4000) ,
@Insert as varchar(4000)
SELECT @GroupID = UserGroup, @ClientID = ClientID, @ClientDb=ClientDb + '.dbo.' FROM ActiveUsers WHERE SessionID = @SessionID
SET @Insert = ' INSERT INTO ' +@ClientDb + 'Country(CountryName, ZoneKey, CurrencyKey, UpdatedBy, ClientID, securityLevel) VALUES ( '+ CONVERT(varchar(255), @countryName) +' , ' + CONVERT(varchar(2), @zoneID) + ' , ' + CONVERT(varchar(3), @CurrencyKey) + ', ' + CONVERT(varchar(50), @UpdatedBy) + ', ' + CONVERT(varchar(3), @ClientID) + ', '+ CONVERT(Varchar(1), '0') +')'
exec(@Insert)
GO |
Partager