Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What settings is this
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Desktop
Divers
Thread ID:
01610002
Message ID:
01610014
Vues:
39
>>On my computer when I use full name of the table and did not give alias on the table when I use only table name in the query I have no problems, but on some other computers I get "multy-part identifier ... could not be bound".
>>
>>SELECT Table1.Fld1,
>>       Table1.Fld2
>>FROM DataqBase.Schema.Table1
>>WHERE Table1.Fld3 = 3
>>
>>this work on my computer but not on others.
>>
>>
>>SELECT Table1.Fld1,
>>       Table1.Fld2
>>FROM DataqBase.Schema.Table1 Table1 
>>WHERE Table1.Fld3 = 3
>>
>>This works always.
>>I want to know how to turn this option OFF on my computer so I can test my queries.
>>Thank you.
>
>If only one table is used in a query, why do you need to use table's name referring to its columns?
>
>Also, could it be case-sensitive installation of SQL Server?

:-)
This is an example, not the full query.
No, nothing on this server is case or accent sensitive.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform