Hi shariqmsit and welcome to DaniWeb :)

"hospital administration database" is pretty abstract. I think you need to define what is required a bit more than that before you even think about database...

Use the SUBSTRING function.

SELECT SUBSTRING(ImageLink, 2, 100) FROM TheTable -- the 2 indicates start at index of 2, the 100 will give you the next 100 characters in the string "ImageLink"

Hi Somerston and welcome to DaniWeb :)

You will need to join to the employee table twice to get the name for each column. Something like this should work:

-- first select the columns required...

I'm not sure what you are trying to achieve by running the trigger as another user. I think this would cause you more headaches than it would solve.

"I'm not very confortable with that since I...

Hi debeginin and welcome to DaniWeb :)

I'm pretty sure MS SQL Server 2000 is a stand-alone install. I know later versions require the .NET Framework, but from memory you should be able to just...

Hi zammari10 and welcome to DaniWeb :)

Your issue is a different one to this thread. I suggest you start a new topic so that more people will read your question and hopefully someone will have an...

Ah ok, sorry I misunderstood your intent. So in order to loop through each product, I would use a CURSOR. Basically a cursor provides a way to loop through objects in a table. Here's a simple...

Hi alexstrong29 and welcome to DaniWeb :)

If the recommended products are also in the products table, what I would do is add four columns to your product table that represent the product ID's of...

What is the type for the field 'creationdate'? Is it a date, datetime, smalldatetime or something else?

The DATEADD function will do what you need. Its syntax is DATEADD(datepart,number,date) where the datepart parameter is the interval that you are adding (eg second which can be abbreviated to ss),...

Hi again,
The easiest way to avoid duplicates is to limit the select statement according to some criteria. Do you have an ID field in the table that you can use, or some sort of date field to...

Hi Lido98 and welcome to DaniWeb :)

This can be done in SQL Management Studio in a few easy steps:


First of all, you need to connect to Server B.
Once connected, you need to link Server A...

You can copy the data from one database to another, but the method depends on whether or not they are located on the same MSSQL Server instance. If they are, then you can qualify the database name...

I'm sorry Aamit, but I am not sure what you are trying to achieve here. Do you want to add a column, change_id, to your table and have the existing rows have an auto-incrementing number assigned to...

Something like this should work:

-- set where to insert
INSERT INTO Table_one (First_Name)
-- select values to insert
SELECT Name FROM Table_Two
-- you may need to specify which ones from...

Hi AsinuS and welcome to DaniWeb :)

Can you post the query you are using to insert the xml? Also table information might help us to solve your problem too.

We'll start there (at the most basic...

Can you post your query?

You can use a JOIN to do this. You need to select the rows from each table, then describe how rows are related. Such a query will look something like this:


-- select rows
select...

Unfortunately different implementations of SQL can often have different ways of doing things. PostgreSQL is actually closer to PL/SQL and even MySQL than MSSQL in implementation. This means that...

What errors do you get when you try to run the queries?

You need to backup the database and then the .bak file that is created can be restored on another PC quite easily. Are you using SQL Management Studio?

The only thing I would say is that since you have a Foreign Key in Amount called Invoice_id, you will need to update the Invoice table before the Amount table. If you try to insert into Amount table...

Hi Sebouh,

I'm not 100% sure how to do what you want, but Java does have quite a few sql libraries in its API known as the JDBC. If you post your question in the Java forum, someone with more...