What does # mean in SQL Server? [duplicate]












0
















This question already has an answer here:




  • What is the meaning of “#” in front of a table name in TSQL?

    2 answers




SELECT 

    ACCOUNT_NO,

    SUM(OPEN_BAL) AS OPEN_BAL,

    CONVERT(NVARCHAR(MAX), '') OPEN_BAL_EN,

INTO   

    #OB





sql-server tsql







share|improve this question















marked as duplicate by adiga, Damien_The_Unbeliever sql
Users with the  sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 26 '18 at 7:33


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 1





    # means temp table

    – fa06
    Nov 26 '18 at 6:25






  • 1





    Many Thanks Fa06

    – ANZ
    Nov 26 '18 at 6:27








  • 1





    Please at least do the google before asking any question

    – Gagan Burde
    Nov 26 '18 at 7:03











  • Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

    – saravanatn
    Nov 26 '18 at 7:11











  • How much research effort is expected of Stack Overflow users?

    – adiga
    Nov 26 '18 at 7:35
















0
















This question already has an answer here:




  • What is the meaning of “#” in front of a table name in TSQL?

    2 answers




SELECT 

    ACCOUNT_NO,

    SUM(OPEN_BAL) AS OPEN_BAL,

    CONVERT(NVARCHAR(MAX), '') OPEN_BAL_EN,

INTO   

    #OB





sql-server tsql







share|improve this question















marked as duplicate by adiga, Damien_The_Unbeliever sql
Users with the  sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 26 '18 at 7:33


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 1





    # means temp table

    – fa06
    Nov 26 '18 at 6:25






  • 1





    Many Thanks Fa06

    – ANZ
    Nov 26 '18 at 6:27








  • 1





    Please at least do the google before asking any question

    – Gagan Burde
    Nov 26 '18 at 7:03











  • Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

    – saravanatn
    Nov 26 '18 at 7:11











  • How much research effort is expected of Stack Overflow users?

    – adiga
    Nov 26 '18 at 7:35














0












0








0









This question already has an answer here:




  • What is the meaning of “#” in front of a table name in TSQL?

    2 answers




SELECT 

    ACCOUNT_NO,

    SUM(OPEN_BAL) AS OPEN_BAL,

    CONVERT(NVARCHAR(MAX), '') OPEN_BAL_EN,

INTO   

    #OB





sql-server tsql







share|improve this question

















This question already has an answer here:




  • What is the meaning of “#” in front of a table name in TSQL?

    2 answers




SELECT 

    ACCOUNT_NO,

    SUM(OPEN_BAL) AS OPEN_BAL,

    CONVERT(NVARCHAR(MAX), '') OPEN_BAL_EN,

INTO   

    #OB




This question already has an answer here:




  • What is the meaning of “#” in front of a table name in TSQL?

    2 answers







sql-server tsql




sql-server tsql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 26 '18 at 7:37









a_horse_with_no_name

305k46468564




305k46468564










asked Nov 26 '18 at 6:23









ANZANZ

41




41




marked as duplicate by adiga, Damien_The_Unbeliever sql
Users with the  sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 26 '18 at 7:33


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by adiga, Damien_The_Unbeliever sql
Users with the  sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 26 '18 at 7:33


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.










  • 1





    # means temp table

    – fa06
    Nov 26 '18 at 6:25






  • 1





    Many Thanks Fa06

    – ANZ
    Nov 26 '18 at 6:27








  • 1





    Please at least do the google before asking any question

    – Gagan Burde
    Nov 26 '18 at 7:03











  • Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

    – saravanatn
    Nov 26 '18 at 7:11











  • How much research effort is expected of Stack Overflow users?

    – adiga
    Nov 26 '18 at 7:35














  • 1





    # means temp table

    – fa06
    Nov 26 '18 at 6:25






  • 1





    Many Thanks Fa06

    – ANZ
    Nov 26 '18 at 6:27








  • 1





    Please at least do the google before asking any question

    – Gagan Burde
    Nov 26 '18 at 7:03











  • Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

    – saravanatn
    Nov 26 '18 at 7:11











  • How much research effort is expected of Stack Overflow users?

    – adiga
    Nov 26 '18 at 7:35








1




1





# means temp table

– fa06
Nov 26 '18 at 6:25





# means temp table

– fa06
Nov 26 '18 at 6:25




1




1





Many Thanks Fa06

– ANZ
Nov 26 '18 at 6:27







Many Thanks Fa06

– ANZ
Nov 26 '18 at 6:27






1




1





Please at least do the google before asking any question

– Gagan Burde
Nov 26 '18 at 7:03





Please at least do the google before asking any question

– Gagan Burde
Nov 26 '18 at 7:03













Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

– saravanatn
Nov 26 '18 at 7:11





Kindly refer below link to get all details: stackoverflow.com/questions/2219714/…

– saravanatn
Nov 26 '18 at 7:11













How much research effort is expected of Stack Overflow users?

– adiga
Nov 26 '18 at 7:35





How much research effort is expected of Stack Overflow users?

– adiga
Nov 26 '18 at 7:35












2 Answers
2






active

oldest

votes


















1














The # character denotes a temporary table.






share|improve this answer



















  • 1





    Why didn't you vote to close this obvious duplicate?

    – adiga
    Nov 26 '18 at 7:32



















1














# means Temp table, we add # as the prefix with temp table name
Ex:



    create table #TempTable

    (

        EmpID int, 

        EmpTitle Varchar(50),

        EmpName Varchar(50)

    )



    select * from #TempTable





share|improve this answer





















  • 1





    Nice explanation with example.

    – Shashank Singh
    Nov 26 '18 at 8:54


















2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









1














The # character denotes a temporary table.






share|improve this answer



















  • 1





    Why didn't you vote to close this obvious duplicate?

    – adiga
    Nov 26 '18 at 7:32
















1














The # character denotes a temporary table.






share|improve this answer



















  • 1





    Why didn't you vote to close this obvious duplicate?

    – adiga
    Nov 26 '18 at 7:32














1












1








1







The # character denotes a temporary table.






share|improve this answer













The # character denotes a temporary table.







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 26 '18 at 6:26









MureinikMureinik

186k22138205




186k22138205








  • 1





    Why didn't you vote to close this obvious duplicate?

    – adiga
    Nov 26 '18 at 7:32














  • 1





    Why didn't you vote to close this obvious duplicate?

    – adiga
    Nov 26 '18 at 7:32








1




1





Why didn't you vote to close this obvious duplicate?

– adiga
Nov 26 '18 at 7:32





Why didn't you vote to close this obvious duplicate?

– adiga
Nov 26 '18 at 7:32













1














# means Temp table, we add # as the prefix with temp table name
Ex:



    create table #TempTable

    (

        EmpID int, 

        EmpTitle Varchar(50),

        EmpName Varchar(50)

    )



    select * from #TempTable





share|improve this answer





















  • 1





    Nice explanation with example.

    – Shashank Singh
    Nov 26 '18 at 8:54
















1














# means Temp table, we add # as the prefix with temp table name
Ex:



    create table #TempTable

    (

        EmpID int, 

        EmpTitle Varchar(50),

        EmpName Varchar(50)

    )



    select * from #TempTable





share|improve this answer





















  • 1





    Nice explanation with example.

    – Shashank Singh
    Nov 26 '18 at 8:54














1












1








1







# means Temp table, we add # as the prefix with temp table name
Ex:



    create table #TempTable

    (

        EmpID int, 

        EmpTitle Varchar(50),

        EmpName Varchar(50)

    )



    select * from #TempTable





share|improve this answer















# means Temp table, we add # as the prefix with temp table name
Ex:



    create table #TempTable

    (

        EmpID int, 

        EmpTitle Varchar(50),

        EmpName Varchar(50)

    )



    select * from #TempTable






share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 26 '18 at 7:27

























answered Nov 26 '18 at 7:11









Sanjay Singh ChouhanSanjay Singh Chouhan

615




615








  • 1





    Nice explanation with example.

    – Shashank Singh
    Nov 26 '18 at 8:54














  • 1





    Nice explanation with example.

    – Shashank Singh
    Nov 26 '18 at 8:54








1




1





Nice explanation with example.

– Shashank Singh
Nov 26 '18 at 8:54





Nice explanation with example.

– Shashank Singh
Nov 26 '18 at 8:54



-

Popular posts from this blog

To store a contact into the json file from server.js file using a class in NodeJS

Image
0 I have created three files -contactPresentation.js, contactService.js, contacts.json. I will run the contactService.js file. And it will navigate to contactPresentation.js file that will only choose an option to either add or display a file. If add(), then add the data into add of service file.And the data will be added to the contacts.json file . And if display(), then display the display() of service file. And the display will take the data from contacts.json file. However, i know my code is flawed. Please correct it . I am also getting an error - this.contacts.push(new ContactService(userName, contactNumber, emailId)); ^ TypeError: Cannot read property 'push' of undefined at ContactService.add (e:NodeJSProjectcontactManager2contactService.js:57:23) at new C
Read more

Redirect URL with Chrome Remote Debugging Android Devices

Image
1 How can i redirect an URL with Chrome Remote Debugging Android Devices? like Requestly Chrome extension on desktop. google-chrome debugging url redirect testing share | improve this question edited Nov 24 '18 at 8:16 sachinjain024 14.7k 23 73 129 asked Nov 23 '18 at 16:09 Momen Momen 91 10
Read more

Dieringhausen

Image
Dieringhausen Stadt Gummersbach 50.982777777778 7.5316666666667 165 Koordinaten: 50° 58′ 58″  N , 7° 31′ 54″  O Höhe: 165  (160–245)  m Einwohner: 5055  (30. Jun. 2016) Postleitzahl: 51645 Vorwahl: 02261 Lage von Dieringhausen in Gummersbach Im Hohl ca. 1927–1930 Ansicht von Südwesten bei Bünghausen Dieringhausen (im örtlichen Dialekt Dierkesen ) ist ein Ortsteil von Gummersbach im Oberbergischen Kreis, Regierungsbezirk Köln, Nordrhein-Westfalen (Deutschland). Inhaltsverzeichnis 1 Geographie 2 Geschichte 3 Kultur 3.1 Sehenswürdigkeiten 3.2 Regelmäßige Veranstaltungen 4 Infrastruktur und Wirtschaft 4.1 Verkehr 4.1.1 Schienen- und Busverkehr 4.1.2 Straßen 4.2 Öffentliche Einrichtungen 4.2.1 Schulen und Bildungseinrichtungen 4.2.2 Kirchliche Einrichtungen 5 Persönlichkeiten 5.1 In Dieringhausen geboren 5.2 In Dieringhausen gelebt 6 Einzelnachweise 7
Read more