Monday, February 13, 2012

HOW TO CONVERT VAR BINARY TO VAR CHAR IN SQL SERVER

Hi friends

If  You want to convert varbinary data type to varchar i.e. to show  the  actual password in database which is stored in encrypted form then you must run the following query.

Syntax:
select convert(varchar ,emp_pass) from table_name

Example:

select convert(varchar, emp_pass) from login_master

0 comments:

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Powered by Code Imagine