sql server 2008 r2疑问 [英] sql server 2008 r2 doubt

问题描述

大家好，

我在ssms写这样的示例代码是否正确你能不能建议我



选择empid，来自员工的empname作为来源（empid，empname）



谢谢和问候，

prakash.ch

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

推荐答案

好吧，它不会运行。但是你知道，因为你已经测试过了，对吧？

试试

Well, it won't run. But you know that because you have tested it, right?
Try

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

不包括作为来源（empid，empname）

don't include as source(empid,empname)

这篇关于sql server 2008 r2疑问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！