SQL Conversions - Hex to Int etc.

by John 9. September 2008 01:46

Try running these examples.

PRINT 'Int to Hex' 
SELECT CONVERT(VARBINARY(8), 15987699) 
 
PRINT 'Hex to Int' 
SELECT CONVERT(INT, 0xF3F3F3)

e52e6dc4-6960-42a4-89dd-caa93d3b4373|0|.0

Tags: t-sql

Categories: SQL

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

T-SQL - fn_GetCurrentSQLHere' my helper function which I put in my master_admin database. CREATE &...SQL limitations columns sizes etc.Find it here. SQL Server Architecture (SQL Server 2000) Maximum Capacity Specifica...SQL Log File Optimization. Check/fix your internal fragmentationAs a DBA you've gotta love Kimberly L. Tripp. Here is what she says.8) Check/fix your internal f...

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

The SQL DBA