Hi

Have a cup of tea & relax for 10 minutes..It works..!!

Ya, I agree with Michael

Hi

Please have a look into this article also

http://www.mssqltips.com/tip.asp?tip=1556

Thanks

Hi ..

Try this one...

declare @tab table (id int,name varchar(10))

insert into @tab (id,name)

select 1,'Sumit' union all

select 1,'Sumit' union all

select 2,'Sumit2' union all

select 2,'Sumit2'

select...

Adding to the above reply,

The following system functions can be used to obtain information about the error that CATCH block to be executed

ERROR_NUMBER() returns the number of the error....

I am sure I wont be studying SQL and wont be a member of this forum either

My opinion abt this problem is

1) Postcode : nvarchar datatype will do the purpose

2) Mobile/Phone No: Go for numeric datatype , if it is having only numeric data.

3) Email:...

Varchar(max) will be suitable for this problem..