What is the use of #?

Question

Just wanna know, if what is the use of # symbol beside the table name PaySlip?

CREATE TABLE #PaySlip(
   WorkId int,
   PName nvarchar(max),
   Client nvarchar(max),
   PayPeriod nvarchar(max),
   PayDt nvarchar(max),
   Particulars varchar(max),
   RefInfo nvarchar(max),
      DAmt nvarchar(max),
   CAmt nvarchar(max),
   RunBal nvarchar(max),
   ToDeBit nvarchar(max),
   ToCredit nvarchar(max),
   ToPay nvarchar(max),
   AcctNo nvarchar(max),
   --
   Template nvarchar(max),
   Rate decimal(18,2)
   )

Thanks and regards.

Answer 1

0

This creates a temporary table which is locally scoped to the connection. This temporary table will be automatically dropped when the connection using it is terminated (or the table is explicitly dropped).

You can also have ## global temporary tables which are server scoped, thus accessible by any connection, and automatically dropped when there are no more connections using it.

Finally you can have @ table variables which are scoped to the query and not stored beyond that.

answered Jul 25 '12 at 04:41 AM

SirSQL
4.6k ● 1 ● 3

(comments are locked)

Answer 2

0

The symbol # show the object is temporary

answered Jul 25 '12 at 01:31 PM

basit 1
439 ● 36 ● 54 ● 80

(comments are locked)

What is the use of #?

Follow this question

Related Questions