Gaby Abed

Generate views to correct the column collation on a target DB's tables automatically

You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]

2019-07-05 (first published: )

434 reads

Blogs

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

SQL Server Authentication

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

Covert a string to simple sql datetime format

By Jeff Sims-413169

Can anyone help me out here.  I need to convert strings in a file...

Creating a DB

By Nusc

Hi there, when creating a DB with Auto close= False Auto shrink= True Database...

Reading XML Field from a Table

By AntonyO

I have an xml field  [Risultato] in a Table , the first record is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers