Question

asp.net向sql中添加当前系统时间在数据库中设置了默认值,sql语句怎么写

Answer 1

粘了一句存储过程的过来,将就看吧.
SET @TIME =(SELECT TOP 1 CreateTime from LangDui_Info where IP=@ip ORDER BY CreateTime DESC)
IF( datediff( minute ,@TIME,getdate())<29)

Answer 2

SQL="UPDATE table_name Set 你要修改的字段 = ‘“+DateTime.Now+”’ Where 条件";

Answer 3

SQL Server:
UPDATE tablename SET Time字段='getdate()' WHERE条件