Closed Thread Icon

Topic awaiting preservation: MySQL user needs help with MS SQL (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=21988" title="Pages that link to Topic awaiting preservation: MySQL user needs help with MS SQL (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: MySQL user needs help with MS SQL <span class="small">(Page 1 of 1)</span>\

 
AT
Bipolar (III) Inmate

From: Louisville, KY, USA
Insane since: Aug 2000

posted posted 05-30-2004 14:24

Hey all, I'm needing to create a MS SQL database with one-to-many & many-to-many relationships. I'm use to MySQL but this client only allows Microsoft products in these things. I've never touched MS SQL until two days ago, and don't know really how to handle things, so I'm kinda overwhelmed. I was instructed to use Enterprise Manager, so I have that as well as Query Analyzer.

I appreciate the help

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 05-30-2004 16:31

well - what do you need to know? MSSQL handles standard sql 92 quite well - and has an extensive online help ('transactional sql reference') that you should've received along with enteprise manager and query analyzer.
If not, I'm certain it's available from the ms website (somewhere).

so long,

->Tyberius Prime

AT
Bipolar (III) Inmate

From: Louisville, KY, USA
Insane since: Aug 2000

posted posted 05-30-2004 17:38

Should I be able to set it up like I would MySQL and just do the querys as normal from ASP?
haha I've never written ASP, read on it but do a lot of PHP, hopefully it wont be too hard.
[edit]

Like they handle primary keys differently, don't they? or can I do it the same as I always do?

[/edit]


Thanks TP

(Edited by AT on 05-30-2004 17:52)

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 05-30-2004 17:57

depends - there'll be some minor differences, but both should work via odbc (see control pannel).
The actual details of accesses it of course depend on wether you're using ASP classic or ASP.net

AT
Bipolar (III) Inmate

From: Louisville, KY, USA
Insane since: Aug 2000

posted posted 05-30-2004 22:26

I think just ASP classic.

So I don't have to do anything 'special' when creating the one-to-many/many-to-many relationships?

So I create the table, put in the field names and make the main ID the primary key, and the other ID's are just there? Nothing special is done to them?

thanks TP, I do greatly appreciate your help

« BackwardsOnwards »

Show Forum Drop Down Menu