Viewing 8 posts - 1 through 8 (of 8 total)
@Toby
you are totally right, it is visible in different processes.
kr/Werner
September 2, 2010 at 1:59 am
As this mechanismn is transaction or session relevant,
you cannot use it over two processes.
Just a hint (was mssing in the story): You can check these locks with
select APPLOCK_MODE('dbo','MyMutex','Session')
select APPLOCK_TEST('dbo','MyMutex','Exclusive','Session')...
September 1, 2010 at 5:44 am
In this sample not, because it is defined as varchar(16) and always truncated.
kr/werner
April 12, 2010 at 6:41 am
Yes, i wanted just to remark the comment from Bob, that a string cannot be returned in the return clause.
April 12, 2010 at 5:58 am
This is partly true, because as usual conversion will take place, and if possible to convert the string to an integer it would be returned, otherwise an error occurs
kr/Werner
April 12, 2010 at 5:12 am
Hi,
even a trailing delimiter would not work correct
eg. select * from strtotable('1,',','),
because then the result is 1 and 0 !
kr/Werner
December 14, 2009 at 2:06 am
Nice method, but works only for unique fields!
March 11, 2009 at 7:16 am
There is such a function called Hashbytes (SQLSRV >=2005)
And it is documented.
kr/Werner
January 12, 2009 at 7:14 am
Viewing 8 posts - 1 through 8 (of 8 total)