Newbie needs 3rd-grade tutorial on SQL Server

[Phil Powell]

Point me in the right direction, folks.. very basic level SQL Server
tutorial for someone that has only worked mainly with mySQL and Access...

I am coding in ASP and I need to create the connection object, do everything
I need to do and close it. I have absolutely NO idea how to do it.

Thanx
Phil

[Aaron Bertrand - MVP]

The only thing that's /really/ different is the connection string.

[url]http://www.aspfaq.com/2126[/url]

There are also some differences such as how dates are handled, and string
manipulation functions that have different names, most of which are captured
here:

[url]http://www.aspfaq.com/2214[/url]

But as far as just connecting, running a SELECT * query, and closing, the
only part of the code that should change is the connection string.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Phil Powell" <soazine@erols.com> wrote in message
news:CebYb.25$iB.22@lakeread06...

> Point me in the right direction, folks.. very basic level SQL Server
> tutorial for someone that has only worked mainly with mySQL and Access...
>
> I am coding in ASP and I need to create the connection object, do

everything

> I need to do and close it. I have absolutely NO idea how to do it.
>
> Thanx
> Phil
>
>

[Chris Hohmann]

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:eA7dXqN9DHA.1052@TK2MSFTNGP12.phx.gbl...

> But as far as just connecting, running a SELECT * query, and closing,

the

> only part of the code that should change is the connection string.

The original poster may also want to avoid using "SELECT *". Here's an
article. ;-p
[url]http://www.aspfaq.com/2096[/url]

[Aaron Bertrand - MVP]

> The original poster may also want to avoid using "SELECT *". Here's an

> article. ;-p
> [url]http://www.aspfaq.com/2096[/url]

Hey, thanks Chris, I thought SELECT * was nice and easy. :-)

[The Nordic One]

Thanx I figured it out by learning of the connection string
configuration.. thanx!

Phil

---------------------------------------
TCL and PHP: The Superior Web Languages!
Javascript: Is Cool
ASP: why?
[url]http://valsignalandet.com[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bullschmidt]

SQL Server Info. (From Microsoft's MSDN Online Library)
[url]http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ts_t[/url]
sqlcon_6lyk.htm

SQL Server Home
[url]http://www.microsoft.com/sql[/url]

SQLTeam.com
[url]http://www.sqlteam.com[/url]
Site is mostly about SQL Server and includes forums.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[The Nordic One]

Avoid using SELECT???!??!?!

That's like telling a content management specialist to avoid querying
for any content!! That's outrageous!! What am I supposed to use instead?
The article offers NO alternative!

Phil

---------------------------------------
TCL and PHP: The Superior Web Languages!
Javascript: Is Cool
ASP: why?
[url]http://valsignalandet.com[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand [MVP]]

> Avoid using SELECT???!??!?!

No, that's not what he said.

Read the article he posted. I was just being lazy.