Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Sql query Pls help [modified]

Sql query Pls help [modified]

Scheduled Pinned Locked Moved Database
databasehelpquestion
8 Posts 7 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • V Offline
    V Offline
    vipinpaliwal1980
    wrote on last edited by
    #1

    i create a stored porc and i want to send numeric value with parameter how can i do this create porc test @num int as select * from table1 where id in (@num) i am not use where caluse because i want to send like 1,2,3,4 at the single query Pls help vipin paliwal -- modified at 3:25 Thursday 24th August, 2006

    M B E 3 Replies Last reply
    0
    • V vipinpaliwal1980

      i create a stored porc and i want to send numeric value with parameter how can i do this create porc test @num int as select * from table1 where id in (@num) i am not use where caluse because i want to send like 1,2,3,4 at the single query Pls help vipin paliwal -- modified at 3:25 Thursday 24th August, 2006

      M Offline
      M Offline
      Malcolm Smart
      wrote on last edited by
      #2

      create porc - a good start calus - we can be. Very. Suggest you post this in the correct forum.

      Regards Malc *********************************************

      1 Reply Last reply
      0
      • V vipinpaliwal1980

        i create a stored porc and i want to send numeric value with parameter how can i do this create porc test @num int as select * from table1 where id in (@num) i am not use where caluse because i want to send like 1,2,3,4 at the single query Pls help vipin paliwal -- modified at 3:25 Thursday 24th August, 2006

        B Offline
        B Offline
        bose_here
        wrote on last edited by
        #3

        create porc test @num varchar(100) as --Set @num='1,2,3,4,5' Exec(' select * from table1 where id in ('+@num+')

        1 Reply Last reply
        0
        • V vipinpaliwal1980

          i create a stored porc and i want to send numeric value with parameter how can i do this create porc test @num int as select * from table1 where id in (@num) i am not use where caluse because i want to send like 1,2,3,4 at the single query Pls help vipin paliwal -- modified at 3:25 Thursday 24th August, 2006

          E Offline
          E Offline
          Edbert P
          wrote on last edited by
          #4

          You're a disgrace. As another 26 years old, I feel ashamed that you, sir, cannot comprehend the bold, red text saying "Please do NOT post programming questions or ads to this forum." when typing your question at The Lounge. Aside from that, your text-speak allows me to think of you as someone with lower than average intelligence, lazy, and inconsiderate of others in this community. Please refrain from further posting until you understand the nettiquete and can write properly.

          "A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia

          S 1 Reply Last reply
          0
          • E Edbert P

            You're a disgrace. As another 26 years old, I feel ashamed that you, sir, cannot comprehend the bold, red text saying "Please do NOT post programming questions or ads to this forum." when typing your question at The Lounge. Aside from that, your text-speak allows me to think of you as someone with lower than average intelligence, lazy, and inconsiderate of others in this community. Please refrain from further posting until you understand the nettiquete and can write properly.

            "A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia

            S Offline
            S Offline
            Steve S
            wrote on last edited by
            #5

            S'funny. At the top of this forum, it says "SQL / ADO / ADO.NET"... or has this been moved from the lounge? (I didn't know you could do that)

            Steve S Developer for hire

            M 1 Reply Last reply
            0
            • S Steve S

              S'funny. At the top of this forum, it says "SQL / ADO / ADO.NET"... or has this been moved from the lounge? (I didn't know you could do that)

              Steve S Developer for hire

              M Offline
              M Offline
              Michael P Butler
              wrote on last edited by
              #6

              Steve S wrote:

              or has this been moved from the lounge? (I didn't know you could do that)

              Yeah, it's been moved from the Lounge. A visual indication would be nice though.

              Michael CP Blog [^] Development Blog [^]

              V 1 Reply Last reply
              0
              • M Michael P Butler

                Steve S wrote:

                or has this been moved from the lounge? (I didn't know you could do that)

                Yeah, it's been moved from the Lounge. A visual indication would be nice though.

                Michael CP Blog [^] Development Blog [^]

                V Offline
                V Offline
                vipinpaliwal1980
                wrote on last edited by
                #7

                so, any body give me answer . vipin paliwal

                _ 1 Reply Last reply
                0
                • V vipinpaliwal1980

                  so, any body give me answer . vipin paliwal

                  _ Offline
                  _ Offline
                  _AK_
                  wrote on last edited by
                  #8

                  CREATE PROCEDURE Test(@num int) AS select * from table1 where id = @num

                  Best Regards, Apurva Kaushal

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups