Information générale
Forum:
Microsoft SQL Server
Try single quotes:
DELETE FROM [dbo].[tblVendorMessage] WHERE VEN_VENDOR_NAME = 'A&EMAN1'
Jon
>Using Data Explorer, I entered the following command against a MS Sql Server table
>
>DELETE FROM [dbo].[tblVendorMessage] WHERE VEN_VENDOR_NAME = "A&EMAN1"
>
>and got the error message "Invalid column name 'A&EMAN1'.
>
>I searched in BOL and found "A change to the table required the table to be recreated. When a table is recreated, the triggers attached to that table are automatically recreated as well." but I'm not sure why deleting a row would require recreating the table.
>
>Can someone tell me what this means and what I need to do?
>
>TIA,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement