Database Discussion Boards

Mustafa Ismail Mustafa14-Jun-09 6:57

14-Jun-09 6:57

This issue has been giving me some grief and maybe one of you guys can shed some light on how to solve it and why does it happen.

Look at the following:

Select [PatientID] as [رقم المريض] from EMR.Patient;

(if you can't see the Arabic characters between the square brackets its OK Smile | :)

)

This is a very straight forward statement and the column alias works perfectly fine.

Doing this:

DECLARE @SQL nvarchar(250);
SET @SQL='Select [PatientID] as [رقم المريض] from EMR.Patient';

EXEC sp_executesql @SQL;

Returns a column titled [??? ?????] instead of the unicode alias. I tried setting it as a string and that didn't work either.

Any clues?

TIA

[edit]
http://www.sommarskog.se/dynamic_sql.html#columnalias[^]

This is a solution, but it seems a bit complicated for something seemingly simple.

If the post was helpful, please vote!

Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ

Now and forever, defiant to the end.
What is Multiple Sclerosis[^]?

modified on Sunday, June 14, 2009 1:22 PM

Re: Unicode Column Alias [modified]

Mycroft Holmes14-Jun-09 15:13

Mycroft Holmes

14-Jun-09 15:13

I would assume that sp_executesql will use a standard ascii character set to interpret the string @SQL. Try prefixing the string the N, this is designed for unicode (I think, I have limited experience with unicode)

And I can't post unicode in the message

SET @SQL=N'Select [PatientID] as [] from EMR.Patient';

Test - works for me Big Grin | :-D

DECLARE @SQL NVARCHAR(1000)
set @SQL = N'SELECT PatientIDAS [stick your funny text in here] FROM EMR.Patient'

EXEC (@SQL)

Last modified: 1hr 4mins after originally posted --

Never underestimate the power of human stupidity
RAH

Re: Unicode Column Alias

Mustafa Ismail Mustafa14-Jun-09 23:41

Mustafa Ismail Mustafa

14-Jun-09 23:41

I am such a fool! D'Oh! | :doh:

Thanks a million, works like a charm!

i need help with oracle database!

Eldad_kd14-Jun-09 6:17

Eldad_kd

14-Jun-09 6:17

hi
i need help with oracle database!
i have 2 tables in my database A and B. i want add the diffrance between A and B in B and also get the result.
i calculated A-B but i only get to result or insert it to B but i need to to them both!
in ms-sql i saved A-B into temporary table then read from that table and insert it into B
but it doesn't work in oracle

can anyone help me!?!
thanks Eldad.

Re: i need help with oracle database!

David Mujica15-Jun-09 3:03

David Mujica

15-Jun-09 3:03

Sounds like you want something like this:

Select (stuff from table A)
UNION
Select (table A - table B)

You don't give any details about the tables, so that is the best I can do.

David

Auditing in Database!!

Sr...Frank13-Jun-09 23:34

Sr...Frank

13-Jun-09 23:34

Hi Guys,

I have never used auditing in MSSQL Server2005.
Could you please let me know right steps to use auditing for my Database?

Thanks

Roll eyes | :rolleyes:

Re: Auditing in Database!!

Mycroft Holmes14-Jun-09 15:16

Mycroft Holmes

14-Jun-09 15:16

People write books on database auditing and you want a precis in a forum post. Do a search on SQL 2005 auditing[^] in Google, read some of the articles and come back with a more specific problem.

Never underestimate the power of human stupidity
RAH

Re: Auditing in Database!!

Sr...Frank18-Jun-09 7:40

Sr...Frank

18-Jun-09 7:40

Thanks!

Re: Auditing in Database!!

Niladri_Biswas17-Jun-09 20:51

Niladri_Biswas

17-Jun-09 20:51

Visit this site
http://www.sqlprof.com/blogs/sqlserver/archive/2008/03/29/auditing-logins-in-sql-server-2005.aspx[^]
Smile | :)

Niladri Biswas

Re: Auditing in Database!!

Sr...Frank18-Jun-09 7:41

Sr...Frank

18-Jun-09 7:41

Thanks

2 tables?

benjamin yap13-Jun-09 7:16

benjamin yap

13-Jun-09 7:16

Re: 2 tables?

Blue_Boy13-Jun-09 7:28

Blue_Boy

13-Jun-09 7:28

select accounts.*,
(select count(event_joined.eventid) from event_joined where event_joined.admin_num=accounts.admin_num) as [Number of event joined]
from accounts

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: 2 tables?

benjamin yap13-Jun-09 7:36

benjamin yap

13-Jun-09 7:36

THANKS!!

Re: 2 tables?

Blue_Boy13-Jun-09 7:39

Blue_Boy

13-Jun-09 7:39

No problem.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

database creation

malika mouzmine13-Jun-09 5:48

malika mouzmine

13-Jun-09 5:48

can you send me how to create a database to create an online trading and shopping site

Re: database creation

Henry Minute13-Jun-09 6:07

Henry Minute

13-Jun-09 6:07

Without knowing what you wish to trade, it is almost impossible to advise you, with any detail.

It would also take too much time and space. However, if you go to the top of the page and enter shopping cart into the search box and click go!, you will find lots of articles that will get you started.

When you have had a look and tried a few, I'm sure that you will find help for any specific problems that you might have.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: database creation

Eddy Vluggen13-Jun-09 7:58

Eddy Vluggen

13-Jun-09 7:58

Starter kits can be found here[^]. Check out the "BeerHouse" example Smile | :)

I are troll Smile | :)

Re: database creation

Jerry Hammond14-Jun-09 4:12

Jerry Hammond

14-Jun-09 4:12

Use master;
go
Create Database [Insert name here];
go

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Which SQL server to install on Novel network server

supportks13-Jun-09 1:51

supportks

13-Jun-09 1:51

Kindly suggest SQL version to be loaded on Novel Network server

I have tried SQL Express edition but it;s not working

Re: Which SQL server to install on Novel network server

Henry Minute13-Jun-09 6:12

Henry Minute

13-Jun-09 6:12

You need to be more specific!

What do you mean it's not working?

It won't install?
It installs, but you cannot connect?
What?

You might find some useful information here[^].

how to get data from Server A to Server B

Satish_S12-Jun-09 18:30

Satish_S

12-Jun-09 18:30

hi
I have to get data's from sqlserver 2000 Db to my Sql server 2005 Db, how to do this? is there any way other than linked server..

Re: how to get data from Server A to Server B

Mycroft Holmes13-Jun-09 2:33

Mycroft Holmes

13-Jun-09 2:33

BCP, SSIS/DTS or use data compare from red-gate.

Never underestimate the power of human stupidity
RAH

problem in sql server connection

pampam11012-Jun-09 6:40

pampam110

12-Jun-09 6:40

I installed SQL Server 2005 on my computer. I am using Vista Ultimate. After installation, I can't login to SQL Server.
It gives the error:

Login Failed for User'DOMAINNAME\ACCOUNTNAME'. (Microsoft SQL Server Error: 18456)

I also have SQL Server Express installed on my computer and I can login to that without any problem.

Any ideas?

[]D @ []v[] []D @ []v[]

Re: problem in sql server connection

Jerry Hammond12-Jun-09 10:13

Jerry Hammond

12-Jun-09 10:13

Are you sure you're using the correct account to login with?

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Re: problem in sql server connection

pampam11015-Jun-09 22:24

pampam110

15-Jun-09 22:24

Yeah , I'm Sure.

[]D @ []v[] []D @ []v[]

Last Visit: 31-Dec-99 18:00 Last Update: 26-Apr-24 1:25

Refresh

ᐊ Prev 1...831 832 833 834835836 837 838 839 840 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.