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()

Can we write ddl in trigger?

0 Answers  

---

What are the two modes of authentication in sql server?

0 Answers  

---

What is the difference between composite index and covering index?

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

---

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Why we should not use triggers?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is the library index called?

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

System variable and temporary variables

0 Answers   Wipro,

---

What types of replication are supported in sql server?

0 Answers  

---