Can anyone send me the written ?? actually how can i write the logic for it....??
On Mon, Nov 30, 2009 at 4:21 PM, Jamie Fraser <[email protected]>wrote: > Why not store > > varchar(6) prefix > int suffix > > so you could store > > ABC-DE and then your suffix - each time you "generate" a new code you > simply call a stored proc which will increment the suffix and return prefix > & suffix. > > > > > On Sun, Nov 29, 2009 at 8:24 PM, aditya chavan <[email protected]>wrote: > >> code is a mixer of string and intiger and my data base is MS SQL 2005 >> so which would be better...?? >> >> >> On Sun, Nov 29, 2009 at 10:07 PM, Cerebrus <[email protected]> wrote: >> >>> string ? varchar ? >>> >>> On Nov 28, 9:49 pm, aditya chavan <[email protected]> wrote: >>> > what datatype should be >>> > kept in database >>> >> >> >
