Personal tools
You are here: Home → SQL Server → How To's → Character Sort for SQL SERVER
Navigation
Log in


Forgot your password?
 
Document Actions

Character Sort for SQL SERVER

Character Sort for SQL SERVER 2000 and SQL SERVER 2005



Commands for SQL Server 2000


sp_helpsort


Sp_helptext table_name


Select databasepropertyex ( 'DBNAME', 'collation' )



 

Commands for SQL Server 2005



SELECT CONVERT(char(20), SERVERPROPERTY('SqlCharSet'));

SELECT CONVERT(char(20), SERVERPROPERTY('SqlCharSetName'));
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls