為什么我寫的一個顯示系統時間的小腳本不能在這里顯示出來?
還有就是如何使用DOM的getelementbyid方法顯示系統時間?
<SCRIPT LANGUAGE="JavaScript">
<!--
var timerID = null
var timerRunning = false
function showtime(){
var today,hour,second,minute,year,month,date;
var strDate ;
today=new Date();
var n_day = today.getDay();
switch (n_day)
{
case 0:{
strDate = "星期日"
}break;
case 1:{
strDate = "星期一"
}break;
case 2:{
strDate ="星期二"
}break;
case 3:{
strDate = "星期三"
}break;
case 4:{
strDate = "星期四"
}break;
case 5:{
strDate = "星期五"
}break;
case 6:{
strDate = "星期六"
}break;
case 7:{
strDate = "星期日"
}break;
}
year = today.getYear();
month = today.getMonth()+1;
date = today.getDate();
hour = today.getHours();
minute =today.getMinutes();
second = today.getSeconds();
if(month<10) month="0"+month;
if(date<10) date="0"+date;
if(hour<10) hour="0"+hour;
if(minute<10) minute="0"+minute;
if(second<10) second="0"+second;
timeValue =year + " 年 " + month + " 月 " + date + " 日 " + strDate +" " + hour + ":" + minute + ":" + second
document.GG.MM.value = timeValue
wuxingjia= setTimeout("showtime()",1000)
}
//-->
</SCRIPT>
</HEAD> <BODY onLoad="showtime()">
<FORM NAME="GG" onSubmit="0">
<INPUT TYPE="text" NAME="MM" SIZE=40 >
</FORM>
1、取出剛剛插入(刪除)的數據SELECT 字段名 FROM INSERTED(DELETED)
2、對于UPDATE實際上是先DELETE然后再INSERT所以如果想得到UPDATE前后的數據值,應該先從DELETED取出,然后從INSERTED取出;
3、IF UPDATE(列名)可以判斷更新或插入哪一個字段的值;
4、@@ROWCOUNT可以判斷上一行查詢操作得到的列數;
5、給變量賦值用SET @ZQB = 13;
6、察看是否有符合條件的記錄IF EXISTS (SELECT name FROM sysobjects WHERE name = 'reminder' AND type = 'TR');
7、定義游標,如下:
DECLARE c1 CURSOR FOR
SELECT emp_mgr.emp
FROM emp_mgr, inserted
WHERE emp_mgr.emp = inserted.mgr
OPEN c1
FETCH NEXT FROM c1 INTO @e--從游標中取出數據
WHILE @@fetch_status = 0--判斷是否到最后
BEGIN
UPDATE emp_mgr
SET emp_mgr.NoOfReports = emp_mgr.NoOfReports + 1 -- Add 1 for newly
WHERE emp_mgr.emp = @e -- added employee.
FETCH NEXT FROM c1 INTO @e
END
CLOSE c1
DEALLOCATE c1--刪除游標引用