Hi, Is there a dummy table in SQL Server just like DUAL in Oracle?
Thanks..I don't think so. The MS-SQL scripting language parser has always been able to do without the need for anything like dual, so there has never been one.
-PatP|||EDIT: [sniped]
Don't Need one...
SELECT 'A'
GO
Oracle would be SELECT 'A' FROM DUAL;
DB2 would be SELECT 'A' FROM sysibm.sysdummy1;|||Thats for your reply guys...
Brett, thats the answer I was looking for.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment