摘要:
SET STATISTICS PROFILE ON --SET STATISTICS IO ON --SET STATISTICS TIME ONdeclare @dtm datetimeSQL语句print '添加person临时表数据:'+convert(varchar(10),DATEDIFF... 阅读全文
摘要:
看代码declare @iid intselect @iid=111select top 1 @iid=isnull(IID,0) from YYGL_PCDMX where IID=0print @iid上面的情况,如果iid=0没有记录,则@iid会取111,为了避免这个问题1、在查询前,初始化... 阅读全文