Answer Posted / 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()

What is the difference between osql and query analyzer?

938

---

How to count duplicated values in a column in ms sql server?

997

---

What is an indexing strategy?

943

---

How to defragment table indexes?

931

---

Write a SQL query in order to merge two different columns into single column?

989

---

What is stored in the mssqlsystemresource database? : sql server database administration

987

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

968

---

Explain what are various ways to enhance the ssrs report?

990

---

What are the different types of locks in the database?

872

---

How efficient you are in oracle and SQL server?

1087

---

What is a covering index?

920

---

What are sql azure firewall rules?

106

---

What is the web service used for reporting services?

114

---

Explain left outer join and right outer join?

972

---

What are trace flags?

959

---