Answer / gautam k panjikar

getdate()

Answer / rajkumar v

select convert(varchar,getdate(),105)

Answer / anto

select getdate()

Answer / mt

select getdate();

How to check if stored procedure is running in sql server?

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

What is the difference between row_number and dense_rank?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

---

What is indexing and its types?

0 Answers  

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

What is primary key, unique key, and foreign key?

0 Answers  

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

What is store procedure? How do they work? When do you use?

0 Answers  

---