TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
kishor choure
NA
87
46.2k
Interested select query in sql server 2005
Aug 9 2012 1:16 PM
I create Logintbl in sql server 2005 . All records inside logintbl are in small letter. When I select record from logintbl by writing following query
select l_name from logintbl where l_pass='ABC'
then I get the login name . Same result is displayed when I write the query by following way
select l_name from logintbl where l_pass='abc'
I required that records must be find only by small letters not by capital letters in sql server 2005 . Please help me in this regard.
Reply
Answers (
3
)
Regarding sql server 2005
how to wite a query to insert only 10 records into database by using C#.net