This can also be accomplished by simply:

SELECT ISNULL(MYDATE,'') FROM MYTABLE

as long as MYDATE is datetime.

Kemp

Most locations set up their SMTP servers to accept mail from only designated IP addresses. Make sure your new SQL Server is included in the list.

As a work around you may try adding a SQL Task that creates a table and populates it with your complex SELECT statement. Your data pump task can just directly export...

To do what you wanted in a stored procedure you could try:

DECLARE @default [datatype]

SELECT @default = (SELECT SUBSTRING(column_default, 2, LEN(column_default) - 2) FROM INFORMATION_SCHEMA.columns

WHERE table_name = 'Country' AND column_name = 'WatchPoint')

Insert...

Phil's solution will return you records when the school matches or the school is null in the database, but I think you want a solution that will return records when...

Take a look at this article on monitoring drive and database free space, http://www.sqlservercentral.com/columnists/mnash/monitoringdriveanddatabasefreespace.asp. It may provide some help.

Kemp

You can add a computer management snap-in to Enterprise Manager to manage a remote computer. Using computer management, a domain administrator can set the password for any local user on...

You can also insert:

'2'',''3'',''4'

There is a good article at http://www.sqldev.net/xp/xpsmtp.htm on using an extended stored procedure to replace SQLMail. This site includes the dll, and examples on using it. This solution also...

There is a command line utility in the System32 directory called odbcconf.exe. Typing odbcconf /h in a command window will popup the utilities options. An example to create a system...