Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From SQL Server to SQL Anywhere
Message
De
09/09/2010 11:23:17
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
09/09/2010 10:52:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01480681
Message ID:
01480687
Vues:
50
Kevin pointed out that you need to declare the data types. I usually quote the dates with this format.
DECLARE @Last_Date  datetime
DECLARE @Last_Time time 

SET @Last_Date='1899-12-30 00:00:00'
SET @Last_Time='00:00:00'
There may be a date setting that will accept the date you used?

Sql Anywhere also will accept ansi standard syntax instead of T-Sql. A small example.
begin 
DECLARE @Last_Date  datetime;
DECLARE @Last_Time time ;

SET @Last_Date='1899-12-30 00:00:00' ;
SET @Last_Time='00:00:00' ;
if <some condition> then 

end if ;

end 
>Obviously, SQL Anywhere cannot handle this syntax:
>
>
>DECLARE @Last_Date 
>DECLARE @Last_Time 
>
>SET @Last_Date=30/12/1899 00:00:00
>SET @Last_Time=00:00:00
>
>
>Anyone would know how we should define our SQL command parameters in that environment?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform