Well in that case you must be working at a company which name starts with A and ends with ccenture, because I've...

• This reply was modified 4 years, 11 months ago by  sektor81.
• This reply was modified 4 years, 11 months ago by  sektor81.

Yeah, that's what I always do /s

I think that how one can be so greedy by not setting this field as, say, varchar(100) - so that you can be sure it's really enough.

• This reply was modified 4 years, 11 months ago by  sektor81.

@Eirikur Eiriksson, Jeff Moden
Thanks very much! All solutions work perfectly! 

This one was easy 😎

I knew it ))) Thanks for question!

Gila, thanks a lot! This is very convenient syntax. 🙂

This is rather odd behavior since @j-2 belongs to BEGIND/END section. In C#, for instance, this would result error. 

Well, according to SQL Server BOL:

PRIMARY KEY

Is a constraint that enforces entity integrity for a specified column or columns through a unique index. Only one PRIMARY KEY constraint can be...