Chinese charecterers not displaying in Query Analyser

Hello,
Could i get information on how chinese charecters can me made to display in
SQL QueryAnalyser.I have tried installing language packages.
Thanks in Advance
Sowmya
Message posted via http://www.sqlmonster.com
what is the collation of the columns and how are you loading your data?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sowmya E via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:19ad95e28ba54de3aeb1cf0bc6dea269@.SQLMonster.c om...
> Hello,
> Could i get information on how chinese charecters can me made to display
in
> SQL QueryAnalyser.I have tried installing language packages.
> Thanks in Advance
> Sowmya
> --
> Message posted via http://www.sqlmonster.com
|||Sowmya,
What is the data type of the column where you are storing the Chinese
characters?
You might want to review the MSDN white paper "International Features in
Microsoft SQL Server 2000" at:
http://msdn.microsoft.com/library/de...Server2000.htm
and the following KB article may be helpful too:
239530 (Q239530) INF: Unicode String Constants in SQL Server Require N
Prefix
http://support.microsoft.com/default...b;en-us;239530
as both provide useful information when dealing with double-byte / Unicode
languages.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sowmya E via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:19ad95e28ba54de3aeb1cf0bc6dea269@.SQLMonster.c om...
> Hello,
> Could i get information on how chinese charecters can me made to display
in
> SQL QueryAnalyser.I have tried installing language packages.
> Thanks in Advance
> Sowmya
> --
> Message posted via http://www.sqlmonster.com

Checking if a stored procedure exists

Is there a way using a SQL Statement to see if a stored procedure exists in
SQL Server?The following will work for SPs, tables, or basically any database object:
if object_id('MyProc') is not null
"RSH" <way_beyond_oops@.yahoo.com> wrote in message
news:e3NuzSLtFHA.1048@.TK2MSFTNGP10.phx.gbl...
> Is there a way using a SQL Statement to see if a stored procedure exists
> in SQL Server?
>|||Select 'Exists' where OBJECT_ID(Nameof thsp) IS NOT NULL
Select * from INFORMATION_SCHEMA.Routines where Routine_name =
'nameofyoursp'
HTH, Jens suessmeyer.
"RSH" <way_beyond_oops@.yahoo.com> wrote in message
news:e3NuzSLtFHA.1048@.TK2MSFTNGP10.phx.gbl...
> Is there a way using a SQL Statement to see if a stored procedure exists
> in SQL Server?
>|||THANKS!!!
"Jens Smeyer" < Jens@.remove_this_for_contacting_sqlserve
r2005.de> wrote in
message news:uxi1AhLtFHA.236@.TK2MSFTNGP11.phx.gbl...
> Select 'Exists' where OBJECT_ID(Nameof thsp) IS NOT NULL
> Select * from INFORMATION_SCHEMA.Routines where Routine_name =
> 'nameofyoursp'
> HTH, Jens suessmeyer.
>
>
> "RSH" <way_beyond_oops@.yahoo.com> wrote in message
> news:e3NuzSLtFHA.1048@.TK2MSFTNGP10.phx.gbl...
>