insert | update | delete query in sqlserver 2005-2008 with examples

select * from feesentry_tb.

1	300	300
2	200.34	344.98
3	203.34	344.98
3	203.34333	344.93338
4	203.34333	344.93338
NULL	NULL	NULL

DELETE FROM feesentry_tb
WHERE        (stud_rollno = 3)
after deleting two rows from table.
select * from feesentry_tb

1	300	300
2	200.34	344.98
4	203.34333	344.93338

UPDATE feesentry_tb SET Paidfee = 600 WHERE (remain_fee = 300)

1	600	300
2	200.34	344.98
4	203.34333	344.93338

Share This