T
touf
I'm migrating from ms-accss to sql server 2005 for a vb.net application.
the problem is that the queries like "select field1+field2 from table"
arereturning NULL if one of the fields is null.
I like to have the concatenation containing the not null values.
I've tried to set the variable concat_null_yields_null to OFF inside the
server management studio , this is giving me a ggod result inside sql server
management studio, but not inside my application.
My connection string is
connectStr = "Provider=sqloledb;Data Source=xxxxxxx;Initial
Catalog=xxxx;Integrated Security=SSPI;"
Is this because I'm using OLEDB?? what should be the solution?
thanks.
the problem is that the queries like "select field1+field2 from table"
arereturning NULL if one of the fields is null.
I like to have the concatenation containing the not null values.
I've tried to set the variable concat_null_yields_null to OFF inside the
server management studio , this is giving me a ggod result inside sql server
management studio, but not inside my application.
My connection string is
connectStr = "Provider=sqloledb;Data Source=xxxxxxx;Initial
Catalog=xxxx;Integrated Security=SSPI;"
Is this because I'm using OLEDB?? what should be the solution?
thanks.