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.
| Author |
Topic |
|
bigoxygen
Starting Member
1 Post |
 Posted - 2005-04-06 : 17:40:34
|
| Hi. I'm a newbie at SQL ServerI thoroughly know MySQL, but I am having a hard time getting started with SQL Server.Basically, I'm trying to set up a simple, local PHP site which has a SQL Server backend. Is there a quick and dirty (and cheap) way of doing this?Also, are there any resources you recommend for using SQL Server?Are there any places that tell you step-by-step how to install and create tables? I don't even know how to create the tables...where do I type in the SQL code?Many Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-06 : 19:40:10
|
quote:
Also, are there any resources you recommend for using SQL Server?
Well, you've already found the one we'd recommend the most.  Besides SQL Team, Books Online should be your first stop for all SQL Server questions. It is better to browse it and read it just for education rather than trying to find a specific answer, at least in the beginning, so that you become familiar with it first. Once you do that you'll be able to find things far more quickly and easily.I'd suggest going to http://www.php.net/ for questions related to working with SQL Server and PHP. Things like connecting to the database, manipulating results and displaying them on a web page would be best answered there. Anything not related to PHP like database design, SQL queries, performance tuning and such we can answer for you.As far as creating tables, try looking in Books Online under, believe it or not, "CREATE TABLE". You can use Query Analyzer to connect to your SQL Server and run whatever commands you need to. You can also use Enterprise Manager, but you're far less likely to learn anything if you use it.You'll need to install the SQL Server client tools on your computer before you can use Query Analyzer or Enterprise Manager. They're on the SQL Server installation CD, choose Client Tools when you get to that point in the install process. |
 |
|
|
|
|
|
|
|
How to Get Started with SQL Server 2000