can i get some help ?

i think all the DB gurus are here...can you guys give me some tips ?

is my question understandable ?

Thanks gift for the reply.

Yes, i see its a UML view.

do you mean in UML view mapping becomes the reverse of the Relational view ?

in fact, this is a legal...

ok...but see this

http://img490.imageshack.us/my.php?image=webcz6.png

see the red colored multiplicity

transrecords [one]

account [many]

this is not correct at all ...is not it ?

because, one transaction record holds for one Account only.

and 1...

hi,

probabily, this is not the mistake.

my mistake is somewhere else.

i have used 3 "AND" operator with this SQL query.

How many "AND" operator could be used for a SQL query ?

i am confused , why this does not work.

is it because of there is "," in the values ?

or what is the problem ?

is there anybody here ?

thanks for the response.

here is whats i have found from MSDN

DBCC CHECKIDENT

Checks the current identity value for the specified table and, if needed, corrects the identity value.

Syntax

DBCC CHECKIDENT

...

Nothing understood.

i want to reset the id.

i am using MS SQL server 2000

hi,

whats the proper steps (graphical) to make a table column auto incremented ?

DB SQL Server 2000

>Enterprise manager\yourserver\yourdatabase\tables\yourtable rightclick and >edit.

there is no edit option. do you mean to go to "design view" ?

>Select the column and add the identity property.

>Litle remark. When you enable the...

thank you.

this works fine....you are great.

but, you told

dump is a keyword. Note the color is blue in Query Analyser.

my my SQL server 2000 Query analyser is not showing any blue...

thank you for all the responses. you are all SQL gurus

acally i wanted to make an id kind of thing in my DB table. as soon as i insert any record, this id would changes. so that records are different...

SELECT REPLACE(REPLACE(COLUMN_NAME, ' ', ''), '-', '') ASCOLUMN_ALIAS

FROM TABLE_NAME

SELECT ! i dont want to display .

ASCOLUMN_ALIAS ?...