table-variable Image

table-variable

question
DRodrigues avatar image
DRodrigues published Default

how to create variables+table (ID & DATE) - SQL

table-variable

0 Likes

0Answers

0 Comments

question
rudi_brits avatar image
rudi_brits asked Default

Can a spatial index be created on a geography column in a table variable

group-by table-variable spatial geography

0 Likes

0Answers

0 Comments

question
DaveC avatar image
DaveC edited Default

Are Table Variables a bad thing?

table-variable temporary-tables table-valued

10 Likes

10Answers

1 Comment

question
fahime avatar image
fahime published Default

merge two table and generate code at the same time

table-variable

0 Likes

1Answer

0 Comments

question
Avi1 avatar image
Avi1 answered Default

table variables

table homework table-variable

0 Likes

1Answer

1 Comment

question
JohnM avatar image
JohnM commented Default

Database compare after restoring to the new server

sql-server-2008-r2 table-variable

0 Likes

0Answers

1 Comment

question
Rafal.Stolzman avatar image
Rafal.Stolzman published Default

find record in Perent table which matches all columns in parent table and all columns and specific number of records in child tables.

table-variable parameter

0 Likes

0Answers

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Index on table variable

sql-server-2008 index table-variable

This question has an accepted answer. Accepted

3 Likes

2Answers

0 Comments

question
Dan21 avatar image
Dan21 answered Default

Use variable SQL based on field value without cursor

table-variable

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

duplicate records while loop

table-variable while-loop

This question has an accepted answer. Accepted

0 Likes

2Answers

2 Comments

question
Tom Staab avatar image
Tom Staab answered Default

Qty from order_tran table should not be greater than qty_in_hand of Items table. how can i manage this?

tables table-variable existing-table

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
tommyfly avatar image
tommyfly commented Default

Columnstore index usage with table variables

performance execution-plan table-variable

This question has an accepted answer. Accepted

0 Likes

1Answer

6 Comments

question
bhanupratapsngh9 avatar image
bhanupratapsngh9 commented Default

Loan EMI Mortgage Calculation

sql-server-2008-r2 cte table-variable temporary-tables iteration

0 Likes

0Answers

4 Comments

question
shoesus27 avatar image
shoesus27 Suspended answered Default

How to Delete Data when using table variables

delete table-variable

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
xxing14 avatar image
xxing14 Suspended answered Default

Impossible Primary Key Violation, Phantom read??

locking primary-key table-variable

3 Likes

1Answer

7 Comments

32 Posts
31 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.