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

How column data types are determined in a view?

946

---

How to add more data to the testing table in ms sql server?

1061

---

What is the difference between dropping a database and taking a database offline?

1151

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1030

---

wat wil hapn if we give the both read and deny read permission to user?

2092

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1875

---

Write a sql query to get zero records from a table having n number of records?

1165

---

How can you hide the sql server instances?

1004

---

What is Federation and Federation Member?

92

---

What is meant by referential integrity?

996

---

How to loop through the result set with @@fetch_status?

1321

---

What is serializable?

1027

---

How do you clear a log file?

1031

---

Explain the concepts and capabilities of sql server?

956

---

what are triggers? : Sql server database administration

892

---