Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

what is a transaction? : Sql server database administration

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  

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

---

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

How to find out what is the default collation in a database?

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---