|
Didn't someone supply a sample function to concat the strings. This is the way I would do it.
It would also depend on the number of doctors as well, too many would cripple the process. You cannot do this in a single pass select query.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi Team,
I'm a software developer and,
I want to make my hosting server database as my local server database for testing purpose.
But my problem is that, I'v downloaded the sql2005 ssmsee from msdn subscription and installed it in my Vista Home Premium.
The thing is that after installation the Import and Export Options are missing.
So I can't able to Import and Export the database.
So, please anybody help me to make the hosting server database as my local database.
Thanks in Adavance...
Thanks and Regards,
Rama Krishna Panda,
S.E.(.Net Tech.)
Ergode.com,Mumbai.
|
|
|
|
|
I'm pretty sure there is no option to Import a database. I use the developer version and I am able to restore a backed up database OR attach an MDF and LDF files. I can uses import of a table but there is not import database option.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Download SQL express 2005 tool kit from Microsoft.com
and attach it with your running version as a external tools.
regards,
Aman
|
|
|
|
|
SQL server 2005 Express edition tool kit.
|
|
|
|
|
first you get the database backup from your hosting server, then create a new database in your local server(database name may be same) and restore the backup database to your local server. There is option for Backup & Restore options in Express edition
In Sql Server 2005 Express Edition - there is no Import & Export options, if you need this option you should by the standard edition or professional edtion etc,,,
|
|
|
|
|
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 )
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
|
|
|
|
|
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
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
|
|
|
|
|
I am such a fool!
Thanks a million, works like a charm!
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[ ^]?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
|
|
Hi, i got 2 tables.. 1 called "accounts" and the other called "event_joined"
inside accounts table i have the following field
accounts
admin_num | name | address | mobile
event joined
id | admin_num | eventid
1 | 123455 | 15
2 | 123455 | 18
3 | 123455 | 22
Now, i want to get all details of accounts as well as 1 more additional information which is counting how many event did the person joined.
In the above, u can see that person "123455" had joined 3 events because there are 3 rows of the same admin_num..
final result would be
admin_num | name | address | mobile | number of event joined
12344 | john tan | address bla bla bla | 91234567 | 3
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
can you send me how to create a database to create an online trading and shopping site
|
|
|
|
|
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.”
|
|
|
|
|
Starter kits can be found here[^]. Check out the "BeerHouse" example
I are troll
|
|
|
|
|
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
|
|
|
|
|
Kindly suggest SQL version to be loaded on Novel Network server
I have tried SQL Express edition but it;s not working
|
|
|
|