syntax i need

Question

Post reply

syntax i need

raghuldrag

Hall of Fame

Points: 3160
More actions
August 27, 2012 at 1:10 am

#260998

while copying row in oracle we can use %type (or) %rowtype is there.....
like the same is any other synatax is there in sql server 2000

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

I don't think so.

That's because in SQL Server, we use set-based queries instead of cursors.

Cursors treat the data row by row, and are thus (usually) slower than set based manipulations.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

raghuldrag Hall of Fame Points: 3160 More actions · Answer 2

raghuldrag

Hall of Fame

Points: 3160

August 27, 2012 at 1:30 am

#1530212

is any other alter natives there ???

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

raghuldrag (8/27/2012)
is any other alter natives there ???

Maybe if you explain what you are trying to do?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

raghuldrag (8/27/2012)
while copying row in oracle we can use %type (or) %rowtype is there.....

Use it for what?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dwain Camps SSC Guru Points: 86978 More actions · Answer 5

Koen Verbeeck (8/27/2012)
That's because in SQL Server, we use set-based queries instead of cursors.

Alas, this is wishful thinking. I wish everybody did. 🙂

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

dwain.c (8/27/2012)
Koen Verbeeck (8/27/2012)
That's because in SQL Server, we use set-based queries instead of cursors.
Alas, this is wishful thinking. I wish everybody did. 🙂

Ssshhttt, I'm trying to brainwash here 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP