Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty Date to Null converstion
Message
De
04/04/2003 11:14:51
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Empty Date to Null converstion
Divers
Thread ID:
00774054
Message ID:
00774054
Vues:
47
I'm using the following code to trap empty dates coming into the stored procedrue from VFP call. Before I send the parameters in SQLexec(), I change the empty date from {//} to ''blank. I test about 10 dates before issuing the UPDATE. Relying on the default 1900-01-01 seems scary to me. Is there a better way?
if @ORDDATE  = '1900-01-01 00:00:00.000'
   begin
      set @ORDDATE = null
end
Thank You for your input!
Jeff Hart
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform