Showing posts with label Rename Colum Name Sql. Show all posts
Showing posts with label Rename Colum Name Sql. Show all posts

Sunday, August 3, 2014

Rename Colum Name Sql



Createtablesample
(
ID int,
F_Name nvarchar(20),
L_Name nvarchar(20)
)
insertintosample(ID,F_Name,L_Name)values(1,'Ajay','Pravin')
insertintosample(ID,F_Name,L_Name)values(2,'udhaya','Kumar')
insertintosample(ID,F_Name,L_Name)values(1,'Ravi','Kumar')

Select ID,F_Name as First_Name, L_Name as Last_Name fromsample