Database

13-May-08 2:20

Yes.

Bob
Ashfield Consultants Ltd

username and password

trilokharry12-May-08 19:33

12-May-08 19:33

how to insert username and password in table(sql server 2005)
with case sensitive.
so I can check small(abc...) and capital(ABC...) letters also while logged in.

thanks

You get the best out of others when you give the best of yourself.

its.rajendra12-May-08 21:09

its.rajendra

12-May-08 21:09

Hi,

Just use UPPER & LOWER method during insert command in sql...

trilokharry12-May-08 21:31

12-May-08 21:31

that is fine but it will be static in either small or block letters.
I want in, whatever user enter in small or block letter.
should not be changed internally.

thanks to give me response.

You get the best out of others when you give the best of yourself.

Ashfield12-May-08 21:43

12-May-08 21:43

Just insert teh values as suppplied, then when you are looking for them use

select *<br />
from table<br />
where convert(varbinary,username) = convert(varbinary,@inputvalue)

Using varbinary effectively makes the select case sensitive

Bob
Ashfield Consultants Ltd

trilokharry13-May-08 0:58

13-May-08 0:58

thanks a lot for your kind help.
it's also working fine.......

thanks

You get the best out of others when you give the best of yourself.

Do I need VS2008 and sqlce 3.5? The old P/invoke DLL error for SQLCEME30.dll problem...

Alsvha13-May-08 9:21

Alsvha

13-May-08 9:21

Change collation to something case sensitive if you want to have case sensitivity.

---------------------------
Blogging about SQL, Technology and many other things

wallyg12-May-08 13:57

wallyg

12-May-08 13:57

Can I ask if this is correct.

Wince 5.0 has SQL3.0 (or SQL3.1 with the sp1) ?

What do you do for Wince 6.0? while using VS2005?

I had SQL3.0 working after the same old problem that everyone else has had with the P/invoke error. (VS2005 didn't copy the cabs into the correct directory - Deploy error) also sqlceme30.dll wasn't in the windows directory.

Fixed....

No problemss...

Yeah right, I got a new machine with wince6.0 on it.

Back to square one!

Now, it doesn't matter what I do, the same error keeps comming up 'P/invoke cant find sqlceme30.dll'.

I did notice that when you manually install the .cab files (sqlce30.wce5.armv4i.cab and sqlce30.repl.wce.arm4vi.cab)they say that 'this is not the compatable software platform, do you want to continue?'

Is this an incompatability with wince6.0?

Am I meant to use sqlce3.5?
Isn't this only in VS2008?

Is there another way around this or do I have to upgrade to VS2008?

Please help Smile | :)

Thanks,

Rob.

conver string to date not in date time format

trilokharry12-May-08 2:04

12-May-08 2:04

Hi how to conver string to date not in date time format.
means
like I want to convert this string(15 may 2008) '15/05/2008' in date format.

thanks

You get the best out of others when you give the best of yourself.

Ashfield12-May-08 3:56

12-May-08 3:56

The date is not stored in a specific date format in the database, but to do what you have asked:

select convert(varchar,convert(datetime,'15 may 2008'),103)

Bob
Ashfield Consultants Ltd

trilokharry12-May-08 5:03

12-May-08 5:03

not like that
I want finally in date format not in string format.

thanks

You get the best out of others when you give the best of yourself.

Alsvha12-May-08 6:23

Alsvha

12-May-08 6:23

Then just use a DateTime with a "00:00:00" for the time representation, because you can then just convert it to a string when you need it as shown by the previous poster.

---------------------------
Blogging about SQL, Technology and many other things

trilokharry12-May-08 19:28

12-May-08 19:28

that's fine but what I want see
varDate is "2008-05-09 21:24:58.407" now I want to get record as per date(2008-05-09)without time but not getting.
select *from tblName where varDate='2008-05-09'
not getting any record
I have stored date with time also.

I tried this also
select *from tblName where varDate like '%2008-05-09%'
ans:saying can not be converted string to date

You get the best out of others when you give the best of yourself.

Ashfield12-May-08 21:26

12-May-08 21:26

Well try using a little logic then. It is obviously failing because you have the time included on the database.

select * from tblName where convert(datetime,convert(varchar,getdate(),103)) = convert(datetime,'05 may 2008')

Bob
Ashfield Consultants Ltd

trilokharry12-May-08 21:36

12-May-08 21:36

not working

You get the best out of others when you give the best of yourself.

Ashfield12-May-08 21:45

12-May-08 21:45

trilokharry wrote:
not working

Very useful comment.

If tahts all you can say how can anyone help you - or why should anyone bother? Mad | :mad:

Bob
Ashfield Consultants Ltd

trilokharry12-May-08 23:29

12-May-08 23:29

I mean I am not getting my requirement.
your code working fine.

sorry for previous comment.

thanks

You get the best out of others when you give the best of yourself.

Ashfield12-May-08 23:36

12-May-08 23:36

Well exactly what IS your requirement? As far as I know, myself and others have answered your original question (such as it was)

trilokharry wrote:
like I want to convert this string(15 may 2008) '15/05/2008' in date format.

As a final suggestion, try this.

select * from table where CONVERT(VARCHAR(20),vardate,106) = '15 may 2008'

Otherwise explain EXACTLY what you want. The database does not really care what format your date is in as it stores it as a number anyway.

Bob
Ashfield Consultants Ltd

trilokharry13-May-08 0:50

13-May-08 0:50

thanks
now it's working fine

You get the best out of others when you give the best of yourself.

Blue_Boy13-May-08 0:59

Blue_Boy

13-May-08 0:59

In his first post I was confused and I didn't figure out what excatly he wants.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Ashfield13-May-08 1:56

Data which includes foregin characters

13-May-08 1:56

No, I was basing my answers mainly on guesswork Smile | :)

Bob
Ashfield Consultants Ltd

Naveed Kamboh12-May-08 1:43

Naveed Kamboh

12-May-08 1:43

I've got data in English but that contains Some French characters too.
for example

Actual data
The Coleg Sir Gâr
Sabhal Mòr Ostaig
Château du Rosey
Areté
Ecole La Découverte
Colegio Gran Bretaña
St Thérèse of Lisieux RC Primary School

Search input would be:
The Coleg Sir Gar (â replaced by a (English))
In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard.
any help will bhe appreciated.

Naveed Kamboh
Complexity kills, Write easy code for your self.
Punjabi stuff

Re: Data which includes foregin characters

Ashfield12-May-08 2:01

Re: Data which includes foregin characters

12-May-08 2:01

You need to define your columns as nvarchar, then they will accept these characters.

Bob
Ashfield Consultants Ltd

Naveed Kamboh12-May-08 2:05

Naveed Kamboh

12-May-08 2:05

You didn't get my question I gugess.
I have already that data in varchar there 10,000+ records which containt these foreign characters.
When we search using english chracters they do not come in the search. So what would be the solution to show them in the search
while using english characters as someone will type Foregin chracters.

Naveed Kamboh
Complexity kills, Write easy code for your self.
Punjabi stuff

Re: Data which includes foregin characters

Ashfield12-May-08 2:59