How to setup default value using GETDATE?

Hi, All
On Northwind database in SQL Server 2000, I try to setup default value at
table design windows for "OrderDate" using GETDATE(), but it does not work.
How do I use setup GETDATE default value for date type? Thanks

KaiOn Sun, 09 May 2004 03:39:07 GMT, kai wrote:

>Hi, All
> On Northwind database in SQL Server 2000, I try to setup default value at
>table design windows for "OrderDate" using GETDATE(), but it does not work.
>How do I use setup GETDATE default value for date type? Thanks
>Kai

Hi Kai,

ALTER TABLE MyTable
ADD DEFAULT GETDATE() FOR MyColumn
go

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||What do you mean exactly by 'it does not work'? Note that the default value
is used only when the column is omitted from the INSERT column list.

To add to Hugo's response, it's a good idea to name constraints explicitly
so that subsequent schema maintenance is easier:

ALTER TABLE MyTable
ADD CONSTRAINT DF_MyTable_MyColumn
DEFAULT GETDATE() FOR MyColumn

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kai" <kailiang@.earthlink.net> wrote in message
news:vJhnc.3578$KE6.2982@.newsread3.news.atl.earthl ink.net...
> Hi, All
> On Northwind database in SQL Server 2000, I try to setup default value
at
> table design windows for "OrderDate" using GETDATE(), but it does not
work.
> How do I use setup GETDATE default value for date type? Thanks
> Kaisql

How to set up tools so that reports can be designed on client machine

Sorry if this is really simple.

We will be having a SQL 2005 DB set up which we need developers to be able to design & deploy reports on. The developers will only have remote access to this server across a network. What (&how) is the simplest way to set up the relevant tools (and which specific tools are needed) on the developers machines so that they can design, build & deploy reports to the main server ?

Thanks for any help, Will

You need to have Business Developement Studio on the clients installed, thats all.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Cool.

Thanks

How to set report width?

Hi
I'm trying to set my crystal report width to 18 on the design ruler but it defaults to 19.75 and won't budge!
How do I change the report width??
Ta.Basicaly CR is fiting the report size to your PRINTER default paper size!

To change this go to Section Expert, choose Details and check the
"format with multiple column"
A new tub apear - "layout"
in this tub type the wanted parameter.