The following snippet shows an easy way to iterate a C# dictionary:
Dictionary<int, string> dictionary = new Dictionary<int, string>();
dictionary.Add(1, "Cat");
dictionary.Add(2, [...]
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, by generating a insert script, from a given table in a very easy way.
All you [...]
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 ALTER COLUMN myColumn TEXT COLLATE database_default
