Booleon and Numeric Data Type in SQL Server 2000

Hi all,
I wanna know about, r Sql Server 2000 support the Booleon data type, if yes plz tell how can it use...
and also tell about some common Data type.
Thanx in advance
Sajjad

Boolean in SQL Server is BIT and NUMERIC is numeric it can be used when you need stable rounding in your calculations when money is giving you precision problems. Run a search for Boolean datatype in SQL Server BOL(books online). Hope this helps.

Kind regards,

Gift Peddie

|||

Many thanx for reply,

I got it, but i have another question is that, I wanna store price in database so what datatype is suitable..., and also how can i restrict the user that he place only two character after decimal...

I m using SQL Server 2000...

thanx again

Sajjad

|||

Try this link and look at the code when you open the Shopping Cart and click on the stored procs you will see all the tables with the datatypes. If you install it you can use it with your modifications. Hope this helps.

http://asp.net/CommerceStarterKit/docs/docs.htm