2008-01-04 (first published: 2003-09-26)
185,347 reads
Leon Platt
Making Dynamic Queries Static
Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!
2002-05-02
13,098 reads
CLIENT SIDE XML - ASP on steroids !
This article demonstrates the ability to use the XML DOM on the client-side browser.
2002-04-11
16,702 reads
ASP - Reaping the benefits of SQL 2000's FOR XML clause.
In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.
2001-11-14
8,153 reads
Pseudo web service using xmlHTTP
This article delves into the mysterious xmlHTTP object and the supporting ASP code. I've got to tell you that I really love using this object. Basically what I like about it is that through xmlHTTP you can expose some or all methods of any ActiveX class to the client-side user. What this means is you are giving the user the capability of calling your back-end Active X controls. And the best part of it all is that the entire communication process takes place behind the scenes!
2001-08-14
7,579 reads
ASP and ADO Gotcha - Duplicate Field Names in a Query
Recently while working on the SQLServerCentral.com site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.
2001-08-10
3,462 reads
IIS Connection Pooling ? ADO Gotcha!
This article by Leon Platt speaks to how you can avoid pulling your hair out when configuring connection pooling for IIS.
2001-05-08
8,149 reads
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,573 reads
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,086 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers