You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

What is side by side migration in sql server?

0 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

Is truncate autocommit?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 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,

---

How do I run a trace in sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

What are the security related catalog views? : sql server security

0 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---