Re: Day Of The Week

From: Satish Balusa (sbalusa_nospam_at_corillian.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 10:42:08 -0800

Select datename(dw,getdate()) 

-- 
HTH
Satish Balusa
Corillian Corp.
"Jim Heavey" <JHeavey@nospam.com> wrote in message
news:Xns94A07D007A203JHeaveyBDUP@207.46.248.16...
> There is probably a better way to do this...but...
> I am wanting to run a procedure which will backup a database.  I created 7
> devices, one for each day of the week.
> When I run my procedure, I was wanting it to figure out the day of the
week
> so it would know which "device" to use for a backup.
> Is there a SQL command which will allow me to determine the day of the
week
> rather then having to pass a parm which provides the day of the week?
>
> Thanks in advance for your assistance....

Relevant Pages

  • Re: need cd to load xp pro need good back up progam
    ... Are you wanting an exact duplicate of your primary drive on to the second ... I you just want to backup your files so you have them backed up, ... > there is a disk boot failure wantind the system disk. ... >>> the cd I get a disk boot error wanting the system disk. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Can "/etc/rc.conf" be replaced with a symlink?
    ... I could and may eventually write a script. ... I do believe that the mount point where I am wanting to ... > Could I maybe place this mount point above the root in fstab? ... You might consider writing a script that will backup ...
    (freebsd-questions)
  • Re: Can "/etc/rc.conf" be replaced with a symlink?
    ... I do believe that the mount point where I am wanting to ... >> Could I maybe place this mount point above the root in fstab? ... > you can dump the root filesystem to a backup disk and/or a ...
    (freebsd-questions)
  • Re: Ping: NOYB
    ... I dont't hink JimH was really wanting "advice" but merely asking for a ... backup to what his daughters dentist said....That it is possible for ...
    (rec.boats)
  • Re: Bulldog PAYG
    ... On 01 Aug 2006 Stuart Crow wrote: ... Sorry, no, but it looks extremely useful for anyone wanting a "backup" ...
    (uk.telecom.broadband)
Loading