Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeepmanne
Starting Member
31 Posts |
 Posted - 2011-12-26 : 10:35:20
|
| hi,i want to insert the values into a database table from frontendby refcan we use inseert statement with ref????thanks inadvance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-26 : 11:11:07
|
| what do you mean by ref?you can use parameters to pass on values to insert.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
pradeepmanne
Starting Member
31 Posts |
Posted - 2011-12-26 : 11:13:46
|
quote:
Originally posted by visakh16
what do you mean by ref?you can use parameters to pass on values to insert.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Ref means byreference inserting array index values by insert statement |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-26 : 11:23:03
|
| ok...that what you're using parameters for------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
pradeepmanne
Starting Member
31 Posts |
Posted - 2011-12-26 : 11:28:23
|
| i want to insert ref values into tableand the array is dynamic and size of array is created at runtime i nedd a statement to insert statement for array which is created at runtime datatype is same for all columns |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-12-26 : 11:35:33
|
| There is no native data type in SQL that supports an array parameter for a stored procedure - you can use user-defined array types in SQL 2008. There are other ways as well - packing up the data as an XML fragment and sending to the database and shredding it in T-SQL etc.There is a discussion of various options at Sommarskog's blog here: http://www.sommarskog.se/arrays-in-sql.html |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Insert statement with reference