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?
ThanxFirst 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)|||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.|||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|||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
No comments:
Post a Comment