This is MY favorite tip in QA:

QUICKLY SCRIPTING/TESTING AN OBJECT

If you use QA a lot, you may have noticed that in the ojbect browser you can right click...

Steve,

I would not consider those examples "GOOD".

-- i.e. check constraint

([Telephone] like '([0-9][0-9][0-9])[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]' or

[Telephone] like '[0-9][0-9][0-9].[0-9][0-9][0-9].[0-9][0-9][0-9][0-9]')

You can do similar things for IPs. I guess it is a bit complex but...

I have yet to see a good example of what can be done with the SQLCLR that can't be accomplished with some T-SQL savvy.

I think the idea of the CLR...

You build an assembly that exposes a method for validing a phone number in .NET and add it to your SQL Server 2005 server. You then build a user defined...

What browser are you using?

If you're not using IE (latest), that may be the problem. Also, make sure you

have scrypting enabled in your browser.

Good luck.

It was overkill.

I feel empowered.

Thank you.

Hi, just sticking to what works for me.

I tried a few things: including appending char(10) and char(13) combos.

How do YOU send the results to text or to a file as...

I liked Jarret's T-SQL; so, I took the liberty of improving it(imho) a little bit.

SET NOCOUNT ON

Declare @Statement as nvarchar(500)

DECLARE _cursor CURSOR FOR

select

'exec sp_changeobjectowner ''['

+ s.name...

http://www.sqlservercentral.com/testcenter/standings.asp

Wrong?

Mon! I thought they were referring to osql. Console utility can be a very broad statement.

Displays okay in Mozilla 1.7.3

You may have to check mark a box in Preferences>>Advanced>>System though.

Well, if i ever guessed something right, it was getting this one right.

Well to put it in perspective, try this...

/*

select getdate()

select getdate()-1

*/

select getdate()+2

no errors, just right. Just got to be careful about using keywords in comments; sometimes the interpreter picks them up...

Great lively discussion,

I aggree with Andy. Let us NOT forget why RDBMS were invented. I mean who wants to mess around with the file system, create their...

Trick questions are ok ( but you must have a clue).

However, I feel VOCALLY UNAPPRECIATIVE of "I don't know..." explanations. They're as good as no explanation at all.

I do, still,...

BOL states that varchar(n) are stored in n bytes.

However, the documentation states that (2 bytes = 1 char) below for the following;

nchar(n)

Fixed-length Unicode character data of n characters. n...