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

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

What are diverse clauses that form a part of sql?

0 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

What is the contrast between sql and pl/sql?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What stored procedure would you use to view lock information?

0 Answers  

---