Tag Archives: SQL Server

How to export your SQL Server table – the easy way

Since I work as a consultant I always bring with me my “toolbox”. My latest addition to this toolbox is a SQL Server script created by Narayana Vyas Kondreddi He has created a script that let you export your data, … Continue reading

Posted in SQL Server | Tagged , , | Comments Off on How to export your SQL Server table – the easy way

How to change a column collation to the default database collation

If you for some reason needs to change the collation of a column in SQL Server to the default database collation, you can use the following syntax: ALTER TABLE <table_name> ALTER COLUMN <column_name> <current_data_type> COLLATE database_default Eg.: ALTER TABLE myTable … Continue reading

Posted in SQL Server | Tagged , , | 1 Comment