+ 2

How we can use predefined keywords like 'bit' as a table name in sql server query?

I have a data base that included a table that named 'bit' and I have to use it in my query when I use it as below an error message shows as bellow: select * from bit where bitcode = "102"

30th Sep 2018, 2:26 AM
Amir Rafati
Amir Rafati - avatar
4 odpowiedzi
+ 3
Use square brackets like as below.... Select * from [bit] You can do aliasing of column of tables with predefined names using square brackets. Thanks
30th Sep 2018, 6:06 PM
Jai Verma
Jai Verma - avatar
+ 2
try: select * from 'bit'...
30th Sep 2018, 3:00 PM
Ronen Gil רונן גיל رونين جيل 🏳️‍🌈♾🇹🇩🇮🇱
Ronen Gil רונן גיל رونين جيل 🏳️‍🌈♾🇹🇩🇮🇱 - avatar
+ 1
thanks it works for me
30th Sep 2018, 6:17 PM
Amir Rafati
Amir Rafati - avatar
0
thanks for your care i tried to use it but it does not work
30th Sep 2018, 3:09 PM
Amir Rafati
Amir Rafati - avatar