Professional Web Applications Themes

General Help in SQL Statement - Microsoft SQL / MS SQL Server

-- Anthony B ------------------------ My RAM may be gone, but my floppy remembers "Anthony" <antgoodlifenospam.comcast.net> wrote in message news:... > I've been using sql statements for a few weeks and recently realized there > are a whole host of commands I don't understand.. and can't just 'guess my > way through. > > I need a good reference on the web if there is one available... Something > like the wscript56.chm for windows 5.6 scripting help or their script > repositories are great for my vb scripts that I use from Microsoft. Anything > like this for SQL? > > ...

  1. #1

    Default Re: General Help in SQL Statement



    --
    Anthony B
    ------------------------
    My RAM may be gone, but my floppy remembers

    "Anthony" <antgoodlifenospam.comcast.net> wrote in message news:...
    > I've been using sql statements for a few weeks and recently realized there
    > are a whole host of commands I don't understand.. and can't just 'guess my
    > way through.
    >
    > I need a good reference on the web if there is one available... Something
    > like the wscript56.chm for windows 5.6 scripting help or their script
    > repositories are great for my vb scripts that I use from Microsoft.
    Anything
    > like this for SQL?
    >
    > for example.. I have no real idea what the following statement does..
    > (Although I know it works)
    > (Wrtten in an asp by me (With some newsgroup help to check the date)
    >
    > sql = "SELECT * FROM " & DBTableName & " where TheDate >=
    > convert(varchar(8),getdate(),112) and TheDate < " & "
    > convert(varchar(8),dateadd(d,2,GetDate()),112) order by MBFree ASC"
    >
    > The convert with the ,112 is where I get lost and can't find references
    for
    > it. also the dateadd I assume adds 2 days to today but I would like to see
    > syntax on screen.. which I can't find..
    >
    > I am looking for a good reference on the web of these commands /
    functions..
    > / references.. any pointers / MS Links etc...?
    >
    > Thank you in advance..
    >
    > --
    > Anthony B
    >
    >

    Anthony Guest

  2. #2

    Default Re: General Help in SQL Statement

    Have you heard of Books on line? The SQL Server help
    manual.

    Mark Baekdal
    dbghost.com
    >-----Original Message-----
    >
    >
    >--
    >Anthony B
    >------------------------
    >My RAM may be gone, but my floppy remembers
    >
    >"Anthony" <antgoodlifenospam.comcast.net> wrote in
    message news:...
    >> I've been using sql statements for a few weeks and
    recently realized there
    >> are a whole host of commands I don't understand.. and
    can't just 'guess my
    >> way through.
    >>
    >> I need a good reference on the web if there is one
    available... Something
    >> like the wscript56.chm for windows 5.6 scripting help
    or their script
    >> repositories are great for my vb scripts that I use
    from Microsoft.
    >Anything
    >> like this for SQL?
    >>
    >> for example.. I have no real idea what the following
    statement does..
    >> (Although I know it works)
    >> (Wrtten in an asp by me (With some newsgroup help to
    check the date)
    >>
    >> sql = "SELECT * FROM " & DBTableName & " where TheDate
    >=
    >> convert(varchar(8),getdate(),112) and TheDate < " & "
    >> convert(varchar(8),dateadd(d,2,GetDate()),112) order by
    MBFree ASC"
    >>
    >> The convert with the ,112 is where I get lost and can't
    find references
    >for
    >> it. also the dateadd I assume adds 2 days to today but
    I would like to see
    >> syntax on screen.. which I can't find..
    >>
    >> I am looking for a good reference on the web of these
    commands /
    >functions..
    >> / references.. any pointers / MS Links etc...?
    >>
    >> Thank you in advance..
    >>
    >> --
    >> Anthony B
    >>
    >>
    >
    >
    >.
    >
    mark baekdal Guest

Similar Threads

  1. Hey all, got a general question
    By maarten@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 9
    Last Post: September 26th, 08:10 PM
  2. general assistance
    By baggyman in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: August 31st, 10:40 AM
  3. general help
    By jonker25 in forum Macromedia Flash Player
    Replies: 0
    Last Post: October 13th, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139