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

Wiesbaden

Image
Wappen Deutschlandkarte 50.0825 8.24 117 Koordinaten: 50° 5′  N , 8° 14′  O Basisdaten Bundesland: Hessen Regierungsbezirk: Darmstadt Höhe: 117 m ü. NHN Fläche: 203,93 km 2 Einwohner: 278.654 (31. Dez. 2017) [1] Bevölkerungsdichte: 1366 Einwohner je km 2 Postleitzahlen: 65183–65207, 55246, 55252 Vorlage:Infobox Gemeinde in Deutschland/Wartung/PLZ enthält Text Vorwahlen: 0611, 06122, 06127, 06134 Kfz-Kennzeichen: WI Gemeindeschlüssel: 06 4 14 000 LOCODE: DE WIB NUTS: DE714 Stadtgliederung: 26 Ortsbezirke Adresse der Stadtverwaltung: Schlossplatz 6 65183 Wiesbaden Webpräsenz: www.wiesbaden.de Oberbürgermeister: Sven Gerich (SPD) Lage der Landeshauptstadt Wiesbaden in Hessen und im Regierungsbezirk Darmstadt Offizielles Logo der Landeshauptstadt Wiesbaden Flagge der Landeshauptstadt Wiesbaden Wiesbaden is
Read more

Marschland

Image
Kilometerweite Marsch in den Vier- und Marschlanden am Elbdeich Die Wedeler Marschlandschaft in Schleswig-Holstein Der Hadelner Kanal zur Entwässerung der Marsch Die tief gelegene Marsch und ein Entwässerungskanal Das Schöpfwerk Otterndorf im Land Hadeln zur Entwässerung der Medem verfügte damals bereits über die größte Kreiselpumpe Europas. Das Schöpfwerk in Neuhaus für die Aue und des Neuhaus-Bülkauer Kanals Als Marsch(land) (v. niederdt., altsächs. mersc ) – auch Masch , Mersch oder Schwemmland genannt – bezeichnet man eine nacheiszeitlich entstandene geomorphologische Landform im Gebiet der nordwestdeutschen Küsten und Flüsse sowie vergleichbare Landformen weltweit. Inhaltsverzeichnis 1 Landschaft 2 Entstehung 3 Marschböden 4 Nutzung 5 Marschgebiete in Deutschland 6 Siehe auch 7 Literatur 8 Weblinks 9 Einzelnachweise Landschaft | Marschen sind generell flache Landstriche ohne natürliche Erhebungen. Si
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