Trigger for update in sql server

     
  create trigger updates on stu             
     for update as begin declare
  @id int
  declare @Nname nvarchar(49),@Oname nvarchar(49),
   @Nage int,@Oage int,@Nsalary int,@Osalary int
  ,@ides int  ,@names nvarchar(49),@ages int,@salarys int,@dates nvarchar(30)
 
   select * into #temptable from inserted
   while(exists(select id from #temptable))
   begin
   select top 1 @id=id,@Nname=name,@Nage=age,@Nsalary=salary from #temptable
   select @Oname= name,@Oage=age,@Osalary=salary from deleted
 
   if(@Oname <> @Nname)
   
   set @names=@Nname
   
   if(@Oage <> @Nage)
   
   set @ages=@Nage
   
  if(@Osalary <> @Nsalary)
 
  set @salarys=@Nsalary
   
   set @dates=cast(getdate() as nvarchar(30))
   insert into backs values(@id,@names,@ages,@salarys,@dates)
   delete from #temptable where id=@id
   end
   end
 

Trigger for insert in sql server

    create trigger inserts

    on srudent

    for insert as begin declare

                 @id int,

                 @name nvarchar(30),

                 @gender nvarchar(7),

                 @age int

                 select @id= id ,@name=name,@gender = gender,@age=age from inserted

                 insert into backs values('New id is '+cast(@id as nvarchar(10))+' New name is '+@name+' New gender is '+@gender+' new age is '+cast(@age as nvarchar(10))+' Date is '+cast(getDate() as nvarchar(20)))

                   end

trigger for delete in sql server

create trigger Deletes
    on srudent
    for delete as begin declare
                 @id int,
                 @name nvarchar(30),
                 @gender nvarchar(7),
                 @age int
                 select @id= id ,@name=name,@gender = gender,@age=age from deleted
                 insert into backs values('New id is '+cast(@id as nvarchar(10))+' New name is '+@name+' New gender is '+@gender+' new age is '+cast(@age as nvarchar(10))+' Date is '+cast(getDate() as nvarchar(20)))
                   end
   

inner join in sql server

create database shop

use shop

create table product(pid int primary key ,
pname nvarchar(30),
pp int,
sp int)

create table category(id int primary key,pname nvarchar(29))

alter table product add cID int foreign key references category(id)


create proc insrt
@id int,
@name nvarchar(10),
@pp int,
@sp int,
@cID int
as begin 


insert into product values(@id,@name,@pp,@sp,@cID)
end
exec insrt 10,'i phone',33,332,11

update procedure in sql server

/////////////////////////////////****************  Home ***************/////////////////////

import javax.swing.JPanel;

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author bilal
 */
public class Home extends javax.swing.JFrame {

    /**
     * Creates new form Home
     */
    public Home() {
        super("Home");
        initComponents();
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                       
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        p4 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        p1 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        p2 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        p3 = new javax.swing.JPanel();
        jLabel6 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jToolBar1 = new javax.swing.JToolBar();
        jButton4 = new javax.swing.JButton();
        jButton13 = new javax.swing.JButton();
        jButton11 = new javax.swing.JButton();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();
        jMenuItem2 = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();

foreign key in sql server

create database shop use shop create table product(pid int primary key ,pname nvarchar(30),pp int,sp int)create table category(id int primary key,pname nvarchar(29))alter table product add cID int foreign key references category(id)

how to insert value in table using sql server

how to insert value in table using sql server

insert into students(id,name,course) values (9,'bilal','BSE')

How to create a table in sql server

How to create a table in sql server

 create table students
(
      stdID int primary key,
    Name nvarchar(30),
    Course nvarchar(30)
)

how to create a database in sql server

How to create a database in sql server

create database college

after this you write

use college