Question about Microsoft SQL Server 2000 Standard Edition for PC

3 Answers

Sql Server 2005

I had created one table n1 and another as n2 and i want to merge this two tables...

Means if exmple n1 have name, age, and designation and n2 have name, department and i want to make this two table into one as name, age,designation and department into single with query..

Someone help me to do this now only i am in beginner state..

Posted by on

3 Answers

Re: Sql Server 2005

Write a query student informatin and marks into the student pass or fail

Posted on Mar 13, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: Sql Server 2005

"select,n1.age,n1.designation,n2.department into new_table
from n1,n2

If you want to merge more than two tables you can use "INNER JOIN"

Consider table1 has name & id_no, table2 has id_no & salary, And table3 has id_no & Age.
If we want to merge like to crate a new table has name,age ,salary, Use the given Query

SELECT,b.salary,c.age into newtable
FROM table1 a INNER JOIN table2 b ON a.id_no=b.id_no INNER JOIN table3 c
ON c.id_no=b.id_no

Posted on Dec 18, 2007

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: Sql Server 2005

Select,age,department from int newtable n1,n2 where

Posted on Dec 10, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

3 Answers

Repair database without being attached SQL 2005

Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

Read more:

May 13, 2015 | Microsoft SQL Server 2005 Enterprise...

2 Answers

How to fix mySQL corrupt databases?

you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-:

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

How to add more than one record in one row ?

You need to have two tables. One table for the reservation (each reervation having a primary key) and one table to store the people "linked" to that reservation. In the second table, each person will be on a row and one column in your second table would refer to the first (reservation) table in a one-to-many relationship. Read into database design and this will make sense. This can all be done in ADO.NET.

Dec 24, 2008 | Microsoft SQL Server 2005 Standard Edition

1 Answer

After installing DB2 query is not executing

could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

4 Answers

Restoring files from the database

I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

SQL Server 2000

An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Business & Productivity Software

1 Answer

Help me....

You have to creat a table in the SQL server db then you can


a) use some windows host script or vb to read your data and insert into the db..


b)you can also use the acess:


Oct 13, 2007 | Microsoft SQL Server Standard Edition for...

3 Answers

Viewing ms Sql Server database on Access

Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

Related Topics:

182 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides