writing queries in sql server (2005/2008/R2 Edition)/*creating Database Syntax*/Create Database Sample/*Create Table Syntax*/create table Student(Sno numeric,Sname varchar(25),Sage numeric,Sdob datetime,Splace varchar(25))/*Inserting Values in Table*/insert into student values(103,'dhas',25,11/26/1990,'Tambaram')/*select Table*/select * from student/*Drop Table Syntax */drop table student/*Truncate table Syntax*/truncate table student/*Delete table syntax */delete from student/*update table*/update student set sname='amal' where sno=101/*Primary...
