Yeni Cevap 
 
Konuyu Değerlendir
  • 0 Oy - 0 Ortalama
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Server language
Yazar Mesaj
Braxton Çevrimdışı
Member
***

Mesajlar: 20
Katılım: May 2018
Rep Puanı: 0
Mesaj: #1
SQL Server language
Hi,

I have converted a MSD database to an SQL Server Database (SQL 2005) using Access 2007. (success)
I then created a DSN to connect to that database. (success)

If I run a query: SELECT * FROM tblDay;
I get all records. This is a good thing.

If I run a query: SELECT * FROM tblDay WHERE Date = #1/1/2008#;
I get an error that says "incorrect syntax near '#'.

If I run a query: SELECT * FROM tblDAy WHERE Date = '1/1/2008';
I don't get any error, but no records are returned. (There are records with that date in the Date field)

From VB I can view the table and see the properties of the Date field: DateTime
Why does the query using the #date# not work with SQL2005. What should I use or how should I have converted the database so Standard Query Language will work?

It works just fine in using Jet4 on the MDB version.

For More Details:
Creative video marketing studio
14-05-2018 11:47
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
Yeni Cevap 


Benzer Konular...
Konu: Yazar Cevaplar: Gösterim: Son Mesaj
  in which language the SQL is implemented..!! Braxton 0 14 14-05-2018 11:48
Son Mesaj: Braxton

Foruma Git:


Bu konuyu görüntüleyen kullanıcı(lar): 1 Ziyaretçi