本文介绍了在datatime附近给出错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个问题:
string query = Insert into IndividualTestSkills选择TestID,TestName,Date.now 来自 ALTest.ALBulkTestMaster where TestID = + m_obj.NewTestID.ToString()++ ' ;显示多部分:无法找到标识符Date.now。
解决方案如果您在SQL Server中尝试getdate() string query =将插入 IndividualTestSkills选择TestID,TestName,getdate()来自 ALTest.ALBulkTestMaster 其中 TestID = + m_obj.NewTestID.ToString()++ ';
I have a querry:
string query = Insert into IndividualTestSkills Select TestID,TestName, Date.now from ALTest.ALBulkTestMaster where TestID= + m_obj.NewTestID.ToString() ++ "'";Showing the multi-part: identifier Date.now could not be found.
解决方案 If you're in SQL Server try "getdate()" string query = Insert into IndividualTestSkills Select TestID,TestName, getdate() from ALTest.ALBulkTestMaster where TestID= + m_obj.NewTestID.ToString() ++ "'";更多推荐
在datatime附近给出错误
发布评论