how to set reference of a table at run time

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

SQL Server 2000 Forums

Transact-SQL (2000)

how to set reference of a table at run time

Author

Topic

salmonraju
Yak Posting Veteran

54 Posts

Posted - 2006-10-20 : 02:36:43

my database contains 3 tables
1. Books
2.Cd/DVd
3.Magazines

it is simple library application
contains issue (books/cdDVd/Magzines)
now i have to create a ISSUE Table, but it reference must be set according to entity(book//cdDVd/Magzines) the user want to issue.
for this how to write single issue table rather than wriring
3 issue tables
one to set reference to books say BooksIssue
2nd table ,reference to CD/DVD say CD/DVDissue table

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-20 : 07:03:37

Sounds like you need to design your entire DB.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources