Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

What are the types of normalization?

0 Answers  

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

What is spatial and temporal data?

0 Answers  

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

What is log ldf?

0 Answers  

---

What is an indexed view?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What is the default value of CHAR type?

10 Answers   Bosch,

---