Format() Function in MS SQL

HI,

I'm pretty new to MS SQL,

My problem is setting ....

=Format$(Date(),"mm" & "/1/" & "YYYY")

(Which is from my MS ACCESS database)

as my default value in MS SQL. How can I do this since format() does
not seem to be a function that is in MS SQL. The above function works
great in MS ACCESS, but not in MS SQL.

thanks

.

Relevant Pages

  • Re: Converting from Access to SQL2k via Excel- HELP!!!!!
    ... the fact that I had to go from an old/reliable access database to a new SQL ... If you modify it to use a tab - ... I have the format of the files that I must create and I have ...
    (microsoft.public.access.conversion)
  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Anyone tell me whats wrong with this SQL statement?
    ... That sounds like an SQL error telling you that you are not accounting ... am also working on a Photo Album which uses an Access ... > PS - just to cover every area, the data types in Access database are as ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Calling SQL Stored Proc from Access (with Parameters)
    ... You can put the code in the after update of your "form field". ... property of the pass-through query. ... I have an access database and a SQL database. ...
    (microsoft.public.access.queries)