Something is strange about your code: in the second line you say that you want a static cursor, but when you open the recordset you say that you want a keyset cursor....

The "inserted" and "deleted" pseudo-tables are visible only in the trigger, not in other batches called from the trigger. The solution would be to copy them in a "real" temporary...

I don't think this question should be in the "Administration" category. It's really about programming and it should be in the "SQL Server Development" category.

Razvan

For a detailed explanation of error handling in T-SQL, read an excellent article by Erland Sommarskog, SQL Server MVP:

http://www.sommarskog.se/error-handling-II.html

Razvan

After a long time, Microsoft has finally decided to publish a KB on this issue:

http://support.microsoft.com/default.aspx?kbid=831997

The patch is not available on this page, but you can download a later version...

You should read the following topic from Books Online :

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_02_2248.asp

My understanding of this topic is that the storage of null values highly depends on whether the column is fixed-length...

This should work (but it's untested):

UPDATE YourTable SET PageNumber=(
 SELECT ID FROM YourTable B WHERE B.ImportID=(
  SELECT MIN(ImportID) FROM YourTable C
  WHERE C.ImportID>A.ImportID 
  AND ID LIKE 'Page %'
)) FROM YourTable A

UPDATE...

There is an easier way: dynamic sql. But it works only if you need to convert only one value... so it's kind of useless for you.

DECLARE @Str varchar(36)
SET @Str=N'0x0ae9fc90cf317f4cb0096425bb2bbaf3'

DECLARE...

First thing to notice is that the sample data could not be inserted in the table structure that you provided. For testing, I used the following:

CREATE TABLE dbo.Tbl_EMStatusHistory (
 EMStatusID...

One more thing to notice: if you use "GROUP BY companyname", you should also use "ORDER BY companyname". Usually you get the results ordered even if you don't use ORDER BY, but...

Yes, it will. If you write "SET CONCAT_NULL_YIELDS_NULL OFF" or "SET CONCAT_NULL_YIELDS_NULL ON" (as well as several other SET options) in a stored procedure, then the SP will be recompiled everytime this...

There aren't many suggestions to give in this case. I have only two:

1. If you don't like writing the query by hand (and maintaining it when new types appear), you...

Cory, it's not a bug, it's the correct behaviour. To explain better what I understand of it, let me translate the queries in "Northwind terms"...

The explanation for this question it's a little bit wrong. They say: "... the Delete statement is executed with default option ( NO ACTION ) ..."

There is no such option...

Peter,

There are two different properties: ConnectionTimeout and CommandTimeout.

The first one (ConnectionTimeout) applies only to the Connection object and is used when the connection is established for the first time....