definite sequence for install?

Is there a definite sequence for applying Windows 2003 SP 1, Reporting
Services SP 2, and SQL Server SP 4? We are looking to avoid a reinstall of
Reporting Services SP 2. At this time, there are no definite plans for any
of the service packs mentioned. What would be the best sequence of events â'
or doesnâ't it matter?The recommendation is to install SQL Server 2000 SP4 before RS 2000 SP2.
Windows 2003 SP1 is independent.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"mfrom" <mfrom@.discussions.microsoft.com> wrote in message
news:FD475C58-E1B9-4E75-8B0D-8FE04E4DF9C6@.microsoft.com...
> Is there a definite sequence for applying Windows 2003 SP 1, Reporting
> Services SP 2, and SQL Server SP 4? We are looking to avoid a reinstall
> of
> Reporting Services SP 2. At this time, there are no definite plans for
> any
> of the service packs mentioned. What would be the best sequence of
> events -
> or doesn't it matter?

Default value: ISNULL()

Hi!

I'm wondering whether it's possible to set up the MS SQL function
ISNULL() as a default value to avoid NULL entries when importing data
into a table?!

For example, I want the column1, to have a 0 (zero) as default value,
when entering/importing data: isnull("column1",0)

I remember that it is possible to set up with a date function like
now(), having for each record the current time as default value. Is
that also with isnull() somehow possible?

Thx a lot!
PeterYou can create a default constraint to specify a default value for a column.
For example:

CREATE TABLE MyTable
(
Col1 int NOT NULL,
Col2 int NULL
CONSTRAINT DF_MyTable_Col1 DEFAULT 0
)
GO
INSERT INTO MyTable (Col1) VALUES(1)
SELECT * FROM MyTable
GO

However, an explicit NULL will override the default constraint value:

INSERT INTO MyTable (Col1, Col2) VALUES(2, NULL)
SELECT * FROM MyTable
GO

If you need to import data containing a mix of nulls and not nulls, you have
options depending on your data source and import tool. In the case of a
query, you could use ISNULL or COALESCE to specify the desired value when
NULL. With DTS, a column transformation could do the job.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
news:1138013760.433105.245790@.g43g2000cwa.googlegr oups.com...
> Hi!
> I'm wondering whether it's possible to set up the MS SQL function
> ISNULL() as a default value to avoid NULL entries when importing data
> into a table?!
> For example, I want the column1, to have a 0 (zero) as default value,
> when entering/importing data: isnull("column1",0)
> I remember that it is possible to set up with a date function like
> now(), having for each record the current time as default value. Is
> that also with isnull() somehow possible?
> Thx a lot!
> Peter