Database

Ashfield14-Sep-08 20:56

Ashfield

14-Sep-08 20:56

I believe if you truncate the table that will do it.

Bob
Ashfield Consultants Ltd

Blue_Boy14-Sep-08 22:00

14-Sep-08 22:00

<br />
DBCC CHECIDENT (tablename, RESEED, 0)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Syed Shahid Hussain14-Sep-08 22:55

Syed Shahid Hussain

14-Sep-08 22:55

Thanks But

I'd tried (test is table name)

DBCC CHECIDENT (test, RESEED, 0)
and also
DBCC CHECIDENT ('test', RESEED, 0)

And receive this error message

Server: Msg 2526, Level 16, State 2, Line 2
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

have u any idea about that?

Thanks

Syed Shahid Hussain

Blue_Boy14-Sep-08 23:27

14-Sep-08 23:27

My apologize it iwas my write mistake,the syntax is: DBCC CHECKIDENT (tablename, RESEED, 0)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Syed Shahid Hussain15-Sep-08 1:22

Syed Shahid Hussain

15-Sep-08 1:22

Oh! Now It works Goooooooooooooooooooooooooooooooooood.
I'm Happy Man. Laugh | :laugh:

Really Thanks. Rose | [Rose]

Syed Shahid Hussain

Blue_Boy15-Sep-08 1:24

15-Sep-08 1:24

Never mind dude,I am glad that worked for you.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Difference between Truncate and Delete

nelsonpaixao15-Sep-08 12:12

nelsonpaixao

15-Sep-08 12:12

don´t worry with that Rose | [Rose]

let it be

nelsonpaixao@yahoo.com.br

trying to help & get help

r aa j14-Sep-08 19:57

r aa j

14-Sep-08 19:57

hi all....
what is the difference between truncate and Delete...I have used following code but both are rollback....if anybody knows please reply me..

BEGIN TRANSACTION;
delete from one
rollback TRANSACTION

BEGIN TRANSACTION;
Truncate table one
rollback TRANSACTION

Thanks

Raaj

Re: Difference between Truncate and Delete

Blue_Boy14-Sep-08 21:59

edit view by adding squence number

14-Sep-08 21:59

Difference between Truncate and Delete[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

mahmoudinirat14-Sep-08 2:12

mahmoudinirat

14-Sep-08 2:12

i have view with 2 columns name and salary i want to add a new column with id name the value of this column will changed every 3 rows one time
Example:
id name salary
1 ma 500
1 hh 300
1 uu 200
2 ff 100
2 rr 500
2 tt 111
3 re 333
---
--
-

thank you for help

Blue_Boy14-Sep-08 2:49

14-Sep-08 2:49

You have to add new values in one of tables which is included in view.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

nelsonpaixao14-Sep-08 13:14

nelsonpaixao

14-Sep-08 13:14

that a strange question? D'Oh! | :doh:

can you insert the 3 row in one single procedure or add more columns?

what are you trying to achieve?

nelsonpaixao@yahoo.com.br

trying to help & get help

Rocky#14-Sep-08 17:58

Rocky#

14-Sep-08 17:58

I really think you need to review your requirements.

Rocky

My Blog

Mycroft Holmes14-Sep-08 19:29

Mycroft Holmes

14-Sep-08 19:29

Not enough experience to know a really silly request when it turns up. God knows what the real business requirement is?

Never underestimate the power of human stupidity
RAH

Rocky#14-Sep-08 19:33

Rocky#

14-Sep-08 19:33

well, let's hope they get better with time.

Rocky

My Blog

RyanEK14-Sep-08 20:35

RyanEK

14-Sep-08 20:35

For whatever reason, you could do the following...

select ceiling(cast(row_number() over (order by [field] asc) as float) / 3) as id, *
from [table]

Ryan