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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-27 : 11:09:34
|
Arciryon writes "How can I smoothly upsize my SQL with Access functions to SQL-Server?
A typical query might be something like the one below, and the SQL-Server does not recognize the functions. Consequently I have had problems finding a good reference which shows the equivalents between server functions (for example when Now() in Access97 is GetDate() in sql server if I'm not mistaken).
SELECT Timetable.ID, Timetable.Init, Timetable.Date AS Date, Timetable.ProjNr, Timetable.ActNr, Timetable.IntActNr, Timetable.DescrAct, Timetable.Hours
FROM Timetable
WHERE ((Init = '" & sesInit & "') AND (Date >= DateAdd('d', -14, Date())))
ORDER BY Date DESC;" |
|
|
|
|
|
How can I smoothly convert my Access 97 functions to MS SQL Server equivalents?