table - SQL Server Forums

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

table

Author

Topic

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 02:56:17

i want to create a table for Apartments a separate table for each flat is difficult to create can any body suggests me to solve the prob

Kashyap M

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-22 : 03:21:40

You are not very clear.
What is your problem?

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

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 03:26:13

i want to create a Db for Ex:-Appartments in the Db i have to create the personal details of each and every flat owners and at the same time for Tenant. if i have to create a separate table for each and every table or else i can make relations in the table when inserting data

Kashyap M

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 06:43:55

plz help

Kashyap M

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-22 : 07:12:57

Can you be more specific about the data ie. needed columns and so on...?

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

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 08:00:55

i want to insert data in sql server 2005 by using select statement which can be useful entering no.of values at a time or else give me a link it

Kashyap M

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-22 : 08:12:56

Sorry but I am not able to help you!
Your
1. post begins with: i want to create a table
2. post begins with: i want to create a Db
4. post begins with: i want to insert data

Maybe there is someone else who knows how to help...

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

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 08:31:46

My sincere apologize for failing to explain my question
let me explain you in detail just today i have created a new Db named as apartment. in that i have to create a table which contains the data of the flats in the apartment. around 24 flats are available in the apartment i have to create a Db for the apartment. just i have created the Db and


CREATE TABLE Owners
(
FlatNo int primary key,
Owner varchar(25) NOT NULL,
OwnerAddress varchar(40) NOT NULL,
Phone char(15) NOT NULL,
Year smallint NOT NULL,
tenant-name varchar(25) NOT NULL,
TenantAddress varchar(40) NOT NULL
TenantPhone char(15) NOT NULL,
Yearofjoin smallint NOT NULL
)

this is the table
blindly i am using this code
insert into owners Values(404,'Murthy', 'Kadapa', '6474856', '2005'.......)
i want a application which can insert the values using select statement in that all can be inserted line by line

Kashyap M

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-22 : 08:50:38

Perhaps you can enter your data in Excel and then import it into the table...
Or in SSMS right click the table name in object explorer and then choose the enty named like 'edit first 200 rows' or so and there you can type in your data...

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

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-22 : 08:57:23

quote:
Originally posted by webfred

Perhaps you can enter your data in Excel and then import it into the table...
Or in SSMS right click the table name in object explorer and then choose the enty named like 'edit first 200 rows' or so and there you can type in your data...

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

thanks first i will try it

Kashyap M

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-23 : 02:00:10

i have created a excel sheet name is Tdetails can you tell me how to convert the Excel sheet to sql table table

Kashyap M

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-23 : 03:24:00

In SSMS object explorer right click the destination database.
Choose all task - import and then go through the wizard.

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

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-07-23 : 03:57:39

quote:
Originally posted by webfred

In SSMS object explorer right click the destination database.
Choose all task - import and then go through the wizard.

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

Plz if you don't mind can you give more clarity(liberally) i can't get your rep

Kashyap M

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources