Char and varchar - performance problem

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Char and varchar - performance problem

Message

20/07/2009 20:33:10

20/07/2009 20:31:21

Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2003

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01413408

Message ID:

01413486

Vues:

>>Using SQL 2005 with SQL Client.
>
>Beat the enemy with their own weapon:
>

>sqlexec(h, [exec sp_executesql N'SELECT * FROM TABLEX WHERE FIELD1 = @P1',N'@P1 char(6)',']+AMES+['], [somealias])
>

Nice!

If it's not broken, fix it until it is.

My Blog