|
|
-
|
|
Semi-colons as statement-terminators has been around for as long as I can remember, however, they have only been made mandatory in the newer statements. However, as documented in the T-SQL Syntax Conventions, using semi-colons as statement terminators will be required in a future release of SQL Server. However, care needs to be taken not be use them on batch separators....
|
|
-
|
|
C# language provides many features and null-coalescing operator(??) is one of them. It’s a great operator to check whether object is null and if it is null then it will provide a default value. I have seen most of the people are not using while it’s a g...
|
|
-
|
|
I was needed to convert an string array into the comma delimited string and the old way to do that is too with for loop. But I was sure that there should be some ready made function that will do this very easily. After doing some research I have found...
|
|
-
|
|
Today I asked by my friend for merge statement and identity insert, how to insert identity column data using merge statement? I posted for the merge statement without identity insert. Please read that post first before move ahead. so I would like to pub...
|
|
-
|
|
I have posted a post on Different ways to find End of the month where I showed you five different ways to find out last day of a month. Here is the analysis on how long each method takes to executeI am not using any physical table to store dates and the...
|
|
-
|
|
What should a professional software look like? Does professional software fit for business personel?...
|
|
-
|
|
In this post, we look at the SQL Server installation related DMVs introduced in SQL Server 2008 R2/2012...
|
|
-
|
|
The speaker lineup for the PASS Business Analytics Conference has been announced and I’m really excited to see my name in the list. In case you haven’t heard, PASS BA Conference is the premium conference for business analytics professionals. If you're a...
|
|
-
|
|
Se trata de un truco simple y antiguo que desarolladores que no lo conocen me lo recuerdan cuando utilizan un código complicado que pasa con un bucle al lo largo de la cadena para contar cuántas veces la sub cadena aparece.. El truco es calcular la r...
|
|
-
|
|
This is my first post on NoSql database technologies. There have been drastic changes in database technologies over the few years. Increase in user’s requests, high availability of applications, real time performance forced to think on different databas...
|
|