Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need syntax for Select statement
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01016740
Message ID:
01016766
Vues:
11
>Try
SET QUOTED_IDENTIFIER ON
>Select "contact[1]", "phone[1]" From Customers
>
>>I have a table, lets call it customers, with the following fields:
>>
>>contact[1]
>>contact[2]
>>contact[3]
>>phone[1]
>>phone[2]
>>phone[3]
>>
>>I want to select the contact[1] and phone[1] fields. What is the syntax to select these two fields? I have tried "Select [contact[1]], [contact[2]] From Customers" and every combination of [] you can think of with no luck. Can someone help me out?

Many thanks, Sergey. That solved my problem.
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.

"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform