Thursday, 7 August 2014

What is diffrence beetween alter and update

Hello friends
Today i will tell you what is difference between alter and update

Update -update is use for updating the records on the table

Alter -alter is use for updating the structure of table suppose you want to add some coloumn in table so you have need to use alter command


Thanks


Saturday, 12 July 2014

How to see data beetween to values

Hello friends

Today i will tell you how to see data between to values


Suppose you create a table Employee where two fields name and salary and you want to see
where salary between 5000 to 10000 and you have so many records



So you have to write following query


Select * from Employee where salary between 5000 and 10000



Thanks

Friday, 27 June 2014

How to see date in sql server

Hello Friends
Today i will tell you how to see the Date in sql server
you have to write following query in sql server


Select GetDate()
Go

Thanks