Question(How to) regarding returning a table using CLR?

• Ryan Christopher Surrao-235526

  Grasshopper

  Points: 13

  More actions

  August 27, 2009 at 7:57 am

  #209982

  Hi

  I am new to CLR programing and I have a requirement where in I pass a stored procedure and need to to get the resultset which is a table as the output to the database.

  I figure out the part on how to run the sp but I dont know how to get the result set in the table form.

  I would appreciate if someone could let me know or write me a sample code on how to do this in VB.net using CLR sp or function please?

  Thanks

  Ryan

  ---

  Kindest Regards,

  Ryan Christopher Surrao

  MCSE (NT), CCNA, MCDBA, MCAD.NET, MSCD.NET

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  August 27, 2009 at 9:12 am

  #1045622

  Your requirements aren't very clear here. Can you elaborate on what you currently have, and what you need it to do more? Post some example code of what you already have done and the problem encountered? I can answer your thread three different ways, depending on what your real problem actually might be. If you already have a CLR Stored procedure what is it doing currently?

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]