Professional Web Applications Themes

how do you say 'and' or &? - Microsoft SQL / MS SQL Server

If I understand your intent, then the keyword you're looking for is AND. For example: use Northwind select * from Customers where CustomerID like 'A%' and ContactTitle = 'Owner' "Trint Smith" <com> wrote in message news:ufZl$phx.gbl... ...

  1. #1

    Default Re: how do you say 'and' or &?

    If I understand your intent, then the keyword you're looking for is AND.
    For example:

    use Northwind

    select *
    from Customers
    where CustomerID like 'A%'
    and ContactTitle = 'Owner'



    "Trint Smith" <com> wrote in message
    news:ufZl$phx.gbl... 


    J Guest

  2. #2

    Default how do you say 'and' or &?

    Its And, OR, Not etc. as words.... 
    know how to do 
    * from 
    [ClientID] & 
    *** 
    Ricky Guest

  3. #3

    Default Re: how do you say 'and' or &?

    TRY
    & = AND

    insert [Mink].[dbo].[TBL_Group] select distinct * from
    [Mink].[dbo].[TBL_Group_stage] s where not exists(select * from
    [Mink].[dbo].[TBL_Group] c where c.[ClientID]=s.[ClientID] AND
    c.[GroupID]=s.[GroupID] AND c.[TeacherID]=s.[TeacherID] AND
    c.[Grade]=s.[Grade] AND c.[RoomNum]=s.[RoomNum])

    Trint Smith <com> wrote in message news:<ufZl$phx.gbl>... 
    Guy Guest

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