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

Can we insert data into a view?

1127

---

What are the new data types are introduced in sql 2000?

895

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1054

---

How to find the version of sql server? : sql server database administration

1101

---

How do I view a script in sql server?

1033

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1062

---

Why it is recommended to avoid referencing a floating point column in the where clause?

953

---

What is the purpose of sql profiler in sql server?

1012

---

What is the security principal at the database level that represents your session?

929

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1026

---

Is foreign key a primary key?

1072

---

Can you please explain the difference between function and stored procedure?

1000

---

How can we determine what objects a user-defined function depends upon?

992

---

Why I have to use stored procedures?

1029

---

What is ms sql server reporting services?

1047

---