Gossamer Forum
Home : General : Databases and SQL :

MS SQL server documentation (was: Is it just me or...)

Quote Reply
MS SQL server documentation (was: Is it just me or...)
...is there a distinct lack of MS SQL server documentation available?

I'm writing a script with currently only support MySQL but I want it to support MS SQL server but I can't find anything on the syntax differences or any tutorials regarding syntax :(

Are there any major differences that would cause problems...such as differences between table properties and syntax?

Im only using INT/VARCHAR/DATE/ENUM columns so far.




Edit title to reflect thread. Wil.

Last edited by:

Wil: Jun 17, 2002, 2:38 AM
Quote Reply
Re: [Paul] Is it just me or... In reply to
Yes,,,there are many differences...and to find out about them, go to the microsoft technet web site and search in SQL Server section.

Example, there is NO "date" column type. There is "smdatetime", "datetime", etc.

For ENUM, you need to use BIT (and use 1/0, true/false settings).

BTW: If you are writting a script to work with SQL Server, you really should learn Transact SQL (TSQL) and also how to write stored procedures.

Good luck.
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Stealth: Jun 16, 2002, 8:19 AM
Quote Reply
Re: [Paul] Is it just me or... In reply to
I agree, it seems harder than I first thought to find the differences. I was just looking for a simple function (LENGTH), to ensure it was portiable across various DB servers... but I stumbled looking for it under MS SQL. If anyone finds a nice function comparison chart/reference, i'd be interested in a look.

PS... Microsoft's site is a labyrinth to say the least.


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Jun 16, 2002, 9:49 AM
Quote Reply
Re: [Ian] Is it just me or... In reply to
The problem with it being a Microsoft product is that the documentation is there, but in books that cost about $50.
Quote Reply
Re: [Paul] Is it just me or... In reply to
And I am one to have a book or three! Sometimes its faster and fresher to search for content on the net... but I like to read away from the machine at times.

Also, often the information has been put into a more readable format, and the hard search work is done inside a book.

I have breifly used MS SQL 2000... I ran a directory database like Links SQL... stored proceedures and all. I actually find MySQL to be easier to understand, and for what I am doing, I can't see any difference in performace.

I am going to try and find that list of comparisions between functions for MySQL and MS SQL...


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Is it just me or... In reply to
I found a nice list once at mysql.com showing the differences but haven't been able to find it again.
Quote Reply
Re: [Paul] Is it just me or... In reply to
I'd recommend downloading the trial version of ms sql 2000, and look at books online. The docs that come with ms sql are really quite good.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Is it just me or... In reply to
I downloaded the demo a week or two ago. I even got stuck trying to create tables in a new database...you have to create a new DSN etc...hehe I got confused...so much easier with mysql :)

I'll try again and try to find something online....are the docs/books on the microsoft site?
Quote Reply
Re: [Alex] Is it just me or... In reply to
This seems to be the place:

http://www.microsoft.com/sql/support/default.asp
Quote Reply
Re: [Paul] Is it just me or... In reply to
This could be useful, too:

http://msdn.microsoft.com/...p?contentid=28000409

- wil
Quote Reply
Re: [Paul] Is it just me or... In reply to
I found this "Need to move from Linux-Apache-MySQL-PHP to Microsoft Windows, IIS, SQL, and ASP? "

http://www.microsoft.com/...providers/migration/


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Paul] Is it just me or... In reply to
They should get installed automatically (Look for "Books Online" in the start menu).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Is it just me or... In reply to
Thanks, I found it.