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 |
|
Lionmane
Starting Member
2 Posts |
 Posted - 2006-04-05 : 04:43:14
|
| Hi! Our company is putting together a website and my boss wants to use SQL for our database(s). It will have a shopping cart to hold customer information temporarily and another member database. He also wants a database to hold marketing information that will undoubtedly need to cross reference with the customer database (and probably the shopping cart too). It will probably have to be a custom job... :-(It seems that there are different versions of SQL that we can use. Can anyone suggest a good one? When I say "good", I'm generally referring to one that has good informational support (books, etc). And hopefully has few bugs too. And is compatible with EVERYTHING (with none of the Microsoft-induced incompatibility issues). And will program itself!What kind of program do I use to run SQL code when I'm writing it? A compiler?Thanks!mw |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-05 : 04:58:51
|
will program itself?? what do you mean?since this is an mssql forum, go for the 2005 version since 2000 is "obsolete"  kidding aside, the package comes in with a book (BOL), a "compiler" (parser), and the tools (gui-enterprise manager, scripting - query analyzer)HTH--ok i need a time out today...--------------------keeping it simple... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-05 : 05:00:47
|
"It seems that there are different versions of SQL that we can use"Yes. Either you go for SQL Server 2000 or 2005."And will program itself!"We will be out of job if it can program itself  "What kind of program do I use to run SQL code when I'm writing it?"For SQL Server, typically you code in T-SQL. As for front end, you can use ASP.NET for the presentation.
KH |
|
|
|
Lionmane
Starting Member
2 Posts |
Posted - 2006-04-05 : 13:06:11
|
| Ah, crap. I didn't see the "Microsoft" part of the "Microsoft SQL Server articles, news and forums"... :-(I guess Microsoft has brainwashed me into not being able to detect their logo so they can force their products onto me UNAWARES! :-)Is this a Microsoft-owned website? Are there any SQL websites that aren't focused on Microsoft?mw |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-05 : 16:55:40
|
| It's not Microsoft owned (unless Graz's sold out) but focuses on sql server and a few other related things.I think you are looking to choose a database (rather than SQL which is a language).It doesn't sund as though you will have high volumes (otherwise you really need to get some help) so almost anything will do.msde (sql server 2000) or sql server express (sql server 2005) are free (as is Oracle express I believe)other popular choices areaccess (probably wouldn't recommend it)mysql (open source but not free)the larger databasessql serveroracledb2sybase....==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2006-04-05 : 17:22:09
|
quote:
Originally posted by nraccess (probably wouldn't recommend it)
Agreeing with Nigel and expanding: Access will KILL your web site's performance because it runs so much in memory. It has its good uses, but back-ending a web site is not one of them.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
|
|
Uh... Now what?