quote:

---

- chrhedga's idea cannot be implemented as the query is being generated in a coldfusion page- ans the '03/26/2003' value comes in...

Why do you absolutely want to do this with a function? Is it not possible to do it within a stored procedure?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Rows in SQL Server can never contain more than 8060 bytes (even slightly less in some cases). This means that if you have multiple columns with a definition such as...

Although this was tested on SQL 2000, I think it will work on SQL 7 (don't have one here to test with):

select * from orders

where orderdate between '1996-07-19 00:00:00.000' AND...

Yep, as I said, if they use the same data, then they could have a common database (for this data that is shared between them).

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

To me this is a matter of data, I mean does your apps use the same data, then they should use the same database. Way too many people see a...

I don't think you will find a good non-biased comparison of them. However, if you're just looking for numbers check out NetApp's SQL Server white papers and case studies (http://www.netapp.com/partners/microsoft/sql_server.html).

--

Chris...

Kathi, the reason for this is that the Slammer worm exploits a buffer overflow in the SQL Server listener service that listens on port 1434. This service only exists in...

Yes, you can. How are the written?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Tim's right, using the recordset.Open method with a command object as the first parameter will let you first create and explicitly state values for CursorType, location etc. Here's a small...

quote:

---

Is it possible to configure the ASP interpreter differently from the regional settings in the OS?

---