|
You're welcome.
|
|
|
|
|
Hi friends,
I am working with SQL Server 2005 database with Collation selected as Chinese_PRC_CI_AS
I have a table DMASTER in the database with a field called DNAME of type VARCHAR(254) which contains some Chinese characters.
When i run a query like
select * from dmaster where DNAME = N'翻译文字或网页翻译文字或网页';
from the SQL Server 2005 client, it works fine.
But if I try the same query programmatically using API "SQLExecDirect", it returns no records.
May I know the problem and how to solve it.
Thank you
cheers
Varghese Paul
|
|
|
|
|
|
Thank you. It worked fine.
cheers
Varghese Paul
|
|
|
|
|
|
HI!!
I have a table (sqlserver2005)
ID-------date1--------date2
1--------1/12/2008-----30/5/2009
2--------1/12/2009-----30/6/2010
...
I typed a date in a textbox.
I need to select ID as that date will be between date1 and date2.
How can i do that thanks.
exemple whene date=30/2/2009 id is 1.
Thanks!
modified on Tuesday, January 6, 2009 4:57 AM
|
|
|
|
|
You can use between operator like:
SELECT ...
FROM ...
WHERE DateFromTextBox BETWEEN date1 AND date2
|
|
|
|
|
HI!!
I did this :
String rqtr2 = "select ID as [p1] from Table where ('" + TextBox2.Text + "' between date1 and date2)";
and
TextBox2.Text = Convert.ToString(DateTime.Now) ;
but it is not right .
Help me please!
thanks
|
|
|
|
|
foryou wrote: but it is not right
What do you mean by that? Could you post an example row and what you entered in the textbox. That would clarify your problem. The forst guess would be that when you convert the date to a string, it isn't in a format that the db understands.
Little off-topic: it's a bad habit to use literals in the sql statement. Use parameters instead.
modified on Wednesday, January 7, 2009 7:27 AM
|
|
|
|
|
Hi!
Merci Mika Wendelius
sorry I dont speak English well.
what I am in the textbox is the system date (detetime)
example :
07/01/2009 11:59:16
Little off-topic: it's a bad habit to use literals in the sql statement. Use parameters instead.
I do not know how to use parameters in this case.
Thanks!!
|
|
|
|
|
foryou wrote: sorry I dont speak English well
No problem at all
foryou wrote: what I am in the textbox is the system date (detetime)
example :
07/01/2009 11:59:16
ok, you may encounter a conversion problem. If you're using literals (which I do not encourage at all) you would have a query like
select ...
from ...
where CONVERT(datetime, '07/01/2009 11:59:16', 101) between date1 and date2
You can test this for example like this:
select *
from sysobjects
where CONVERT(datetime, '01/07/2009 11:59:16',101) -- now
between GETDATE()-1 -- yesterday
and GETDATE()+1 -- tomorrow
Notice that the format is mm/dd/yyyy. if you want to use dd/mm/yyyy, you should use British/French format:
CONVERT(datetime, '07/01/2009 11:59:16', 103)
However you won't have these problems at all if you use parameters. Then your query would look like
select ...
from ...
where @SomeDateParameter between date1 and date2
There are good examples in BOL: SqlParameter[^].
foryou wrote: Merci Mika Wendelius
Ne rien. (I hope it was correct )
|
|
|
|
|
Hi!!
Thank you very much Mika Wendelius! it works.
Mika Wendelius wrote
Ne rien. (I hope it was correct )
they say "De rien".
|
|
|
|
|
foryou wrote: Thank you very much
You're welcome
foryou wrote: they say "De rien".
I had a feeling it was wrong. Thanks for correcting! It's been over 20 years I studied french and never used it after that so I guess I have forgotten about everything
|
|
|
|
|
Hi all
How to get LSN detail of a Log backup in sql server?
Thanks.,
Willington
D.Willington
|
|
|
|
|
|
we dont want to restore the log backup..,
Please tell me, how to get LSN withot restoring..
Thanks.,
Willington
D.Willington
|
|
|
|
|
It's been years since I last used that but I remember the command doesn't restore the log but only reads and returns the header information (same as the restore window does when you point out a backup file without actually restoring).
Of course for security reasons, you can take the file into another machine and test the command there.
|
|
|
|
|
|
|
Another Question.., Can u tell me what is
1. database-->Security-->SCHEMA and USER
2. server-->Security-->Logins, Credentials
Thanks.,
Willington
D.Willington
|
|
|
|
|
willington.d wrote: Can u tell me what is
willington.d wrote: SCHEMA
Schema is used to separate the ownership of database objects from actual users. It also serves as a logical component to divide the objects int the database to smaller groups (like accounting, marketing etc). See: User-Schema Separation[^]
willington.d wrote: Credentials
They are used to give access to the extrernal resources outside SQL Server. Credentials can then be given to logins. See: Credentials[^]
|
|
|
|
|
Hi There,
I am using when then case in my query.It is working properly when I check string value or null Values.But now I want to check greater than statement.But when use greater than then it shows error
Incorrect syntax near >
I am using when then as follow
case Actual_Bal when Bal>Actual_Bal then Actual Bal else Actual_Bal end Actual_Bal
Is it possible.
Thanks.
|
|
|
|
|
Yes,its possible but your sttament makes no sense and looks like it has several syntax errors anyway.
If you want to use Bal if its greater than Actual_Bal you need this
case when Bal > Actual_Bal then Bal else Actual_Bal end Actual_Bal
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Good answer but more importantly gongrats for the diamond
|
|
|
|
|
Thanks, and congratulations for yours too! Good feeelng isn't it
Bob
Ashfield Consultants Ltd
|
|
|
|