End user has entered ‘goodmorning’ and ‘good morning’ interchangeably and it was causing logic failure at application level. So task was to replace ‘goodmorning’ with ‘good morning’ in database wherever it is there.
2017-04-28 (first published: 2017-04-10)
1,001 reads
This script is for converting Char to nChar and varchar to nVarchar with the same length.
This process has reduced the manual work by 80% (approximately) in our case.
2017-04-24 (first published: 2017-04-10)
564 reads
This report shows all the Indexes on user defined table or view and how effectively they are being used in our project.
2017-04-20 (first published: 2017-04-10)
882 reads
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
I'm using an ADO Net Source to extract data and running into an issue...
Hi I have below query and i want Cummulative Total . Total should be...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers