Writing Queries Easily in MS Sql Server

[VelMurugan]

Writing Queries Easily in MS Sql Server

<bold>Practice Queries : Its very Easy....</bold>

<bold><italic>Creating a table</italic></bold>

Create table student_info(roll varchar(25),subject varchar(100),marks int,dateofEntry datetime,fees money)

<bold><italic>Inserting values</italic></bold>

insert into student_info values('A24','English',78,'11/12/2005',50)
insert into student_info values('BCA24','French',88,'11/14/2005',250)

Explanation:
Varchar must be inside ''. It is not required in the case of int.
datetime must be entered in (mm,dd,yyyy) format. Money is its own format.

<bold><italic>Selecting all values from table</italic></bold>

select * from student_info

<bold><italic>Selecting values based on condition, from a table </italic></bold>

select * from student_info where roll='A24'


<bold><italic>Selecting values based on starting letter </italic> </bold>

select * from student_info where roll like 'A%'

Explanation :
The roll numbers starting with alphabet 'A' will be retrived.

<bold><italic>Selecting values based on middle letters </italic> </bold>

select * from student_info where roll like '%A2%'

Explanation :
The roll numbers having alphabets 'A2' in the middle,will be retrived.
Here," BC<italic>A2</italic>4"

Source : ExpertsForge