Leon Platt


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2002-05-02

13,063 reads

SQLServerCentral Article

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!

You rated this post out of 5. Change rating

2001-08-14

7,550 reads

SQLServerCentral Article

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

You rated this post out of 5. Change rating

2001-04-24

3,054 reads

Blogs

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

How Redgate’s Test Data Manager Can Enhance Automated Testing

By

A brief overview of the benefits and challenges of automated testing and how Redgate’s...

Read the latest Blogs

Forums

Optional feature error

By GeorgeMayes

I have installed SQL Server Reporting Services 2019 on my Windows 10 machine, and...

SCOM alerts

By ramana3327

Hi, We are receiving alerts from SCOM regarding WMI health has errors. MP has...

Importing Data

By sathishkm

Hi All, I have an excel data that need to to import in SQL...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers