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

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

---

How we can compare two database data?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

Mention the uses of stored procedures.

0 Answers  

---

Can primary key be null?

0 Answers  

---

What are rows and columns?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---

Explain data warehousing in sql server?

0 Answers  

---