Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

## in sql server..?

3 Posts 3 Posters 0 Views 1 Watching

D Offline
D Offline
DIPAK EMSYS

wrote on last edited by

#1

Hi all, Is there something like ## in sqlserver related to scope of temprory tables.?? which decides the scope of the temp tables?? thanks

dipak
A C 2 Replies Last reply

0
D DIPAK EMSYS

Hi all, Is there something like ## in sqlserver related to scope of temprory tables.?? which decides the scope of the temp tables?? thanks

dipak
A Offline
A Offline
Ashfield

wrote on last edited by

#2

Yes, a single # creates a temp table only available to the connection it was created on, a ## prefix makes temp table available to all connections.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
1 Reply Last reply

0
D DIPAK EMSYS

Hi all, Is there something like ## in sqlserver related to scope of temprory tables.?? which decides the scope of the temp tables?? thanks

dipak
C Offline
C Offline
Coding C

wrote on last edited by

#3

Have a look at this http://www.sqlteam.com/article/temporary-tables http://www.sqlservercentral.com/articles/Basic+Querying/temptablesinsqlserver/1279/

Coding C# ExciteTemplate
1 Reply Last reply

0

Log in to reply