INSERT UPDATE DELETE USING STORED PROCEDURE

INSERT UPDATE DELETE USING STORED PROCEDURE

STORED PROCEDURE

ALTER procedure RegIns(
@id int,
@username varchar(25),
@Password varchar(35),
@Count int

)
as
begin
if @count=1
begin
update reg set  Password=@Password ,username=@username where id=@id
end
else if @count=2
begin

JOINS IN SQL SERVER

JOINS:

              Some times data retrieve from multiple table using joins.

              Sql joins used to combines rows from two or more tables based on a common field.          

             

             The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.

INSERT,UPDATE,DELETE,LIKE,SELECT DISTINCT IN SQL SERVER

INSERT,UPDATE,DELETE,LIKE,SELECT DISTINCT IN SQL SERVER

INSERT

The INSERT INTO statement is used to insert new records in a table.

Syntax

INSERT INTO table_name VALUES (value1,value2,value3,...);

SQL Notes For Database,Table,Constraints and Functions

SQL Notes For Database,Table,Constraints and Functions

DATABASE:

1        It is a Collection of  Tables

2        System Databases          

Trigger In Sql Server

Trigger

     A trigger is a special kind of stored procedure.

     which automatically on the happing of event like before after insert,update or delete.

      we cannot call a trigger explicitly from a stored procedure.

Stored Procedure

Stored Procedure

                             Set  pre-compiled  SQL statement. That are Stored in Database.

                             Multiple user can share the single Procedure.

                            Stored Procedure can accept multiple inputs and output.

Difference between function and stored procedure

Difference between function and stored procedure:

• Procedure can return zero or n values whereas function can return one value which is mandatory. 

• Procedure allow select as well as Data Manipulation Language statement (Insert,update,delete,select) in it whereas function allow only select statement in it. 

Create Login page in asp.net using Stored Procedure

Create Login page in asp.net using Stored Procedure

Create table in sql:

create table login(id int identity,username varchar(max),password varchar(max))

insert into login values('aravindh','aravindh')