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
Titre:
Need syntax for Select statement
Divers
Thread ID:
01016740
Message ID:
01016740
Vues:
53
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?
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).
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform