Topic awaiting preservation: MySQL user needs help with MS SQL (Page 1 of 1)

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

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

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)

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

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