Hi

If you just want to know how to convert VARCHAR to BIGIN please have a look to BOL for "CONVERT function"

Greets

Flo

Great post #4,000!! 🙂

MarkusB (5/5/2009)

---

Ok, I stayed away from this thread so far and it looks like it's about a lot of other things not related to the quality of the questions but...

Hi

You have to convert your XML to NVARCHAR(MAX), then you can insert into a TEXT column:

UPDATE @t SET MyText = CONVERT(NVARCHAR(MAX), MyXml

Two things:

* TEXT data type is marked as deprecated...

Hi

One way would be to fake the date with DATEADD in case of sundays:

DECLARE @t TABLE (Id INT NOT NULL, DateEntered DATETIME)

INSERT INTO @t

...

Hi

The client side formatting does not depend on the server configuration (except it is returned as VARCHAR). It depends on the client system. Either the regional settings (you wrote that...

Heh...

Just finished my (about 600...) tests and working on the final results. Print, read 10 times, correct 65,345 times... I try to publish end of this week.

Hi Roy

Great article!

Thanks

Flo

Sorry for disturbing the silence of The Thread but I have to get this off my chest...

I HATE EXCEL!! I'm about to finish my first article and want to insert...

Did you try QUOTENAME 😉

DECLARE @dbname NVARCHAR(256)

SELECT @dbname = 'tempdb]; DROP DATABASE master'

PRINT ('select *...

I didn't try but maybe it depends on the fact that column "name" of "model.dbo.sysjobs" is data type "SYSNAME" which is a user defined type.

Try to use CONVERT with type...

Hi

As first, you should XML with "[ code="xml" ]" and "[ /code ]" (without the quotes and spaces). Otherwise it will not appear in forum

As second, the error message would...

Hi

You can use a OPENQUERY for this:

SELECT *

FROM OPENQUERY (Local_Link_Sa, 'ALTER INDEX IX_BigTable_AnyInt ON Sandbox.dbo.BigTable REBUILD SELECT 1')

Just tried and it seems to work. You just have...

Hi Lowell

I'm not sure if it works, but try:

"My Account" -> "Forums Control Panel" -> "Topic Subscriptions" (bottom left corner) -> Select the topic, select "Unsubscribe" on bottom and click...

You can create a scalar UDF which gets the ProductId, DateFiel1 and DateField2 and checks if another Product already exists. Then you can use the UDF in your CHECK constraing.

Greets

Flo