mywall, Sql Server

mywall

CREATE TABLE Student(
    Sid INTEGER CONSTRAINT stu_sid_pk PRIMARY KEY, Sname VARCHAR(20) CONSTRAINT stu_sname_nn NOT NULL,
    Dept VARCHAR(5), Address VARCHAR(50));
    INSERT INTO Student VALUES(1, 'pavan', 'cse', 'chimakurthi');
    INSERT INTO Student VALUES(2, 'surya', 'cse', 'kolar'),(3, 'rakesh', 'cse','redhills');
    INSERT INTO Student VALUES(4, 'Anjali', 'ece', 'thiruvunanthapuram'),(5, 'Vamsi', 'cse', 'ANNA nagar'),(6, 'phani', 'cse', 'Trichy');
    INSERT INTO Student VALUES(7, 'Surya', 'ece', 'Kanchi'),(8, 'asrith', 'cse', 'Pondicherry'),(9, 'akhil', 'eee', 'nellore'),(10, 'sagar', 'eee', 'tirupathi'),(11, 'Hemanth Bathula', 'cse', 'tenali'),(12, 'Rahul', 'cse', 'kavali');
    INSERT INTO Student VALUES(13, 'Abhilash', 'cse', 'vijayawada');
    ALTER TABLE Student ADD Fee INTEGER;
    UPDATE Student SET Fee = 600000;
    UPDATE Student SET Fee = 800000 WHERE Fee = 600000;
    ALTER TABLE Student ADD Age INTEGER, City VARCHAR(20), State VARCHAR(20), PinCode INTEGER;   
    UPDATE Student SET Age = 20 WHERE Fee = 800000;
    UPDATE Student SET City = 'hyderbad', PinCode = 523226 WHERE Sname = 'pavan';
    UPDATE Student SET City = 'Banglore', PinCode = 653436 WHERE Sname = 'surya';
    UPDATE Student SET City = 'chennai' WHERE Sname = 'rakesh';
    UPDATE Student SET State = 'ANDHRA PRADESH' WHERE City = 'hyderbad';
    UPDATE Student SET State = 'KARNATAKA' WHERE City = 'Banglore';
    UPDATE Student SET State = 'TAMIL NADU' WHERE City = 'chennai';
    SELECT * FROM STUDENT;


run \| edit \| history \| help	0