skip to main | skip to sidebar

Developer Tips & Tricks

Collection of my code from previous project.

Wednesday, July 25, 2007

[SQL] Convert VARCHAR To VARBINARY

Usefull for hinding a value.

DECLARE @Password varchar(50)

SET @Password = 'MLAV'

SELECT CONVERT(varbinary(50), @Password)
Posted by Ayette at 1:19 PM
Labels: T-SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2008 (2)
    • ►  July (1)
    • ►  March (1)
  • ▼  2007 (24)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ▼  July (16)
      • [C#.Net] Get Response Data from 3rd Party Web Service
      • [SQL] Date Functions
      • [SQL] Convert VARCHAR To VARBINARY
      • [ASP.Net] Get Object Value from User Control
      • [SQL] Get Number of Days in a Month Function
      • [SQL] Measuring the time span between two dates
      • [SQL] Retrieves the current date
      • [C#.Net] Code: Determining the Span Between Two Dates
      • [VB.Net] Get Last Day of the Month
      • [JavaScript] Prevent Previous Button/ALT-LEFT
      • [General] MSDE: login failed for user '(null)'. Re...
      • [SQL] Get UniqueIdentifier (Stored Procedure)
      • [ASP.Net] Export To EXCEL file without using Offic...
      • [C#.Net] Convert String data type to GUID data type
      • [C#.Net] Random Numbers
      • [ASP.Net] Prevent caching of page by the browser
    • ►  June (5)

About Me

Ayette
View my complete profile