Answer / gautam k panjikar

getdate()

Answer / rajkumar v

select convert(varchar,getdate(),105)

Answer / anto

select getdate()

Answer / mt

select getdate();

Describe the left outer join & right outer join. : sql server database administration

0 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

---

what is the sql equivaent of the dataset relation object ?

0 Answers  

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

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

0 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What are the differences between sql server and mysql.

0 Answers  

---