错误信息:
[Microsoft][ODBC SQL Server Driver][SQL Server]'Now' is not a recognized built-in function name.SQL语句:
sql="CREATE TABLE [test] ("
sql=sql&" [logindate] smalldatetime NULL default "&SqlNowString&" "
sql=sql&")"
conn.execute(sql)大家帮忙下~!谢谢
[Microsoft][ODBC SQL Server Driver][SQL Server]'Now' is not a recognized built-in function name.SQL语句:
sql="CREATE TABLE [test] ("
sql=sql&" [logindate] smalldatetime NULL default "&SqlNowString&" "
sql=sql&")"
conn.execute(sql)大家帮忙下~!谢谢
sql="CREATE TABLE [test] ("
sql=sql+" [logindate] smalldatetime NULL default ''SqlNowString'' "
sql=sql+")"
conn.execute(sql)
sql="CREATE TABLE [test] ("
sql=sql+" [logindate] smalldatetime NULL default ''SqlNowString'' "
sql=sql+")"
conn.execute(sql)
sql=sql&" [logindate] smalldatetime NULL default "&SqlNowString&" "
这里的SqlNowString作为变量 可以直接连接
sql=sql&" [logindate] smalldatetime NULL default ''SqlNowString'' " 这样就OK
这样不行
错误信息:
[Microsoft][ODBC SQL Server Driver][SQL Server]The name "SqlNowString" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
这样试试看
sql = "CREATE TABLE [test] (";
sql = sql + " [logindate] smalldatetime NULL default '" + SqlNowString + "' ";
sql = sql + ")";
conn.execute(sql);
No such interface supported
我又尝试引用自定义函数要加架构名 dbo.getdata()也不行,返回错误:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Getdate'.不允许在用户定义函数主体中内置不确定函数 getdate()就是不确定函数这些才是问题的关键,求哥哥姐姐们给出一个解决办法~!~!~!
sql="CREATE TABLE [test] ("
sql=sql&" [logindate] smalldatetime default "&SqlNowString&" NULL,"_&")" conn.execute(sql)
前面加个视图
CREATE VIEW v_GetDate
AS
SELECT dt=GETDATE()
GO
然后
sql=sql&" [logindate] smalldatetime NULL default (select dt from v_GetDate) "
string SqlNowString = DateTime.Now.ToString();