2020-04-20
779 reads
Views
Insert and Delete SQL Server Data with Views
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
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: 2019-06-26)
434 reads
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
2017-10-05 (first published: 2017-10-02)
4,424 reads
2016-11-11
1,336 reads
2016-10-28 (first published: 2016-10-05)
7,635 reads
2016-07-14
1,426 reads
2016-06-27
1,356 reads
2016-06-09
1,444 reads
Blogs
Daily Coping 5 June 2020
By Steve Jones
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
I’m working on a project where it’s useful to automate environment setup and teardown...
SQL Server Authentication
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Covert a string to simple sql datetime format
Can anyone help me out here. I need to convert strings in a file...
Creating a DB
Hi there, when creating a DB with Auto close= False Auto shrink= True Database...
Reading XML Field from a Table
I have an xml field [Risultato] in a Table , the first record is...
Ask SSC