Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahaneesh
Starting Member
3 Posts |
 Posted - 2002-05-25 : 01:21:37
|
| how can We select a field named 'from' from a table.Also if keyword occured as a field name or table name how can we seperate from queryEdited by - ahaneesh on 05/25/2002 01:48:50 |
|
|
jbkayne
Posting Yak Master
100 Posts |
Posted - 2002-05-25 : 02:09:33
|
| if quoted identifiers are on you can use the following syntax:select "from" from <table> |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-25 : 03:27:23
|
| or select [from] from <tablename>Always remember never use reserve words in your columns or objects name. AFAIK apart from confusing it adversely effects the performance too.-------------------------------------------------------------- |
|
|
|
|
|
|
select a field which is named 'from'