Search Results | SQL Server Performance Forums

XML style cyclical queries

Thread by: ishmell, Feb 23, 2007, 0 replies, in forum: General Developer Questions

Hello all, I need to do some cyclical queries that would probably work much better in an XML hierarchy than this relational SQL database... but I...

update rows during select

Thread by: ishmell, Feb 16, 2007, 2 replies, in forum: SQL Server 2005 General Developer Questions

I know this is probably a newb question, thanks for reading... I want to know how one might go about selecting a bunch of rows while updating a...

SELECT cast( (1 > 2) as bit) ???

Post by: ishmell, Feb 6, 2007 in forum: SQL Server 2005 General Developer Questions

Ahh... thanks! I got it figured.

SELECT cast( (1 > 2) as bit) ???

Thread by: ishmell, Feb 6, 2007, 2 replies, in forum: SQL Server 2005 General Developer Questions

Using MS SQL, does anyone know of a way to evaluate two values to arrive at a bit (boolean) value? I'm looking to do something like this:...

connection pooling across multiple applications

Post by: ishmell, Feb 5, 2007 in forum: SQL Server 2005 General Developer Questions

Hmm... ok thanks. What about using an ODBC DSN? Would connecting to a defined DSN allow for connection pooling between separate applications on a...

connection pooling across multiple applications

Post by: ishmell, Feb 5, 2007 in forum: SQL Server 2005 General Developer Questions

Thanks for your response Brad. Let me explain further. Each instance of this application is doing the same thing... processing records in a queue...

connection pooling across multiple application

Thread by: ishmell, Feb 4, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi there, I have an SQL application that requires several external processing applications. These applications all run on machines separate from the...

connection pooling across multiple applications

Thread by: ishmell, Feb 4, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi there, I have an SQL application that requires several external processing applications. These applications all run on separate machines than the...