C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » SQL Server »

Interview Question??


Posted Date: 04 Nov 2009      Posted By: ATUL C KALAMKAR      Member Level: Silver     Points: 1   Responses: 3



Hi to all,

can anybody tell me that if i create a TEMP table(##abc) inside a
stored procedures(SP1),
and in that store procedures
then i create another Store Procedure(SP2),can i use the TEMP table(##abc) in the SP2 which i have created in SP1.

plz give with reason if yes or no??



Responses
Author: Satish Kumar J    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

when you create global temporary table then you use the temp table, check example at following location

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

HTH

Regards,
Satish
My Blog


Author: ABitSmart    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

## declares the table as Global temporary table. It can be accessed by anyone even across SQL sessions.


Author: Sachin Kulkarni    04 Nov 2009Member Level: SilverRating: 2 out of 52 out of 5     Points: 2

Declare the table as globat temporary table rather than locat temporary table.


Post Reply
You must Sign In to post a response.
Next : What is use of Cache transform in ssis
Previous : Regarding MS Access
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use