Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 saving problem

Author  Topic 

elizabethmwashuma
Starting Member

1 Post

Posted - 2010-06-22 : 09:49:16
i am getting an error and i don't know how to solve it. first when entering data into the database in the server through the management studio, the save selected items option is not active such that you cannot select that option.

i have 5tables and created relationship between them.the tables are:-
tbl_master
tbl_subSystem
tbl_subsection
tbl_unit
tbl_items

master has the 4systems name for the database.
the subsystem has the subsytems for each system
the subsection contains subsection for the subsystem
item will contain item name
and the unit contains unit type of the system.



kindly assist me

am beginner in visual c# and sql server 2005 but wants to find everything about sql server 2005

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-22 : 09:57:28
you should type in INSERT statements in query editor window if you don't have build an application to enter data.
Do it in the right order because of relations...

For example:
insert tbl_master(column1,column2,...)
select 'value1', 'value2', ...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -