Viewing 6 posts - 1 through 6 (of 6 total)
1) SELECT INTO ....... IS FASTER THAN INSERT INTO.
2) SELECT INTO ....... CREATE NEW TABLE BUT INSERT INTO does'nt create a new table.
IF YOU WANT INSERT DATA ONCE...
September 9, 2008 at 8:39 am
I THINK YOU WANT TO GENERATE EMPLOYEE ID AND ITS DATA TYPE IS INT.
TRY THIS ...
DECLARE @DBName Varchar(50)
DECLARE @MaxId Varchar(500)
DECLARE @ID int
Set @MaxId ='select max(empId)...
September 9, 2008 at 8:17 am
Please describe what do u want to do through these multiple select setements ? do u want to use results (from these statement)
as a single record set?
September 9, 2008 at 5:38 am
thanks to reply.
i think that there is not a data range problem , because
here i m using getdate() for date.
actually when i try...
December 27, 2007 at 12:10 pm
i have already tried this . but same result here.
December 27, 2007 at 11:57 am
dbcc checkident (TransControl, reseed, 0)
September 5, 2007 at 12:00 am