Aaron Rouse wrote: > I do not use MSSQL much but wouldn't it just be something like: > > SELECT GETDATE() > > For some reason I was thinking MSSQL will let you do a select with no from.
getdate() has overhead. how about: SELECT 1 in Oracle I always did SELECT 1 FROM DUAL. Access doesn't like "SELECT 1" and has no dummy table so I actually created a table called "DUAL" in Access for ease of coding in blogcfm so i could actually write code to be nearly all the same. doing SELECT @@IDENTITY or SELECT GETDATE() both require the server to do "some" work.. calculate the time, get the last identity, etc. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
