Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proper syntax when using Table
Message
 
 
À
18/06/2006 23:07:49
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01129884
Message ID:
01129893
Vues:
9
>Well, the following seems to work:
>
>
>SELECT [Table].Numero,[Table].FormTitl_E,[Table].FormTitl_F,
  FormTitl_S,FormTitl_P,[Table].PrimaryKey 
FROM [Table] WHERE [Table]=@Table
>
Yes, it's one of the way to handle reserved words as names in SQL Server. The other way is to use double quotes ("). It's ANSI SQL way but it's requires SET QUOTED_IDENTIFIER ON. I would stick to [].
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform