Professional Web Applications Themes

Complex parameters in Transact SQL - Microsoft SQL / MS SQL Server

use dynamic sql to do that, using EXEC. See following examples --if parameter you are passing contains varchar values then you can have following syntax. declare x nvarchar(500) select x='''ALFKI'', ''ANATR''' exec ('select * from customers where customerid in (' + x + ')') --if parameter you are passing contains numeric values then you can have following syntax. declare x nvarchar(500) select x='5,6' exec ('select * from orders where employeeid in (' + x + ')') -- -Vishal "Scott Head" <com> wrote in message news:google.com... ...

  1. #1

    Default Re: Complex parameters in Transact SQL

    use dynamic sql to do that, using EXEC. See following examples

    --if parameter you are passing contains varchar values then you can have
    following syntax.

    declare x nvarchar(500)
    select x='''ALFKI'', ''ANATR'''
    exec ('select * from customers where customerid in (' + x + ')')

    --if parameter you are passing contains numeric values then you can have
    following syntax.

    declare x nvarchar(500)
    select x='5,6'
    exec ('select * from orders where employeeid in (' + x + ')')

    --
    -Vishal
    "Scott Head" <com> wrote in message
    news:google.com... 


    Vishal Guest

  2. #2

    Default Re: Complex parameters in Transact SQL

    ouch.. nasty one =)

    "Alejandro Mesa" <com> wrote in message
    news:%phx.gbl... 


    Lars-Erik Guest

  3. #3

    Default Re: Complex parameters in Transact SQL

    Check out:

    http://www.algonet.se/~sommar/arrays-in-sql.html

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Scott Head" <com> wrote in message
    news:google.com... 


    Tibor Guest

Similar Threads

  1. Transact SQL question
    By Peter in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 15th, 06:22 PM
  2. Transact-SQL Debugger
    By Neeraj in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 14th, 01:14 AM
  3. resource low - Transact-SQL
    By Otto Naesset in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 10th, 01:31 PM
  4. Transact-SQL syntax question
    By Rajan Murthy in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 03:36 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