|
|
-
Manas Ranjan Dash Commented 6 Months ago through Blogs | 1 Point
newid() returns one globally unique identifier and the result set is randomly sorted, also it return a single random row, so query2 is returning only one item in random way....
|
|
|
-
Manas Ranjan Dash Liked 6 Months ago through Blogs | 1 Point
You may worked with Service Broker in SQL Server. I am just learned Service Broker and implemented practically with an examples which i evaluated. Before moving on it i would like to introduce service broker, not in the deep but having some overview.
Se...
|
-
Manas Ranjan Dash Liked 6 Months ago through Blogs | 1 Point
Recently I have posted for Service Broker for single database in which i have explained it with table history example and it was invoked within trigger. It was a for single database, here i will explain service broker for between databases. In earlier p...
|
-
Manas Ranjan Dash Liked 6 Months ago through Blogs | 1 Point
While working on the query editor, I often find myself requiring to switch over to the Object Explorer window. In such cases, I use a little known, underappreciated feature hidden within the pop-up menu of the query explorer. Today, I share this SSMS pr...
|
|
|
|
|
|
|
-
Manas Ranjan Dash Commented 7 Months ago through Blogs | 1 Point
First is using alias and second escape sequence....
|
|
|