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 what is lock escalation?

0 Answers  

---

What is resource governor?

0 Answers  

---

What is table value parameters (tvp)?

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

Explain indexed views?

0 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What is sql server replication? : sql server replication

0 Answers  

---

Explain triggers?

0 Answers  

---

What is ACID Property of Transaction?

10 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---