摘要:
三、函数1.创建标量函数:CREATE FUNCTIONfunction_name([parameter(参数)])RETURNS data_typeASBEGIN函数体RETURN return_valueENDEg: create function getNow()returns varchar(20)asbegin return convert(varchar(20),getdate(),120) end内嵌表值函数:CREATE FUNCTION function_name([parameter])RETURNS TABLEASRETURN (select查询语句)Eg: create 阅读全文
摘要:
二、存储过程1.创建语法 CREATE PROC [ EDURE ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] [ FOR REPLICATION ] AS sql_statement [ ...n ] eg:无参数 create proc sayHelloasbeginprint'Hello ... 阅读全文
摘要:
一、触发器1.创建基本语句如下: create trigger trigger_name on {table_name | view_name} {for | After | Instead of } [ insert, update,delete ] as sql_statement eg:createtrigger TeacherInserton Teacherafter insertasif(select count(*) from Teacher,inserted where Teacher.TCode=inserted.TCode)>1beginprint'The Tc 阅读全文