Insert ,Select,Update,Delete In SQL serevr



Insert ,Select,Update,Delete In SQL serevr


Insert one Row to Accountmaster  

INSERT INTO Accountmaster VALUES(125,'JHON',8,2000)

Seletect  Accountmaster

SELECT * FROM Accountmaster

Select One row with where condition from Accountmaster 

SELECT * FROM Accountmaster WHERE AcNo=125

Update Accountmaster

UPDATE Accountmaster SET [ACNAME]='JHON MARK',[AGE]=25 WHERE AcNo=125

Delete All account

DELETE FROM Accountmaster

Delete one Row

DELETE FROM Accountmaster WHERE AcNo=125

No comments:

Post a comment