If there's no start transaction specified won't the code fail on the rollback?

Here's a UDF that also removes extraneous spaces.

ALTER FUNCTION [dbo].[udfCamelCase]

(

-- Add the parameters for the function here

@VStringvarchar(1000)

)

RETURNS varchar(1000)

AS

BEGIN

-- Table used to get the words in the string

DECLARE @PartTable table (StringPart...

While you may not be able to use SELECT <columnlist> INTO <table> with table variables it's possible to use:

insert@table

selectcol1, col2...

from someTable

wheresomeColumn = someValue;

To...

I was having the same problem. I opened the data source designer and change the provider to System.Data.SqlClient (default is OleDB...). I also "saved" the password (don't know if that...