RE: How do you set SQL Server 2005 database options with iBATIS?

[Tony Johnson]

Can you not just add that as part of your SQL statement? Eg:

 

<select...>

      SET NOCOUNT ON;

      SET ANSI_NULL_DFLT_ON ON;

      SET CONCAT_NULL_YIELDS_NULL ON;

      SET ANSI_NULLS ON;

      SELECT field1, field2 FROM myTable ORDER BY field1                    

</select>

 

You could also look at the extends attribute or the include element to bring
the same SET's into each query..

 

Cheers

Tony

 

From: Ray Wiggins [mailto:[EMAIL PROTECTED] 
Sent: 07 February 2008 15:25
To: user-cs@ibatis.apache.org
Subject: How do you set SQL Server 2005 database options with iBATIS?

 

How do you set SQL Server 2005 database options prior to executing a query
with iBATIS?

 

e.g.

      SET NOCOUNT ON;

      SET ANSI_NULL_DFLT_ON ON;

      SET CONCAT_NULL_YIELDS_NULL ON;

      SET ANSI_NULLS ON;