😀

😀 😀 ... and now the database would not be slow or maybe corrupt. Now it would...

Hi

I hate to say that but maybe the EAV design may be an option for...

Hi

If you are executing several update statements the previous data will be written before you get the error. To handle this you should use a transaction and a TRY-CATCH block.

Greets

Flo

What the hell??? Six new posts?

Dang! I'm too slow...

Hi

So, my attempt...

If you want to know how to insert a "symbol" into a table the answer depends on the used client side programming language. On database side you have...

Hi ravinegi

I don't want to comment the "very thorough" (I just can confirm the others).

If I overlook this claim there is another problem with your post. As Lutz already denoted...

sqlblue (3/28/2009)

---

Thank you Jeffrey. I did not think that the website would allow attachement,

for the security reason, but that is good to know. Thanks again.

Thank you very much...

Nevertheless my old chief (older C programmer) would say 128byte are quiet much place for BIT masks... 😉

The 0x01 was just an example. Sure it's not nice, but sometimes...

Try to handle it with CONTEXT_INFO and a transaction.

Within your DELETE trigger:

-- ...

BEGIN TRANSACTION

SET CONTEXT_INFO 0x01

-- do your update

SET CONTEXT_INFO 0x00

COMMIT TRANSACTION

Within your UPDATE trigger:

IF (CONTEXT_INFO() = 0x01)

...

Didn't know that other languages are also available.

Thanks!

Flo

Geek! 😛

How did you format the C# code?

Greets

Flo

J (3/28/2009)

---

By default, a column declared as a PRIMARY KEY should be clustered. Looking at the script I did not see anything about dropping an existing clustered index prior to...

Hi sqlblue

Because Jeffrey is absolutely correct I will not attach any compiled assembly ;-).

You asked if you just copy-paste the class so I guess you have Visual Studio. I just...

I don't understand your question. Where are your synonyms from? If they are in database you can use the FOR XML to create the XML file. If they are in...

Yes, it's quiet simple to handle XML in SQL Server since 2k5. If you are using SQL Server 2k the XML functionality is quiet limited. Here a little example:

/*

sample xml:

<root>

...