i never heard about using with in a select query.

what do you mean? can u explain?

thx G

using composite indexes does the performance depend on the columns order in the definition?

if the answer is yes, what wolud be the right order to my query? COL1, COL2,...

i tried with more column names. i called it ID, Counter, RowNumber, etc, but got the same result at each time.

hi!

my solution is the next:

IF 'COL1' NOT IN

(SELECT c.Name

  FROM SYSCOLUMNS c INNER JOIN SYSOBJECTS o ON c.ID = o.ID

  WHERE o.Name = 'TBL1')

 BEGIN 

  ALTER TABLE TBL1 ADD COL1 int...

wow! thats cool!

thank u Jesper!

G

Hi!

I have to mention that u cannot TRUNCATE TABLE if it is being referenced by a FOREIGN KEY constraint.

If u r in this situation use DELETE TABLE & DBCC CHECKINDENT. It works.

Have a nice...

Thanks Lance,

As i dont need to log i found that DBCC CHECKINDENT (TBL1, RESEED, 0) is a perfect solution to my problem, so i get used this method.

Ciao,Gloria

WOW!!!

thanks, David, very much!

i choosed checkindent. it is what i need.

thanks again and have a...

Im using a similar method for generate IDs, but it's not so elegant, that yours.

In the first row, I'd like to change this method to something else. (I...

Yes, you're right! I choosed this way.

Thanks for you, too, SRB!

Bye, Gloria

Thanks very much, Ray!

I am going to think about it.

Ciao,

Gloria

thanks for the quick answers!

So, I have to create an ID which has 3 alphabetic character and 7 number. Not only 'AAA'...

Thanks for all, guys!

Then I'm going to create a trigger. This is the simplier solution, isn't it?

All the best,

Gloria

Hello guys! Thanks for yours answers!

You wrote about views. Can I define a constraint between a table and a view or I...