Answer / oliva

There are major theoretical differences between temporary tables:
Temp table will show below
create table #T (…)
Table var will show below
And table variables:

declare @T table (…)
scope of table var is only inside the Store Procedure.

Answer / jagadeesh

transation can be rollback in temptable
but in tablevaribale we cannot do this

Answer / kava

instance varialble

In what sequence sql statement is processed?

0 Answers  

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

---

---

How to make remote connection in database?

0 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

What is delete query?

0 Answers  

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

What is a Join and explain its types?

0 Answers  

---

Define inner join in sql server joins?

0 Answers  

---