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 |
|
swati5151
Starting Member
2 Posts |
 Posted - 2009-07-21 : 11:09:18
|
| Hi all,i want to know what does " mean in sql.when i am looking at the code that is generated at the backend of my Bussiness objects tool.i am getting asSELECT T1."PAACCT_CODE"(CHAR( 5)),T1."DDLRX_DLR_SUB_C"(CHAR(5))FROM DFS_View.MDFSQ01 T1;Here in the above query,i am getting the output as PAACCT_CODE AND DDLRX_DLR_SUB_C FROM THE DFS_VIEW.mdfsq01.NEED TO KNOW WHAT THAT TERM & quot means...............swati reddy |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-21 : 11:12:30
|
| its a quoted identifier, this means that if you were to have a field called THIS FIELD, without either " or [, this would cause a syntax error in your code, the same as if your fieldname was a keyword, you could use this method to select from it anyway.Business objects mangles T-SQL anyway and will put these identifiers in for its own purposes, so it knows when it has a fieldname and not a value. |
 |
|
|
swati5151
Starting Member
2 Posts |
Posted - 2009-07-21 : 11:14:01
|
| thanks rick..swati reddy |
|
|
|
|
|
|
& quot means ..?