SQL tutorial?

10 pts.
Tags:
SQL
Hi , I am having some difficulty in interpretation of SQL questions , I am trying to learn the language self taught is there some interactive tutorial i can try

Answer Wiki

Thanks. We'll let you know when a new response is added.

<a href=”http://www.w3schools.com/sql/default.asp”>Here you can find </a>a good and easy tutorial on SQL
Here is a good reference on SQL Tutorial. Thousands of queries maintain SQL 2003 standard. http://www.w3resource.com/sql/tutorials.php
<a href=”Here is a good reference on SQL Tutorial. Thousands of queries maintain SQL 2003 standard. http://www.w3resource.com/sql/tutorials.php”>

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    If yoou have some specific questions, feel free to post them here.
    69,045 pointsBadges:
    report
  • BrentSheets
    Moderator Note: Lystra, as Carlosdl pointed out - as you run into specific issues - please feel free to return and post a questions with as much detail, as possible. Good luck here is another online tutorial you may wish to visit at SQLCourse dot com. And you may also wish to visit the SQL and SQL Server Tutorial and Reference Guide that has been created from content from fellow member and SQL guru Denny Cherry. Denny has a blog on IT Knowledge Exchange called SQL Server with Mr. Denny.
    6,925 pointsBadges:
    report
  • Tomatoes
    This SQL tutorial offers examples for each command so it's easy to learn along.
    10 pointsBadges:
    report
  • Radhakrishnatutika
    what is the diff bw procedure and function?
    10 pointsBadges:
    report
  • Kccrosser
    Generally (but not always): A Function can take formal input parameters, and cannot modify the parameters - instead the function returns one result parameter that is not in the formal parameter list. Further, normally a Function is prohibited from having "side effects" - i.e., a Function cannot alter the state of the system, change data in a table, etc. A Procedure can take input, output, and/or input/output parameters and can modify the contents of the parameters directly. Also, a Procedure is usually NOT prohibited from having "side effects" - it can modify the state of the system, change table contents, etc. Example:
    declare @a int;
    declare @b varchar(256);
    declare @c float;
    exec MyProcedure @a out, @b out;
    --  at this point, either or both of @a and @b can have different values than before the procedure call
    --  also, database tables could have been modified (or even created/dropped!)
    set @c = MyFunction(@a, @b);
    --  at this point, neither @a nor @b can be modified by MyFunction, but a result value is returned - nothing in the database should have been altered as a result of this call
    --  note that the following IS allowed, and is how you would use a function to modify the value of an argument:
    set @a = MyFunction(@a);
    3,830 pointsBadges:
    report
  • Ds1
    Here is a good reference on SQL Tutorial. Thousands of queries maintain SQL 2003 standard.
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following