sql- how to create db for a singe field having 2

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

sql- how to create db for a singe field having 2

Author

Topic

Username1234
Starting Member

3 Posts

Posted - 2014-12-14 : 01:20:12

Hello

Greetings!!

I would be pleased to know about how can we create a DB for a single attribute such as ORDER DETAILS, CASH RECEIPT, TAX INVOICE having more than 2 text fields.

Also, in every form attribute such as order id is not present - in order identify the same as a primay key. So, which other attributes or fields can be considered as a primary key.

So, forth looking forward for your help.

Thank You,
Vishwas

Vishwas.R/..

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2014-12-14 : 02:44:58

not clear your requirement

Vijay is here to learn something from you guys.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-14 : 08:26:23

quote:
Originally posted by Username1234

Hello

Greetings!!

I would be pleased to know about how can we create a DB for a single attribute such as ORDER DETAILS, CASH RECEIPT, TAX INVOICE having more than 2 text fields.

Also, in every form attribute such as order id is not present - in order identify the same as a primay key. So, which other attributes or fields can be considered as a primary key.

So, forth looking forward for your help.

Thank You,
Vishwas

Vishwas.R/..

Not sure at all what you mean. A database doesn't have attributes. It has properties. A database can contain tables, but they don't have attributes either. They have columns.

It sounds like you want to create a table in a database that has columns of a user-defined datatype that contains two text fields. Is that right?

Username1234
Starting Member

3 Posts

Posted - 2014-12-14 : 11:21:41

Hi Vijay,

I am sorry for the confusion caused..

Yes, you are wright!!

Thanks,
Vishwas

Vishwas.R/..

Username1234
Starting Member

3 Posts

Posted - 2014-12-14 : 11:23:10

Hi gbritton,

Yes, you are wright!!

How can we go about the same?

Thanks,
Vishwas

Vishwas.R/..

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-14 : 12:46:38

quote:
Originally posted by Username1234

Hi gbritton,

Yes, you are wright!!

How can we go about the same?

Thanks,
Vishwas

Vishwas.R/..

How can we go about the same what? (Still don't know what you really want to do)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources