Table Variable Support for SP in SQL 2008

Brought to you by: ickzon

#63 Table Variable Support for SP in SQL 2008

Status: open

Owner: Brian Heineman

Labels: Interface Improvements (example) (4)

Priority: 7

Updated: 2020-03-09

Created: 2009-11-03

Creator: Amar

Private: No

Table variable as store procedure parameter is new feature in SQL Server 2008. Need an feature in jtds that can pass table variable as a parameter to sql server 2008 store proecdure.

Discussion

Comment has been marked as spam.
Undo

View and moderate all "feature-requests Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Feature Requests"

Anonymous - 2016-07-15

The recently released MS JDBC driver (v6.0) supports Table Value Parameter types.

We're currently using XML parameters with jTDS, but the performance hit is large. I'm testing the MS driver now to see if the TVP support improves performance enough to warrant the switch.

I'd like to +1 this request for TVP support in jTDS.

The recently released MS JDBC driver (v6.0) supports Table Value Parameter types. We're currently using XML parameters with jTDS, but the performance hit is large. I'm testing the MS driver now to see if the TVP support improves performance enough to warrant the switch. I'd like to +1 this request for TVP support in jTDS.

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2018-08-16

what is the update on this? can we still not use TVP in jTDS?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2018-08-29

Any update about that

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2018-12-18

I would like to use this functionality as well. Has any progress been made?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2019-01-03

Any progress?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2019-09-26

Any updates?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2020-03-09

Any Updates?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous