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 |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2008-10-29 : 05:32:36
|
| Hi al,I have a lnked server between SQL and Sybase.All my data looks ok except for 2 columns.These 2columns are named "TIMESTAMP" & "TIME" in sybase.When I link to these columns using visual studio the data within the columns just shows the word timestamp or time repeated.This looks like SQL has avoided returning any values.The Datatype is for TIMSTAMP Column is smalldatetime.Could this be something to do with the fact tha TIMESTAMP and TIME are reserved words in SQL.Is there a work around for this because without these columns I cannot run any reports?Ray.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-29 : 05:34:52
|
| try putting square brackets around ie.[TIMESTAMP] & [TIME] |
 |
|
|
rwaldron
Posting Yak Master
131 Posts |
Posted - 2008-10-29 : 05:49:45
|
| Hiya,I tried select [TIMESTAMP]FROM dbo.dCDNstatI get the error ODBC sybase driver..Incorrect Syntax near [ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-29 : 05:59:45
|
| ok.then post in some Sybase forums. |
|
|
|
|
|
|
Timestamp - Reserved word