Click here to Skip to main content
15,178,008 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,
I am writing sample code like this in ssms is it correct could you suggest me

"select empid,empname from Employee as source(empid,empname)"

Thanks & Regards,
prakash.ch
Posted
Comments
chimcham 13-Jul-13 3:07am
   
SELECT empid, empname
FROM Employee
chimcham 13-Jul-13 3:08am
   
don't include as source(empid,empname)

Well, it won't run. But you know that because you have tested it, right?
Try
SQL
SELECT empid, empname FROM Employee
And it will at least run.
Is it correct? Who knows? We don't because we have no idea what you are trying to do other than retrieve the values of two columns!
   
SQL
SELECT empid, empname 
FROM Employee


don't include as source(empid,empname)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900