ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Johnson" <listAcco...@deepcode.co.uk>
Subject RE: How do you set SQL Server 2005 database options with iBATIS?
Date Thu, 07 Feb 2008 16:12:42 GMT
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:ray.wiggins@swingvote.com] 
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;

 


Mime
View raw message