Accessing sql server temporary table from asp.net

Question

What I am missing to get data from temporary table. This is showing error like Invalid object name #emp. Please help me I am using Asp.net.

 Dim sqlcmd = New SqlCommand("select * into #emp from employees", conn)
 sqlcmd.ExecuteNonQuery()

 sqlcmd = New SqlCommand("select * from  #emp", conn)
 Dim dr As SqlDataReader = sqlcmd.ExecuteReader

See Above query is working fine and data is going into temporary table. but it is not selecting again through second one query.

Thanks

marc_s · Accepted Answer · 2016-10-09 15:29:07Z

2

Try to use Global Temporary table instead of Local Temporary tabel like.. ##emp

or

You can just use a stored procedure which has all the SQL statement you want to execute and return your desired recordset.

edited Oct 9, 2016 at 15:29

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 7, 2012 at 20:18

gunvant.k

1,0861 gold badge10 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Accessing sql server temporary table from asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related