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,
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?
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!
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