January 2009
PermaLink Getting Delimited SQLParams into the SQL IN Clause01/23/2009 08:59 PM
One thing you're always supposed to do with SQL is to use parameters so the SQL server can cache your SQL statements as templates, but when you start using IN clauses, you need to send in delimited values.  There's no native support for this in MSSQL until MSSQL 2008, so you need to use a function to break the parameter back up into a set of values.



(0)

PermaLink Great Products for SMB and Large Companies at Lotusphere 200901/22/2009 01:19 PM
For the large companies that run SAP, Lotus Notes now provides an easy-to-use UI via Alloy.
For SMB companies, Sametime meetings and Lotus Notes email can now be hosted inexpensively at LotusLive.
And for both, ActiveSync is going to be added to Notes Traveler in 2009 (something I've always thought should have been done long ago along w/ Linux support for Traveler
Domino 8.5 also has great support for the iPhone.

(0)

Start Pages
RSS News Feed RSS Comments Feed CoComment Integrated
The BlogRoll
Related Links
Calendar
September 2010
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Search
Contact Me