can anyone guide me

Hot Topic

SQL Express and Reporting Services not available until June 2006?
Help! Can I control the recursion times of a recursive CTE?
my value doesnt reset when i used sum(field, scope)
"Login Failed" for sqlcmd using integrated on Vista Beta 2
Can replication be ran on a MS sharepoint database?
Connecting to SQL server 2005 express in LAN Using C# express
P2P Replication Conflicts
How to setup a dataflow which validates before writing to a destination ?
Slow performance calculated members
Connectivity Issues in AMO

SQL Server

I can't change my sql login user's password in SQL Server 2005 Express
using distinct on one column only
Drop and Recreate Excel table
Licensing Question ?
.Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."
Calling WebService in SQL2K5 - Error generating XML ...
Cannot find folder "\Maintenance Plans".
SQL Express - Can't run a create table query
How to abort from a Replication process
FTP Task error when no files found on FTP

can anyone guide me

i'm very new to SQl server, even i know nothing about it, all what i know about is Ms Access, i want to ask that :-
1) what is the differences between the queries and the stored procedures, i don't know till now i see both of them are the same thing. can anyone please till me what is the difference
2) i downloaded sql server express edition and it doesn't has interface , in the same time i can't install the managment studio , every time i i try to install it , it gives me message says "the administrator set policies to prevent this installation". so is there anyone has a solution for this ,or can tell me what i can use as interface for sql server

Thanx


Answer this question

can anyone guide me

  • Vern Jimmerson

    First of all, get a copy of SQL Books Online.  The 2005 version is available from MS - just search for SQL SERVER BOL 2005 and you'll get a link.

    1) Stored procedures basically allow modular programming.  They have many features that benefit, security, simplicity, performance.  It's hard to answer in a quick post, the best thing for you to do is to try creating some procedures and using them, then do the same thing in manual query. Books online is invaluable in explaining these kinds of things.

    2) Express doesn't have the management studio bundled, you need to download SQL Server Management Studio Express Edition seperately (do a similar download search on MS for SSMSEE)


  • MKeeper

    Thx Mark and Mulhall
    the information about stored procedures was so helpfull to be to understand what is the difference particulary the links that mark provided me with

    but regarding to SQL Server Managment Studio i have the Express Edition allready , and i don't have previous edition because as i said i'm very new to this, even though when i try to install SQl Server Management Studio it keep giving me error message "The Administrator has set policies to prevent this installation, is there any guidance
    Thx

  • xBrioUser

    There is a set of introductory resources available at http://msdn.microsoft.com/SQL/2000/learn/default.aspx that I have found very helpful.  For example, there is a Stored Procedures lesson at http://msdn.microsoft.com/library/default.asp url=/library/en-us/createdb/cm_8_des_07_31vb.asp.

    Regarding the interface, SQL Server Management Studio Express is currently available as a prerelease (what we call a Community Technology Preview or CTP) at http://www.microsoft.com/downloads/details.aspx familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en.

  • TeddyG

    Sorry for the other messege, i downloaded the SQl Server Management Studio Express Again and when i tried to install it , it worked seems it was a problem in the first time i downloaded it
    anyway thx guys

  • can anyone guide me
Answer this question