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

Explain trigger and its types?

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is 1nf normalization form?

0 Answers  

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

What is a partition key?

0 Answers  

---

Explain what is lock escalation?

0 Answers  

---

How can you hide the sql server instances?

0 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---