Monthly Archives: August 2016
How to replace NULL values with alternate values in SQL Server ?
Assume a scenario where you are trying to get the records from the table where some of the records contains NULL column values and you would like to replace it with an alternate value. How to replace...
How to check if the table exists in a database in SQL Server ?
To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How to check if the table exists in a database in SQL Server ? Here’s a query that gets the t...
SQL Server Tips, Tricks & Myths for .NET developers at Leeds on Au...
LeedsSharp user group is hosting its user group meet on the topic “SQL Server Tips, Tricks & Myths for .NET developers” on August 25 , 2016 from 6.30 PM at Future Labs , 1 Eastgate LS...
Using Expressions for SORT Order in SQL Server
You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order. For example , you wish to sort the Department records by GroupName and forc...
Cognitive services with Martin Beeby at Manchester on August 23 , 2016...
Manchester .NET UserGroup is hosting its August UG Meet on the topic “Cognitive services with Martin Beeby” on August 23 , 2016 from 6.30 PM at 6.30 PM at Spaceport X , 24-26 Lever St, Ma...