> 3. Define reject. generally speaking just ROLLBACK TRANSACTION in the
> trigger and everything will stop when the trigger ends.

"Louis Davidson" <dr_dontspamme_sql@hotmail.com> wrote in message
news:uNyXWXTqFHA.2696@TK2MSFTNGP11.phx.gbl...
> 1. Decimal for sure. Float is an approximate type, which is not good for
> money types.
>
> 2. Sorry for you :) No, I am most sure that they are not. You have to
> stop using the UDDT (like put the data into a compatible type using ALTER
on
> all columns.) Alter your UDDT, then re alter all of the tables. For the
> most part it is suggested to avoid them unless they give you a great
payoff.
>
> 3. Define reject. generally speaking just ROLLBACK TRANSACTION in the
> trigger and everything will stop when the trigger ends.
>
> --
> --------------------------------------------------------------------------
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often
convincing."
> (Oscar Wilde)
>
> "-Qmem-" <na@na.com> wrote in message
> news:e8lCgiPqFHA.3160@TK2MSFTNGP14.phx.gbl...
> > Hi all,
> >
> > 1- Which better data types for money fields, float or decimal? Which i
> > use?
> > (... my money type requires 6 decimal point ...x.123456)
> >
> > 2- I m using User Defined Data Types. Is the UDDT supported Alter with
> > data? When i think change in future.
> >
> > 3-How do i reject new records in triggers?
> >
> > very thanks for help.
> > (sorry my poor language)
> >
> >
>
>

"-Qmem-" <na@na.com> wrote in message
news:e8lCgiPqFHA.3160@TK2MSFTNGP14.phx.gbl...
> Hi all,
>
> 1- Which better data types for money fields, float or decimal? Which i
> use?
> (... my money type requires 6 decimal point ...x.123456)
>
> 2- I m using User Defined Data Types. Is the UDDT supported Alter with
> data? When i think change in future.
>
> 3-How do i reject new records in triggers?
>
> very thanks for help.
> (sorry my poor language)
>
>

<Moshe> wrote in message news:exwNghXqFHA.564@TK2MSFTNGP12.phx.gbl...
>> 3. Define reject. generally speaking just ROLLBACK TRANSACTION in the
>> trigger and everything will stop when the trigger ends.
>
> (untested)
> In case you don't want to rollback the whole transaction which may include
> more commands but just reject an insert, then an instaed-of-trigger will
> do
> it.
>
> "Louis Davidson" <dr_dontspamme_sql@hotmail.com> wrote in message
> news:uNyXWXTqFHA.2696@TK2MSFTNGP11.phx.gbl...
>> 1. Decimal for sure. Float is an approximate type, which is not good for
>> money types.
>>
>> 2. Sorry for you :) No, I am most sure that they are not. You have to
>> stop using the UDDT (like put the data into a compatible type using ALTER
> on
>> all columns.) Alter your UDDT, then re alter all of the tables. For
>> the
>> most part it is suggested to avoid them unless they give you a great
> payoff.
>>
>> 3. Define reject. generally speaking just ROLLBACK TRANSACTION in the
>> trigger and everything will stop when the trigger ends.
>>
>> --
>> --------------------------------------------------------------------------
> --
>> Louis Davidson - http://spaces.msn.com/members/drsql/
>> SQL Server MVP
>> "Arguments are to be avoided: they are always vulgar and often
> convincing."
>> (Oscar Wilde)
>>
>> "-Qmem-" <na@na.com> wrote in message
>> news:e8lCgiPqFHA.3160@TK2MSFTNGP14.phx.gbl...
>> > Hi all,
>> >
>> > 1- Which better data types for money fields, float or decimal? Which i
>> > use?
>> > (... my money type requires 6 decimal point ...x.123456)
>> >
>> > 2- I m using User Defined Data Types. Is the UDDT supported Alter with
>> > data? When i think change in future.
>> >
>> > 3-How do i reject new records in triggers?
>> >
>> > very thanks for help.
>> > (sorry my poor language)
>> >
>> >
>>
>>
>
>