Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

your distribution database is full what will u do

0 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

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

0 Answers  

---