Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

Binary Date Conversions

Bitwise OR

TSQL TestBits function for rapidly testing multiple switch settings

Are multiple binary switches becoming hard to manage? The TestBits function can help with that.

RE: Create an ALERT for successful Backup ???

USE MESSAGE 18264 to create the alert!ex:IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Some body run a BACKUP successfuly'))  ---- Delete the alert with the same name.   EXECUTE msdb.dbo.sp_delete_alert @name = N'Some body run a BACKUP successfuly' BEGIN EXECUTE msdb.dbo.sp_add_alert @name = N'Some body run a BACKUP successfuly', @message_id = 18264, @severity […]

Converting Query Results to Negative Numbers -- Totalling Results

I was given the following example to convert data to negative numbers in a given condition:SELECT RecordType, CASE WHEN RecordType = 20 THEN (Quantity_Ord * -1) ELSE Quantity_Ord END AS Quantity_Ordered FROM TABLENAMEIt works great, but I also need to total the results.  When I tell it to sum the quantity_ordered column, SQL keeps giving […]

RE: SQLServerCentrals Shabby State Managment

No. First test is to just visit the site, login, close the browser without logging out. Go back to the site. If you're asked to login, the cookie is not persisting.

RE: DOES Full backup Clear out Transaction Logs?

Understood, but why do they have "Terminate users" option for the Standby option?From many technical paper, it seems to suggest that even Read-only copy, user will get booted off if you have the "terminate users" option selected.Check it out!  It's annoying to have to do the extra step and it's confusing as well. If it […]

RE: scripting views

1. I have around 150 views and ALL can be scripted out. So I don't know what are you talking about. 2. Are you using anything special like schemabinding or are the views dependencies Too Deep ? It may be worth researching a little bit more!