when passing data to server, many data-types require explicitly set the dwxxxLength field, do VARIANT requires and how can i set it's length as it's variant
how to pass a VARIANT data to SQL Server ?
Hot Topic
- Calculated member--
- How do I use SQL Server 2005 Express for a backend to a web site forums
- SQL 2005 release date?
- How to do Minof max and maxof min Calculation in SQL
- OLAP Theory
- Can't shrink system tempdb
- Device error or device off-line ???
- How to pass parameters to reportviewer (vs2003,reportservice2000)
- SQL Server Indirect Package Configurations
- Expressions not evaluating values???
SQL Server
- Error when browsing data
- SQL Server 2005 Express June CTP Setup Error
- sql question
- Run Time Error While Execute Sql Server 2005 Integration Services package from C#
- how to do it without using cursor?
- Pocket pc 2002 sqlce data synchronization with sql server 2000 (SP4)
- semi-addittive measures
- Down to 1 line now
- SQL Agent Failing when trying to run my SSIS Package
- Maintanance Plan
how to pass a VARIANT data to SQL Server ?
RUSSO
what if i store BSTR in my VARIANT variable
can your code works as well
Aaron R
If you need to pass different types in one parameter the you could pass it as an XML string, but you would need to use explicit types inside of SP anyway. See next KB about how to pass XML
http://support.microsoft.com/kb/555266/en-us
PreFishing
Tim Tharratt
Yes, in OLEDB binding structure:
Binding.cbMaxLen = sizeof(VARIANT);
Binding.wType = DBTYPE_VARIANT;
HTH.
wheelersctt
well, i think you misunderstood!
i mean i have a col1 which data type is NUMERIC, and col2 which data type is SMALLDATETIME, and in my app, i convert both into variant. now how can i pass a value back to the server, i dont know how to set the dw***Length field
Rick0124
the data store in server is NUMERIC(4,1) and SMALLDATETIME, for convenience, i convert it to VARIANT in my app. my problem is how to pass it back to the server
can i simply use m_dwxxxLength = sizeof(VARIANT)