|
|
-
|
|
Before a some weeks ago i have posted for some enhancement like Zooming with the query analyzers and also with outputs as well. Here i would like to show the same but some another things also. In this enhancement SQL Server Denali introduces some of changed in query editors. List of changes: 1. Cha......
|
|
-
|
|
I have used Zoom feature with Windows which is inbuilt feature of windows itself or using some external tools but never with SQL Server.
SQL Server Denali arrived with one more feature and that's Zoom/Magnify. I found it somewhat playing with analyzer.
Let's look for the below image for this ......
|
|
-
|
|
Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
But one amazing feature "Output" clause. ...
|
|
-
|
|
In SQL Server 2005 or previous version , whenever I was working to write the script, query or stored procedures at that time if i forgot object names which was going to used in the script, then i was need to get the proper object name by system query or from the list of objects in management studi......
|
|
-
|
|
With earlier version before 2008 of the SQL server, When we need to required hierarchical data at that time we were using the loop to get the data of parent - child hierarchy. And it was make code lengthy , very complex and costly as well.
What should be other feature and alternative for above?......
|
|
-
|
|
In previous version we need to used temporary table to get the result set from stored procedure execution result set for column name change or data type change.
SQL Server 11 arrived with one more tsql enhancement, what's it ?
It is "With Result Sets".
Le't look on small example to explain ......
|
|
-
|
|
<div dir="ltr" style="text-align: left;" trbidi="on">
For security, i have created some users as required access of the databases in SQL instance.<br />
After some days all the logins are working fine but for one login i got failed to connect SQL instance.
<br /><br />
I have tried many times bu......
|
|
-
|
|
I would like to write something new and interesting feature of SQL Server 2011. I am going to introduce "Surround With" feature with small demo here.
It is new enhancement in query editor.
It is used to enclose the t-sql statements in construct with BEGIN...END, IF...ELSE, WHILE.
Le's go......
|
|
-
|
|
In earlier version of SQL server, when we need to SQL pagination then we were using
temp table, Common Table expression or Ranking functions.
One best feature introduced by SQL Server 2011 and that enhancement is with ORDER
BY c......
|
|
-
|
|
SQL Server Denli introduced with new and best feature. This new feature is "Cycle Clipboard Ring".
Using this feature we can copy multiple texts and pate it sequentially with Ctrl + shift + V. Very amazing feature.
Lets look on the below shots.
-- First I am copying this text only
USE MA......
|
|