What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

Why de-normalization required?

0 Answers  

---

What is data source in connection string?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

What do you mean by sql server agent?

0 Answers  

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---

What are the different acid properties?

0 Answers  

---