user connections linked server report

Technical Article

RE: General UDFs to emulate BITTEST(), BITSET() ?

  • Reply

I'm playing around with your math versions, and I'm not getting quite the result I expected. Did I misinterpret what you had in mind?-----------CREATE FUNCTION dbo.BitClear(@nvalue BigInt, @nposition TinyInt)  RETURNS BigInt AS  BEGIN Declare @nResult Bigint set @nResult = @nValue  ^ Power( 2, @nPosition) Return @nResult END CREATE FUNCTION dbo.BitSet(@nvalue BigInt, @nposition TinyInt)  RETURNS BigInt […]

You rated this post out of 5. Change rating

2004-05-25

Blogs

T-SQL Tuesday #176 One piece of advice that you wish Past you had

By

This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...

T-SQL Tuesday #176: One piece of advice for Past Steve

By

I almost missed this month, so this is also a good #SQLNewBlogger post. I...

Deleting Old Local Git Branches–#SQLNewBlogger

By

I had a lot of local branches for a repo (actually a few repos)....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers