Here is some of the changes that will be introduced in SQL Server 2008
- Intellisense - Finally it will be possible to have intellisense in the SQL Server Management Studio (SSMS)
- plug-ins - It will be possible to add plug-ins to SSMS
- Inline variable assignment
Doing this:
DECLARE @var int = 1234
Will be the same as doing this:
DECLARE @var int
SET @var = 1234
- C / C++ / C# syntax - SET @var += 1234