What is t-sql script to take database offline – take database online.

0 Answers  

---

How do I setup a local sql server database?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

How to rebuild the master database?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

What is a function? Give some example?

3 Answers  

---

What is sql service broker?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

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,

---