I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable.
---- SQL Server 2005 Way DECLARE @MyVar INT SET @MyVar = 5 SELECT @MyVar AS TestVar GO ---- SQL Server 2008 Way DECLARE @MyVar INT = 5 SELECT @MyVar AS TestVar GO
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
4 Comments. Leave new
This will be a wonderful feature to have
now when we will upgrade to SQL 2008… that’s another story
It is a nice feature of sqlserver2008
thanks..
Please, help me in the following.
Say, I have 2 Sql Server databases and I sometimes need to pull data from both of them.
SELECT a.* FROM LocalTable a
INNER JOIN
\\ip address\servername\dbname.remote_table b ON a.primarykey=b.somekey
Is there any way to fill the lengthy name of my remote server into a variable and use @var.remote_table in the code shown above? It often creates problem if ip address or servername changes and also makes the code look nasty.
Please help me to get rid of this problem out.