SqlExpress Versus Sql Server 2005.
In general you can use both Express and the regular one. it doesn't matter.
However some features doesn't work with express version, but at the same time some of them wil require only express version to be installed on your system.
Yes at some cases you will need to setup two instances of the Sql servers at the same time.
generally the Sql Server 2005 will go first, then install the express version on top of the regular one.
Most of the Examples from the Professional Asp.Net Book will work with Express version.
For example in a case you need to import another database to sql server you better use the Regular one not the express, because there's an import option-wizard available in the Regular Sql Server 2005.
You can easily import EXEL databases by simply cliking the import button.
............
usually you will create an SQl databases in the VS.. I'm not an expert in sql server. but,
this kind of things are very easy to achieve.
basically all the databases will be created in the utility programm called Sql managment studio express.
Whithin the database it self you will be able to create a tables, usually the information is stored inside the tables.
attach/detach
Well let's keep it simple.. at the begining I didn't knew this my self, but as I realised from experementing with the sql server. attaching means this:
Imagine your self a database file that exists somewhere in your hard-drive..
So generally all of the sql databases have an MDF extention. For example: Northwind.mdf
Basically if you have this mdf file somewhere in your Pc you can attach it to your sql server.
The same thing with the detaching, once you attached the mdf file to your sql server you can detach it vice versa.
...As I remember, generally if you want to delete the database from the sql server you must first detach it from the sql server.
howevere it seems to me that attach/detach capability is not presented in the Express version.
I'm not sure, I simply don't remeber this one :)
..about the intermediate...
Well I think that all of the data that comes from User is going straight to the database table.
...
yep if you talking about complicated tasks like... for example: adding an update functionality to the gridview control. this allows you to Update information whithin a customers table for example. So, yep in this case yoou will need to setup-Write some code in the sqldatasource control that called parameters.Yes you can call this thing Intermadiate MODE, when the actuall data that comes from the user, first go's to the parameters, and only then it go's to the physical table in the database.. But this is very easy to understand, because you will realise that the only whay to do this is simply use this parameters everytime you want to update information within any table..Thinks ike this taking time to learn.
yep i know that there's a lot of things going on in the sql server, but believe me it's not that hard.
you simply must learn things here and there. I realised that things get easyer with the time... don't stop study. :)
|
