Virtual tables in Stored procedures

Posted by Muhsinathk under Sql Server on 6/29/2012 | Points: 10 | Views : 2029 | Status : [Member] | Replies : 3
Hi,
what is the advantage of virtual tables in stored procedure?i want to know more about it?




Responses

Posted by: Sheonarayan on: 6/29/2012 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Please read the article available on this website http://www.dotnetfunda.com/articles/article491-common-table-expressions-in-sql-server.aspx. Now its good to use Temporary table or table variable but to use Common Table Expression.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/29/2012 [Member] Bronze | Points: 25

Up
0
Down
Thank you,
what is the difference between with or without temporay table in stored procedure?

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajkatie on: 6/29/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
You can also refer following link
http://www.sqlteam.com/article/temporary-tables

Rajesh Patel
.Net Trainer(MSCD | MCT | MS)
Brainbench (Asp.Net 4.5 and C# 5.0)

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response