评论会员:阿米尔Mahfoozi 时间:2012/02/07
喜阿明,
那就是:
{C} 希望它帮助
评论会员:游客 时间:2012/02/07
KARTHIKHarve:试试这个..codeprelang="SQL"spanclass="code-keyword"DECLARE/span@Start_Timespanclass="code-keyword"DATETIME/span,@End_Timespanclass="code-keyword"DATETIME/spanspanclass="code-keyword"SET/span@Start_Time=spanclass="code-keyword"CONVERT/span(spanclass="code-keyword"DATETIME/span,spanclass="code-string"'/spanspanclass="code-string"08:00:00'/span,spanclass="code-digit"103/span)spanclass="code-keyword"SET/span@End_Time=spanclass="code-keyword"CONVERT/span(spanclass="code-keyword"DATETIME/span,spanclass="code-string"'/spanspanclass="code-string"16:00:00'/span,spanclass="code-digit"103/span) spanclass="code-keyword"WHILE/span(@Start_Time<=@End_Time)spanclass="code-keyword"BEGIN/spanspanclass="code-keyword"SELECT/spanspanclass="code-keyword"CONVERT/span(spanclass="code-keyword"VARCHAR/span(spanclass="code-digit"8/span),@Start_Time,spanclass="code-digit"108/span)spanclass="code-keyword"SET/span@Start_Time=(spanclass="code-keyword"SELECT/spanDATEADD(minute,spanclass="code-digit"30/span,@Start_Time))spanclass="code-keyword"END/span/pre/code希望这有助于...