formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
2
> decimals after the period - i.e. 144.55? When I create the column in EM wi
th
> the smallmoney datatype, the precision field is grayed out. Isn't there so
me
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
2
> decimals after the period - i.e. 144.55? When I create the column in EM wi
th
> the smallmoney datatype, the precision field is grayed out. Isn't there so
me
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--sql

formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
Dan D.
Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John
|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Formatting Database Server Need Procedure for Restoring Database

Hello,
I have a database server running windows 2000 server sp4, sql server 2000
sp3. I want to format this server and start fresh with an install of windows
2003 server standard edition and reload sql server 2000. My sql server
knowledge is very basic and I need to have a procedure for bringing the
database back to its current state after the format.
I have set up a test server. I loaded Win 2003 server, sql server 2000, and
sp3 for sql. I don't know if I have to restore my master,model, ect. backups
or if I can just restore my production database?
I copied a .bak file of my database to the test server and tried restoring
it using enterprise manager. Of course the data and log file locations are
going to be on one disk instead of two like the production server but I made
the neccearry change under options. When I click ok on the restore it comes
up with the restore progress windows but its already been and hour and no
progress. I do notice a created .mdf file in the restore path but no
indication of it doing anything else.
Your help is greatly apprecaited. Please contact me at
chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
Thanks,
ChrisHi Chris
When restoring a new database there is usually a period at the beginning
when no bars appear. The larger the database is the longer it takes.
Did you check that the disc was not fragmented before you restored the
database, also did you check there was ample space for the database?
The following should give you a good idea of what you will need to do
http://support.microsoft.com/kb/314546
You need to service pack SQL Server on the new host to the same level as the
existing machine.
John
"Chris Witthoft" wrote:
> Hello,
> I have a database server running windows 2000 server sp4, sql server 2000
> sp3. I want to format this server and start fresh with an install of windows
> 2003 server standard edition and reload sql server 2000. My sql server
> knowledge is very basic and I need to have a procedure for bringing the
> database back to its current state after the format.
> I have set up a test server. I loaded Win 2003 server, sql server 2000, and
> sp3 for sql. I don't know if I have to restore my master,model, ect. backups
> or if I can just restore my production database?
> I copied a .bak file of my database to the test server and tried restoring
> it using enterprise manager. Of course the data and log file locations are
> going to be on one disk instead of two like the production server but I made
> the neccearry change under options. When I click ok on the restore it comes
> up with the restore progress windows but its already been and hour and no
> progress. I do notice a created .mdf file in the restore path but no
> indication of it doing anything else.
> Your help is greatly apprecaited. Please contact me at
> chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
> Thanks,
> Chris