Procedure Variable | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Procedure Variable

I am interested to know whether SQL Server 2005 supports Procedure Variable and View Variable similar to that of Table Variable used in SQL Server 2000 Madhivanan Failing to plan is Planning to fail
No answers Well. Where do I find the major differences between SQL Server 2000 and 2005? Madhivanan Failing to plan is Planning to fail
I would probably start herehttp://www.microsoft.com/sql/2005/productinfo/overview.mspx or download the 2005 BOL. Frankly, I don’t know the answer. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Thanks Frank<br /><br />&gt;&gt;Frankly, I don’t know the answer.<br /><br />Frank, I Frankly say "It is Frank that you say everything Frankly" [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
You must have SQL 2005 CTP installed to have the 2005 books online, so take your chances. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I think you only need to have the 2.0 framework…. [?] —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

That is essential, but still few links and subjects will not work until you have the CTP installed.
I tried on my project laptop exclusively BOL but without CTP it couldn’t work. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Short summary of some new stuff TSQL
Common Table expression
Really useful for handling Tree like Data structure
Navigate top down, Bottom up, Stop at some level, get the node information..etc
ROWNum
Ranking/Dense Rank funtions
Pivot/Unpivot
Very good to pivot and unpivot the data ( as we use in excel) OUTPUT command in UPDATE/DELETE statements
Used to store old and new data. Same like deleted and inserted tables
we use in trigger to hold old and new data
But, there is a limitation, If you Update Huge volume,the system goes for a toss.
Service Broker
Used for messaging,queue..etc .net Integration
Very good one.
Create funtions, datatypes, procedures in .net and use in YUKON
Simple steps..create assembly in .net, Import assembly in YUKON , use it.. XML
Store your xml data as a column, query it, Use in where clause..etc Database Mirroring Templates


Some more to add…. Snapshot Isolation
Two updates at the same time to same data… Non Clustered Indexes
I heard that apart from columns which we use for indexing,
you can store other columns also along with the index keys,
But they will not be part of the index..
I may be wrong..but has to verify.
Thanks for the information [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
]]>