Using syntax from, found by googling mailto:

http://www.ianr.unl.edu/internet/mailto.html

MailTo with Multiple Recipients

<a href="mailto:astark1@unl.edu,ASTARK1@UNL.EDU">

Andy

You can assume that UID > 5 are yours to use, unless the model database has had users added, then any new database will reflect the changes to model.

Andy

Since you are probably talking about variables here:

DECLARE @TextString varchar(30), @QuoteString varchar(30)

SELECT @TextString = 'Text String'

 , @QuoteString = 'Andy'+CHAR(39)+'s Quote String'

SELECT QUOTENAME(@TextString,CHAR(39)) AS TextString

 , QUOTENAME(@QuoteString,CHAR(39)) AS QuoteString

You can see that...

I have no links to back this up, but I believe that you will be forced to uninstall SQL Server 2000 and then install SQL Server 7.

The databases are...

I suggest that you add the the parameters -c (for character) or -w (for unicode), with either you need to add the -t"," to change from the default /t (tab)...

Here is an example, and as you can see there is not an easy answer as some workarounds for ISNUMERIC = 1 work for some and not for others, the...

Check here:

http://support.microsoft.com/?id=314530

http://support.microsoft.com/?id=313661

http://support.microsoft.com/?id=296299

http://support.microsoft.com/?id=190606

http://support.microsoft.com/?id=301508

Need to provide a bit more information...

Andy

Where is the query? Did it just stop or has it ever worked? What is your linked server, SQL Server?

DECLARE @server sysname

SET @server = N'MyServer'

IF NOT...

Sorry Jason, I could not resist...

IF EXISTS (SELECT * FROM sysobjects WHERE sysstat & 0xf = 3

  AND id = OBJECT_ID('Animals'))

 DROP TABLE Animals

GO

CREATE TABLE Animals (cat1 int, cat2 int, cat3...

Per Books Online (BOL):

"Only constants and @local_variables can be passed to table-valued functions."

"The value of each declared parameter must be supplied by the user when the function is...

For another approach, Try:

SELECT A.paramname, A.objectid

 --, O.ObjectTable

 , COALESCE(H.LABEL, L.LABEL, T.LABEL, 'Unknown') AS LABEL

FROM @APP AS A

 INNER JOIN @Objecttypes AS O ON A.objecttypeid = O.ObjectTypeID

 LEFT JOIN (SELECT MIN(ID) AS ID,...

IMHO, this is what you get from letting a procedural programmer design the data model. This will work for your example data:

SET NOCOUNT ON

DECLARE @APP TABLE(paramname varchar(10), objecttypeid int, objectid...

In Windows you cannot replace the drive partition you are booted from, so there is a need to "boot from CD" to restore your C: drive.

BartPE is a GNA boot to...

Have you tried to use Enterprise Manager (EM) to Import these text files? This will generate DTS transform for importing files.

Otherwise, try posting a sample of a few rows of...

Try this:

CREATE TABLE DrugNameTable (DrugName varchar(100))

GO

INSERT INTO DrugNameTable (DrugName)

SELECT 'CIPROFLOXACIN 500 MG TAB'

 UNION SELECT 'METOPROLOL TARTRATE 25 MG TAB'

 UNION SELECT 'VINORELBINE TARTRATE 35 MG IN SODIUM CHLORIDE 0.9% INJ 50...