如下所示:
update syn_table set LocalTime = (select max(freshtime) from SMS_SendSMS) where TableName='SMS_SendSMS'
表SMS_SendSMS不一定存在,现在想得到一个sql语句,如果表存在的话LocalTime = (select max(freshtime) from SMS_SendSMS),如果不存在的话LocalTime = 0,在线等,立马结贴!
update syn_table set LocalTime = (select max(freshtime) from SMS_SendSMS) where TableName='SMS_SendSMS'
表SMS_SendSMS不一定存在,现在想得到一个sql语句,如果表存在的话LocalTime = (select max(freshtime) from SMS_SendSMS),如果不存在的话LocalTime = 0,在线等,立马结贴!
if exists(select 1 from sysobjects where name='SMS_SendSMS')
update syn_table set LocalTime = (select max(freshtime) from SMS_SendSMS)
else
update syn_table set LocalTime = 0
??
(select max(freshtime) from SMS_SendSMS) else 0 end where TableName='SMS_SendSMS'
update syn_table set LocalTime = (select max(freshtime) from SMS_SendSMS) where TableName='SMS_SendSMS'
else
update syn_table set LocalTime =0 where TableName='SMS_SendSMS'
exist是exists哦,嘻嘻!