Ask Paula!

...bringing you notes from the field...
posts - 55, comments - 17, trackbacks - 0

My Links

News

Article Categories

Archives

Post Categories

.NET Development

Enterprise Integration

Java Development

Mobile/PDA Development

Professional Affiliations

Is there a "DUAL" database equivalent in SQL Server?

There isn't a "DUAL" exactly, but you can test things out in SQL Server in a similar way for example in Oracle to get today's date/time you would type:

SQL> SELECT sysdate from DUAL;

To do the same thing in MS SQL Server type:

SELECT getdate()

Print | posted on Tuesday, June 10, 2008 6:29 AM | Filed Under [ Practical Answers ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by: