Answer / mohammadali.info

SELECT GETDATE() AS CurrentDateTime

SELECT 'SYSDATETIME' AS FunctionName, SYSDATETIME() AS DateTimeFormat
UNION ALL
SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET()
UNION ALL
SELECT 'SYSUTCDATETIME', SYSUTCDATETIME()
UNION ALL
SELECT 'CURRENT_TIMESTAMP', CURRENT_TIMESTAMP
UNION ALL
SELECT 'GETDATE', GETDATE()
UNION ALL
SELECT 'GETUTCDATE', GETUTCDATE()

Answer / ahamed razik

select getdate()

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

Why de-normalization required?

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

Do you know how to implement service broker?

0 Answers  

---

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

What are commit and rollback in sql?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What is a database in ms sql server?

0 Answers  

---

What is the meaning of sql server?

0 Answers  

---