There is no sqquence object in SQL Server, instead there is an identity property for tables

use Rtrim funtion

Select * from Tablea,Tableb Where TableA.Fname + ' ' + TableA.Lname = Tableb.Fullname

DO you have any web site or link with regards to that

You can simply check this by enabling Execution plan (Ctrl +K) in the query analyser.

u can use link servers as well

You can add new column to the existing table by this

alter table a add  b int identity(1,1)

but if u want to do a change to an existing column it is...

Good luck and all the best

Then what about a 21 days books

I normally think that if you want to get average knowledge on any software, 21 days books are ok (mind you that is my...

Thank Bell,

But my question is it is not a overflow or divide-by-zero so then why it is giving such a error!

Professional SQL Server 2000 Programming (Programmer to Programmer) by Robert Vieira

more info

http://www.amazon.com/exec/obidos/ASIN/0764543792/102-1276361-4448908

select * from information_schema.routines where Specific_Name not like 'dt%'

great and nice

yes u are correct phillcart.

I just enable all the phases just to give an idea as u said it is not a compulsory thing to do.

you can do this by setting nessesary permisions

Select max(dt)a from ( select max(Date1) dtfrom ads_tariff union select max(Date2) dt from ads_tariff) b