I always use a user defined type that equates to VARCHAR(20) and specifies that the phone number must contain at least one numeral.

Things that get put in telephone number fields

• Country...

I would like to add that if everything is working fine on SQL7 and you can install W2K on your new servers then I would limit it your costs to the...

Ditto

I've tried it on the standard edition,  Developers edition and Enterprise Edition so unless there is a QOD edition that I don't know about I can't see how they got...

Personally, given the imminent release of SQL2005 I would not upgrade SQL Server just yet.

This has the feel of a deprecated feature and it has been deprecated for a reason.

Try searching for it on the web let alone BOL!

MIDDLE JOIN will only work if...

Personally I would use the image field type.

You need to write an app that reads the binary representation of the file then use the ADO.Stream object to post the file...

You could try running sp_recompile on your procedure.

Also you have

(select x1 from table1 where val1=main.val1 and weeknum=1),

(select y1 from table1, where val1=main.val1 and weeknum=1),

If this is literally what...

Permissions are assigned to the user so provided that you NT user has logon authority to your SQL box then you should be OK.

As a general point I would assign...

You will need either C++ or Delphi experience to create the extended stored procedures.

The libraries for SQL Server 7 and SQL Server 2000 are different.

I would go with the suggestion...

Are there no combinations of columns in the table that could constitute a unique key?

Couldn't transactionid and trandate consitute a unqiue key?

If you could describe in more detail what it is...

It isn't quite as simple as that.

If your single table breaks normalisation rules then anything you gain on ease of retrieval will be lost on the difficulty of maintaining the...

Unless you class the CAST(dbo.Tokens.Spams AS NUMERIC(18.4)) as simpler, no.

The only time I use CONVERT these days is for Date conversions

CREATE PROC usp_setScore AS

SET NOCOUNT ON -- Suppress record count messages for a performance boost.

--  Declare two variables.

DECLARE @lGoodMails Int , @lBadMails Int

--  Populate the variables with values from table1

SELECT...

Part of my test plans for development includes unit testing my stored procedures with known parameters and comparing the expected results with the actual results.

OK, in a production environment you...

Yes,

If you grant access via database roles then deny write access to the view for that particular role.

If you grant access to users (after a smack on the wrist) deny...