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

Ad

3 Answers

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

Posted on Mar 13, 2008

Ad
  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

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 a.name,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

Ad
  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Select n1.name,age,department from int newtable n1,n2 where n1.name=n2.name

Posted on Dec 10, 2007

  • Hal9000 Dec 10, 2007

    oops I made a topo



    select n1.name,age.department into newtable from n1,n2 where n1.name=n2.name



    this will give you a table for all the records where the name is in both tables.



    If you want the other records please let me know and I can write those for you too

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Sql query for create table


To create a table use the statement CREATE TABLE use the proper datatype with the proper column name
Ex. CREATE TABLE table_name (
column_name1 datatype,
column_name2 datatype,
column_name3 datatype,
....
);
For more you can refer to w3schools
For more detail visit us

Software development Company Website Designing Development Company

Mar 21, 2017 | Computers & Internet

Tip

How to Create and Remove SQL Server Password


SQL Server is a Microsoft product used to manage and storeinformation. It uses tables to contain large sets of records for thedatabase. Do you have a SQL server and have you ever used SQL server?Do you know how to create a SQL Server passwordto protect your data stored on SQL server? What to do if you forgetyour SQL password? Following it will introduce you how to create a SQLpassword. And it also tells you how to remove SQL Server password ifyou forget as password can be easily lost.

How to create a SQL Server password?

As we know, it is an important security measure to set a passwordfor user accounts and in particular the SA account. And it is very easyfor you to create a SQL Server password. Just follow the simpleinstructions.

1. Open the Microsoft SQL Server Management Studio program from the Start menu bar in Windows.
2. Click on the SQL Server instance on which the new user will be created.
3. Right-click the Security folder, point to New, and then click Login.
4. On the General page, enter a name for the new login in the Login name box.
5. Select SQL Server Authentication and enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Click the OK to complete the creation of the new user.

Sometimes it happens that you ignore or forget the systemadministrator password. What will you do if you forget SQL password andcannot access to SQL database? The effective way I know is to remove SQL Server passwordwith the help of SQL Server password remover software. MS SQL ServerPassword Unlocker is one of the good MS SQL password remover toolswhich can help you remove SQL password in a few seconds.

How to remove SQL password with Windows Password Unlocker?

MS SQL Server Password Unlocker is handy SQL Server password remover software for you to reset SQLpassword including reset SA password and other user passwords. It caneasily remove SQL Server password for Microsoft SQL Server2000/2005/2008 in a minute. You don’t need to install MS SQL Server onyour PC, and the file in master.mdf format is enough for you to removeSQL Server password and set a new one for it.
Step 1. Download and install MS SQL Server Password Unlocker, and run the application.
Step 2. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.

This SQL account password has been reset. You can login with the newly set SQL password. Although it is easy for you to remove SQL Server passwordwith SQL password remover, it is better to keep your SQL password inheart. Or you can also write it down on a paper and keep in a safeplace.

on Sep 07, 2010 | Computers & Internet

3 Answers

'Table does not exist' error in MySQL, although it really exists


it usually means that no table exists in the default database with the given name. In some cases, it may be that the table does exist but that you are referring to it incorrectly. Maybe your database and table names are case sensitive if they are located on a file system that has case-sensitive file names. Or perhapsall references to a given table within a query must use the same lettercase.
Use SHOW TABLES to check which tables are in the default database.
Well, if you are sure that table is exist and you write its name exactly such it should be, then I suppose something wrong with the database, it can be seriously corrupt. And in this case you need a professional help. This tool must help at any rate - Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/

Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...

2 Answers

Transaction replication is poosible in sql server devlper edition


SQL Server 2005 provides a lot of benefits over SQL Server 2000 including within the replication feature set.

You might be relieved to know that, although most of the benefits accrue on the side of a SQL Server 2005 Publisher, you can still set up SQL Server 2005 as a subscriber on a SQL Server 2000 Publisher. Thus, you can begin to merge in the newest release of SQL Server into an existing replication scheme. You can read more about this at http://msdn2.microsoft.com/en-us/library/ms217330.

Although major advantage to SQL Server 2005 over 2000 is that changes to the schema, such as through ALTER TABLE statements, replicate out to all subscribing servers. The cool news in a mixed version environment is that the ALTER TABLE statements will be published to SQL Server 2000 Subscribers from a SQL Server 2005 Publisher.

Very cool!

Jan 30, 2009 | Televison & Video

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

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

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:

0695665.jpg

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:

215 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...