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 name of reporting services config file and what’s it’s used for?

146

---

How do you rebuild an identity column?

949

---

What is indexing in sql server with example?

1001

---

What are logical database components? : SQL Server Architecture

1033

---

What do you mean by normalisation?

1041

---

Why SQL Agent is used?

1145

---

Explain the steps needed to create a scheduled job?

930

---

What are the advantages of paper records?

967

---

Explain trigger and trigger types?

978

---

how you can configure a running aggregate in SSRS?

190

---

What is a scheduled job or what is a scheduled task?

952

---

Can we shrink data file in sql server?

1049

---

What is default constraint?

995

---

How to create view in stored procedure sql server?

1015

---

How to see existing views in ms sql server?

1043

---