Skip to content

Instantly share code, notes, and snippets.

@mucit
Created May 17, 2011 13:51
Show Gist options
  • Save mucit/976502 to your computer and use it in GitHub Desktop.
Save mucit/976502 to your computer and use it in GitHub Desktop.
sql context_info data sharing across batchs
create proc dbo.setContextUser
@m varchar(15)
as
begin
declare @v varbinary(50) ; set @v = convert(varbinary(50), @m, 0)
SET CONTEXT_INFO @v
print @m + ' set edildi'
end
alter function dbo.getContextUser()
returns varchar(15)
begin
declare @vt varchar(15)
set @vt = CONTEXT_INFO()
set @vt = replace(@vt COLLATE SQL_Latin1_General_CP1_CI_AS, char(0), ' ')
set @vt = RTRIM(lTRIM(convert(varchar, @vt, 0)))
return @vt
end
exec dbo.setContextUser 'ad004080'
print dbo.getContextUser()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment