If that is the case, then how do applications that use DSN connections connect to a ODBC datasource without entering a SQL Server password?

Also, is there then no way to...

When I add the -U test_user to the osql command, I get an error message saying "Login failed for user test_user". I do not understand why it is not able...

I do not want to connect with a trusted connection (-E option). I want to use the test_user SQL Server login and test_pwd SQL password. Thanks for responding.

Try "SELECT rtrim(Employer), date from table_name ORDER BY rtrim(Employer), date"

Thank you all for your responses. I have been working on this for a few days now based on the responses I have got. I think I need to clarify...

Thank you all for your responses. From the links sent by Carl Federl (part II), I believe it is possible to make the trigger not abort the transaction by issuing...

The Mirror table has a primary key constraint. When we try to insert two records with the same primary key ID in the mirror table, it generates an error. I...

I am running the Package on my local SQL Server. Why am I not seeing any Msgbox? Since this is only a test, I will remove the MsgBox when I...

There is a inbuilt function called XMLElement in DataDirect Query Builder for XML that does what I want. So, I wrote my own UDF that woudl do the same thing. But, I am not sure...

After you have given you first update statements give a second update statement with a select CASE like this

Update enrolltemp

set region = C.REGION

from  Enrolltemp E, COUNTY_LISTING C

join Enrolltemp ON enrolltemp.[Case...

Try this:

DECLARE @tablename char(12), @procedure varchar(1000)

set @tablename = 'Groupings'

set @procedure = 'declare @retval int; select @retval = count(*) from ' + @tablename + '; select @retVal'

exec(@procedure)

The Exec command does not...

I worked around the issue by using a combination of COALESCE and NULLIF...Here is how.

@Some_String_Variable + COALESCE(NULLIF('<Telephone>' +

   COALESCE(@PhoneNumber, '') + COALESCE(@PhoneExtn, '') +    '</Telephone>', '<Telephone></Telephone>'), '') + @SomeOther_String_Variable

If @PhoneNumber is...

I think I found the solution! Here is what I found in the books online:

"When you concatenate null values, either the concat null yields null setting of sp_dboption or SET...

Thanks for the reply. My problem is that I have about 50 or 60 such tags to create and I do not want to declare so many variables and define...

I guess there is no connection between my subject and message in my previous post. I need to create a T-SQL statement that works like this

iif(@EmployeePhone is NULL, NULL,