Solved

SET EXACT ON in MSSQL

Posted on 2001-07-11
2
667 Views
Last Modified: 2008-02-01
Is that any similar command in MSSQL like Oracle SET EXACT ON/OFF so that case-sensitive query can be performed in case-insensitive database instance.
0
Comment
Question by:chnelson
2 Comments
 
LVL 6

Accepted Solution

by:
acampoma earned 20 total points
ID: 6275809
You can only convert to varbinary to use case sensitivity
Be sure to do the same where clause without the varbinary conversion to use indexes before finding actual values.
where Name = 'John'
and convert(vabinary(20),Name) = convert(vabinary(20),'John')

0
 
LVL 1

Author Comment

by:chnelson
ID: 6275956
what's brilliant idea!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now