introduction of store procedure in mssql server

Hello friend, It is very bad habit and difficult to write separate sql query for each operation in sql query. The best solution for this problem is procedure . Procedure is similar to function which we will learn in next chapter, is collection of code which can be executed at any time. To create a procedure open

website-database connectivity using web.config

website-database connectivity using web.config Today, we will learn database connectivity using web.config <connectionStrings> property. The main advantage of using connection string in web.config are: Security– Web.config file is the configuration file which stores all the server setting required for the web application. And IIS server never allows to browse or view web.config file through browser. So

insert, delete and update queries using mssql server

Insert Query insert into table_name(column1,column2,column3,column4) values(value1,value2,value3,value4) We can also use design view to insert values into table. If you dont know how to create a table please follow the previous post create a table in mssql server . Just Right click on the Table_name in which you need to insert the table and select open table. Now put the