: sql:execute and sql:params (string
length problem)
It looks like SQL Server just doesn't like the string you've constructed. You
should print out the string you're sending and see if it works when directly
typed to SQL Server. I bet it won't, and you might be able to see the problem
there.
I
Hi,
I want to insert to an SQL server database a large amount of data.
My query is like INSERT INTO [dbo].[Table] ([Field1],[Field2],...,[FieldN])
VALUES (Value1,Value2,...,ValueN). I'd near 1750 character.
My Xquery look like this :
for $p in //Product
return
sql:execute(
?,
It looks like SQL Server just doesn't like the string you've constructed. You
should print out the string you're sending and see if it works when directly
typed to SQL Server. I bet it won't, and you might be able to see the problem
there.
I notice you're not escaping special characters so