multi lingual where clause

I have a table with nvarchar column. In query analyzer when I run query with foreign language words that are already there in database it dose not return any rows

To test it I returned rows with Select * table. Then from result window I copy chinese characters and put it in SQL where clause in SQL analyzer .When I run query it dose not return results.

What could be the cause..its SQL 2k

found it add N infront of characters|||

As kyus94 indicated, to use UNICODE characters, including Chinese, you must preface the string with the character [ N ].

For example,

SELECT

Column1,

Column2,

etc

FROM MyTable

WHERE Column3 = N'ThisCouldBeChinese'

(Note the character immediately before (no space) the string.)

sql

multi instances of sql server

Hi,
if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
Manager - sql query analyzer to get a list of them all (name, current status,
the databases under each of them)? or have to use some other tool to do it?
thank you very much!
As I gather they are not showing up, check to see if these instances are
using TCP/IP or NAMED PIPES. [Start Programs - Microsoft SQL Server - SERVER
NETWORK UTILITY]. They may not show in the active directory - or at least
not allow connections - if one of these two protocols is not enabled.
Regards,
Jamie
"bangwo" wrote:

> Hi,
> if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
> Manager - sql query analyzer to get a list of them all (name, current status,
> the databases under each of them)? or have to use some other tool to do it?
> thank you very much!
sql

multi instances of sql server

Hi,
if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
Manager - sql query analyzer to get a list of them all (name, current status
,
the databases under each of them)? or have to use some other tool to do it?
thank you very much!As I gather they are not showing up, check to see if these instances are
using TCP/IP or NAMED PIPES. [Start Programs - Microsoft SQL Server - S
ERVER
NETWORK UTILITY]. They may not show in the active directory - or at least
not allow connections - if one of these two protocols is not enabled.
--
Regards,
Jamie
"bangwo" wrote:

> Hi,
> if I have 3 instances of sql server 2000 on a machine, how to use Enterpri
se
> Manager - sql query analyzer to get a list of them all (name, current stat
us,
> the databases under each of them)? or have to use some other tool to do i
t?
> thank you very much!

Mulitple Queries in a Stored Procedure

I have written a stored procedure that contains queries which return data.
It works correctly in Query Analyzer, returning each of the labled fields.
When I create a report the only return field the report wizard shows is from
the first query. When I add each of the other return fields and run the
report in VS I get an out of index error.RS only supports a single resultset being returned.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:39FAA817-C491-493D-81BB-FDA153D7DB57@.microsoft.com...
> I have written a stored procedure that contains queries which return data.
> It works correctly in Query Analyzer, returning each of the labled fields.
> When I create a report the only return field the report wizard shows is
> from
> the first query. When I add each of the other return fields and run the
> report in VS I get an out of index error.

MS-SQL Script Question

MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.
http://www.vehiclewebstudio.comYou will have to have a client app of some sort (osql/isql/etc). Basically, the
client app will open a connection to your server, parse the content of your
script file into batches delimited by GO, then execute the batches against the
server.

It's quite easy to implement an ado connection to sqlserver, parse the script
file and execute it. QALite on the site does just that.

--
-oj
http://www.rac4sql.net

"Tim Morrison" <sales@.kjmsoftware.com> wrote in message
news:LnnKb.753782$Tr4.2103435@.attbi_s03...
MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No
Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related
website.
http://www.vehiclewebstudio.com|||The script can be registered as a task and run automatically
without operator intervention.

"Tim Morrison" <sales@.kjmsoftware.com> wrote in message
news:LnnKb.753782$Tr4.2103435@.attbi_s03...
MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No
Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

-----------------------
--

Vehicle Web Studio - The easiest way to create and maintain your vehicle
related website.
http://www.vehiclewebstudio.com