Answer Posted / parmanand

Access 2000 , i have tried.

select date() as CurrDate
select now() as CurrNow 'This will also work but it will
give you time also.


Output

CurrDate
----------
11/17/2009

CurrNow
----------
11/17/2009 11:00:34 PM

Tell me what is fill factor?

907

---

What part does database design plays a role in performance of an sql server-based application?

925

---

How do I view a trc file?

897

---

Explain the truncate command? : SQL Server Architecture

1091

---

What is a partitioned view?

948

---

Explain some stored procedure creating best practices or guidelines?

869

---

Do you know what is sql injection?

935

---

What is data source view or dsv? : sql server analysis services, ssas

946

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

933

---

Explain what is analysis service repository?

922

---

What is auditing in sql server?

878

---

Define msdb database?

969

---

What is ssl in sql server?

1010

---

What options are available to audit login activity? : sql server security

1090

---

What is a benefit of using an after insert trigger over using a before insert trigger?

928

---