need query to Create relationship tables' script

Posted by Parthibansk under Sql Server on 8/8/2012 | Points: 10 | Views : 1259 | Status : [Member] | Replies : 3
need query to create many to many relationship script with example




Responses

Posted by: Rickeybglr on: 8/8/2012 [Member] Starter | Points: 25

Up
0
Down
can u plz ellaborate ur quest. i mean in wat sense wat actualy u want

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/4/2012 [Member] Bronze | Points: 25

Up
0
Down
CREATE TABLE Salespeople(SNUM INT,SNAME VARCHAR (25),CITY VARCHAR (25),COMM FLOAT)
CREATE TABLE Customers (CNUM INT,CNAME VARCHAR (25),CITY VARCHAR (25),RATING INT,SNUM INT)


SELECT C.CNAME,C.CITY,C.CNUM,C.RATING,C.SNUM,S.SNAME FROM Customers C JOIN Salespeople S ON S.SNUM=C.SNUM WHERE S.SNAME='STEVE' OR S.SNAME='ROBERT'

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Maheshvishnu on: 9/4/2012 [Member] Starter | Points: 25

Up
0
Down
make use of datarelation class and its members in ADO.Net

mahesh

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response