| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
SQL help?
|
Original Message
|
Name: Anders
Date: May 14, 2003 at 14:37:21 Pacific
Subject: SQL help?OS: xpCPU/Ram: 256 |
Comment: Lets say I have 2 tabels. tbl_Customer and tbl_Profile. I have a PK called cust_ID and a FK in tbl_profile called cust_IDRef. A customer may noly have 3 Profiles, if he tries to add another profile he is not allowed. Hmmm, hope you understood it. How do I do this???
Thx in advance...
Report Offensive Message For Removal
|
|
Response Number 1
|
Name: Don Arnett
Date: May 15, 2003 at 16:44:42 Pacific
|
Reply: I don't think that you can do this (prevent a forth profile being added) strictly thru SQL. You'd have to write a script or program (maybe a trigger or stored procedure) that checks the number of existing profiles before adding a new profile.
 Report Offensive Follow Up For Removal
|
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Programming Forum Home
Results for: SQL help?
SQL Help Summary: I have this series of SQL statements could someone please simple explain what each line does. I know what this does but i am not sure about how it is achieved. The SQL statements orders the table in D...
www.computing.net/answers/programming/sql-help/6312.html
SQL Help! Summary: Hi, I have a simple SQL problem here. Currently I have 2 tables (A & B, let say) within my SQL database. I want to append all the records (5 fields, 10+ rows, let say) from the table A into table B, ...
www.computing.net/answers/programming/sql-help/10974.html
SQL help plesae Summary: Hello helper I need help with the sql code. I need the sql to get information that is unique. For example if i have {1,2,3,4,4,5,6,6,7} in a column. the output should be {1,2,3,5,7}. now i would not...
www.computing.net/answers/programming/sql-help-plesae/12325.html
