華閱文章網插入觸發器
首先設置表BorrowRecord的字段BorrowRecord為自增然后執行以下SQL
Create trigger TriggerTest on student
for Insert
as
declare @iStudentID varchar(10)
select @iStudentID =StudentID
from inserted
begin
insert into BorrowRcord(StudentID,BorrowDate)
values(@iStudentID,getdate())
--getdate（)為系統當前時間，ReturnDAte時間不知道從何處來
end
return
GO
滿意請采納。
oracle 通過 如何截取 年月日（date）、年月日時分秒（timestamp）中
通用的權限 我在下面的代碼中表空間用SGMPM替代了.你自己用自己的表空間替換
GRANT CREATE DATABASE LINK TO "SGMPM";
GRANT CREATE JOB TO "SGMPM";
GRANT CREATE PROCEDURE TO "SGMPM";
GRANT CREATE SEQUENCE TO "SGMPM";
GRANT CREATE SESSION TO "SGMPM";
GRANT CREATE TABLE TO "SGMPM";
GRANT CREATE TRIGGER TO "SGMPM";
GRANT CREATE TYPE TO "SGMPM";
GRANT CREATE VIEW TO "SGMPM";
GRANT DEBUG ANY PROCEDURE TO "SGMPM";
GRANT DEBUG CONNECT SESSION TO "SGMPM";
GRANT UNLIMITED TABLESPACE TO "SGMPM";
GRANT "CONNECT" TO "SGMPM";
GRANT "RESOURCE" TO "SGMPM";
GRANT "DBA" TO "SGMPM";
修改表名： rename 舊表名 to 新表名；
修改列名： alter table table_name rename column 舊列名 to 新列名；
希望有點幫助。
如何使用DW連接SQL數據庫？我的系統是64位的,dw的od只支持32
$rm=mysql_query("SELECT * FROM `pql_spices` ORDER by rand()");
$i = '1';
$td=[];
while ($rmx=mysql_fetch_array($rm))
{
$Total+=$rmx['Price'];
$Total_standard+=$rmx['standard'];
$td[]=$row;
$end=end(array($td));
