MS SQL Problem

[sibusiso]

HI
er
Can Any one help on how do we create sequnce in ms sql, I can only do in Oracle but not in ms sql

I want to create a sequence and use a sequence in a trigger,
in oracle look like

you have a trigger(before insert new.field 1 := 'FD' || LPAD(CAST(uence name.nextval),n um_field,Leadin g);

Can any one help how to do this.

[debasisdas]

pleaes find a related article here.

[sibusiso]

Thanx I think that Examples will help