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!

1 (2)

2002-05-02

12,892 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,409 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,048 reads

Blogs

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Will the principal wait for acknowledgement from mirror?

By coolchaitu

Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....

The log file of my user db is full. Please confirm if below resolves issue

By coolchaitu

Good morning experts, The log file of my user db is full. Could you...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers