2008-01-04 (first published: 2003-09-26)
185,215 reads
2008-01-04 (first published: 2003-09-26)
185,215 reads
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,070 reads
This article demonstrates the ability to use the XML DOM on the client-side browser.
2002-04-11
16,686 reads
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,137 reads
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,552 reads
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,442 reads
This article by Leon Platt speaks to how you can avoid pulling your hair out when configuring connection pooling for IIS.
2001-05-08
7,955 reads
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,541 reads
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,059 reads
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
No comments about the SQL version. The application is very old doesn’t support newer...
Comments posted to this topic are about the item Combining Silver Tables into a...
Comments posted to this topic are about the item Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers