Answer / subramaniam

sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and
give the date and time for this particular job

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Explain go command in sql server?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What is the difference between ddl and dml?

0 Answers  

---

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

How to rebuild master databse?

0 Answers  

---