Do u need like 1234567891011........15 or u want to manipulate each and every number.

If its 2nd,then make use of while loop by checking the length of the returned string

Can u explain the use of 'set rowcount' with realtime examples. I went thru the Sql help but it didn't impress me..

I can't get what u r tending 2 say.. What's there other than 'Update'

select row from sysindexes where id=object_id('table_name') and indid=0

 is better than

select count(*) from table_name

because the 2nd -scans the whole table whereas the 1st - contains the value itself

Good use of SelfJoin....Welcome David...

create table temp_tab(id1 int identity,id2 int)

insert into temp_tab(id2) values(10)

insert into temp_tab(id2) values(20)

insert into temp_tab(id2) values(30)

delete from temp_tab where id1 =2

--declaring "set identity_insert " dynamically

declare @sql varchar(500), @sql1 varchar(250), @sql2 varchar(250),...

Thankq karl

Use 'sp_executesql' Statement

The index are used for fast retrieval of data,isn't.. then how it doesn't work for your query.. can u put a sample of ur code

Instead of selecting the tables why won't you type the filtering query

Thanq lowell

Do u have any link between the two tables..

How to decrypt a SP...

alzdba query is working properly

Thanq guys..