Delete Table Variable

Question

Delete Table Variable

Rakesh.Chaudhary

SSC Eights!

Points: 901
More actions
July 8, 2013 at 7:22 am

#279967

I am using TableVariable inside Cursor ,So it is not returing the results for all values provided .Its returing only for 1st value to it and then it keep on executing .
-How to delete all data from Table Variable.

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

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

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

DELETE FROM @TableVariableName

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

Rakesh.Chaudhary SSC Eights! Points: 901 More actions · Answer 2

Thanks But Its not working , I want to delete all records from TableVariable

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

What Gail posted will delete all rows from your table variable.

If you want to make your process a lot faster maybe you should consider getting rid of the cursor? Cursors are notoriously slow and should be avoided for most things in sql server. I would be happy to help if you want.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Rakesh.Chaudhary SSC Eights! Points: 901 More actions · Answer 4

Hi,

Thanks yes its working fine , I was doing some mistake last time..

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Rakesh.Chaudhary (7/8/2013)
Hi,
Thanks yes its working fine , I was doing some mistake last time..

So now do you want to get rid of the cursor?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/