What are the diifferences between the ms sql server vs mysql?

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

How sql server executes a statement with nested subqueries?

0 Answers  

---

How to create a local temporary stored procedure?

0 Answers  

---

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

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

0 Answers  

---