Question

If table variables only have the scope of their batch, then why can I select from one after using GO?

score 98 · Answer 1 · 2023-09-13T22:40:52.333000

98

Views

If table variables only have the scope of their batch, then why can I select from one after using GO?

Published on 13 September 2023 at 22:40

score 178 · Answer 2 · 2023-09-11T11:41:35.930000

178

Views

Processing data row by row while bulk insert using JSON in SQl server

Published on 11 September 2023 at 11:41

score 252 · Answer 3 · 2023-07-07T18:12:38.327000

252

Views

SQL Server: Cardinality estimation for table variable

Published on 07 July 2023 at 18:12

score 212 · Answer 4 · 2023-03-20T19:58:24.580000

212

Views

How to use a temporary table or table variable within a function when Dynamic SQL required?

Published on 20 March 2023 at 19:58

score 318 · Answer 5 · 2022-09-13T00:04:08.817000

318

Views

How to improve the performance of the SQL query which uses table variable which has more than 50k entries?

Published on 13 September 2022 at 00:04

score 483 · Answer 6 · 2022-04-13T11:14:44.147000

483

Views

I am facing a weird problem when inserting data from an SQL Stored procedure into a table variable

Published on 13 April 2022 at 11:14

score 338 · Answer 7 · 2021-11-08T17:22:07.577000

338

Views

Subquery as parameter into SQL Server UDF

Published on 08 November 2021 at 17:22

score 347 · Answer 8 · 2021-10-04T15:30:26.260000

347

Views

Temp table causing full scan on table unlike Table Variable in a left outer join queries

Published on 04 October 2021 at 15:30

score 33 · Answer 9 · 2021-08-16T11:22:29.873000

33

Views

How to execute the Update method using a variable to call the table?

Published on 16 August 2021 at 11:22

score 221 · Answer 10 · 2021-06-13T10:27:47.723000

221

Views

SQL query with Table variable/Temp Table - which one good in performance

Published on 13 June 2021 at 10:27

score 220 · Answer 11 · 2021-03-09T07:01:27.523000

220

Views

Convert SQL code (as string) into table - dynamic pivot

Published on 09 March 2021 at 07:01

score 373 · Answer 12 · 2020-11-10T17:22:39.083000

373

Views

Using select from a table variable in a LIKE condition

Published on 10 November 2020 at 17:22

score 164 · Answer 13 · 2020-08-26T20:51:09.387000

164

Views

Trying to use a variable in a SQL WHERE IN statement

Published on 26 August 2020 at 20:51

score 185 · Answer 14 · 2020-05-21T18:36:25.747000

185

Views

SQL Table Variable to take correct path if value in column 1 is 0 or Null

Published on 21 May 2020 at 18:36

score 1.2k · Answer 15 · 2020-04-27T12:37:56.593000

1.2k

Views

Can I have table variable in stored procedure in redshift?

Published on 27 April 2020 at 12:37

score 361 · Answer 16 · 2020-02-21T10:52:51.143000

361

Views

Oracle put resultset into variable in FORALL

Published on 21 February 2020 at 10:52

score 245 · Answer 17 · 2019-11-16T04:38:38.217000

245

Views

Must declare the table variable error while creating a TVP function

Published on 16 November 2019 at 04:38

score 264 · Answer 18 · 2019-10-22T13:30:44.217000

264

Views

How to update table variable in stored procedure from another user defined function in SQL Server?

Published on 22 October 2019 at 13:30

score 109 · Answer 19 · 2019-06-25T12:20:21.853000

109

Views

Assigning TABLE typed variables in T-SQL

Published on 25 June 2019 at 12:20

score 582 · Answer 20 · 2019-04-25T05:17:32.383000

582

Views

Different results while inserting into temp table and table variable

Published on 25 April 2019 at 05:17

List Question

If table variables only have the scope of their batch, then why can I select from one after using GO?

Processing data row by row while bulk insert using JSON in SQl server

SQL Server: Cardinality estimation for table variable

How to use a temporary table or table variable within a function when Dynamic SQL required?

How to improve the performance of the SQL query which uses table variable which has more than 50k entries?

I am facing a weird problem when inserting data from an SQL Stored procedure into a table variable

Subquery as parameter into SQL Server UDF

Temp table causing full scan on table unlike Table Variable in a left outer join queries

How to execute the Update method using a variable to call the table?

SQL query with Table variable/Temp Table - which one good in performance

Convert SQL code (as string) into table - dynamic pivot

Using select from a table variable in a LIKE condition

Trying to use a variable in a SQL WHERE IN statement

SQL Table Variable to take correct path if value in column 1 is 0 or Null

Can I have table variable in stored procedure in redshift?

Oracle put resultset into variable in FORALL

Must declare the table variable error while creating a TVP function

How to update table variable in stored procedure from another user defined function in SQL Server?

Assigning TABLE typed variables in T-SQL

Different results while inserting into temp table and table variable

Trending Questions

Popular # Hahtags

Popular Questions