Just to help: This insert the result of Union to the temp table

SELECT *

INTO ttemp

FROM (

SELECT a,b,c

FROM t1

...

Thanks Frank

What is the different between SELECT and SET

DECLARE @var varchar(100)

SELECT @var = 'select * from tablename'

SET @var = = 'select * from tablename'

Wondering where does this transaction log info stored in the SQL Server? How can Lumigent software can get the info while we can't?

Edited by - mlwang on 06/06/2003 12:02:38...

HI,

I would like to share a weird problem that I faced with my webserver. Its about the Date() and Now() function in ASP Programming. Which date format will these functions...

HI, I have face the same problem too last time. To get out of this trouble, i practise using yyy-mm-dd date format for all sql. It does save me ...