摘要: 身份验证是验证客户端身份的行为。一般情况下,客户端必须提供某些证据,一般称为凭据,来证明其身份。通常,凭据包括用户名和密码对。Internet 信息服务 (IIS) 和 ASP.NET 都提供几种身份验证方案。IIS 提供多种身份验证方案: 匿名(默认情况下启用) 基本 摘要式 集成 Windows 身份验证(默认情况下启用) 客户证书映射 无论选择哪个方法,在验证客户端身份后,IIS 都... 阅读全文
posted @ 2006-05-30 13:50 Tim工作室 阅读(1003) 评论(0) 推荐(0) 编辑
摘要: A cursor is a mechanism by which you can assign a name to a "select statement" and manipulate the information within that SQL statement.Declare a Cursor OPEN Statement FETCH Statement CLOSE Statement ... 阅读全文
posted @ 2006-05-30 11:05 Tim工作室 阅读(171) 评论(0) 推荐(0) 编辑
摘要: The final step of working with cursors is to close the cursor once you have finished using it.The basic syntax to CLOSE the cursor is:CLOSE cursor_name;For example, you could close a cursor called c1 ... 阅读全文
posted @ 2006-05-30 10:50 Tim工作室 阅读(530) 评论(0) 推荐(0) 编辑
摘要: The purpose of using a cursor, in most cases, is to retrieve the rows from your cursor so that some type of operation can be performed on the data. After declaring and opening your cursor, the next st... 阅读全文
posted @ 2006-05-30 10:49 Tim工作室 阅读(628) 评论(0) 推荐(0) 编辑
摘要: Once you've declared your cursor, the next step is to open the cursor.The basic syntax to OPEN the cursor is:OPEN cursor_name;For example, you could open a cursor called c1 with the following command:... 阅读全文
posted @ 2006-05-30 10:47 Tim工作室 阅读(189) 评论(0) 推荐(0) 编辑
摘要: A cursor is a SELECT statement that is defined within the declaration section of your PLSQL code. We'll take a look at three different syntaxes for cursors.Cursor without parameters (simplest)The basi... 阅读全文
posted @ 2006-05-30 10:46 Tim工作室 阅读(1174) 评论(0) 推荐(0) 编辑
摘要: BEFORE INSERT Trigger A BEFORE INSERT Trigger means that Oracle will fire this trigger before the INSERT operation is executed.The syntax for an BEFORE INSERT Trigger is:CREATE or REPLACE TRIGGER trig... 阅读全文
posted @ 2006-05-30 10:13 Tim工作室 阅读(316) 评论(0) 推荐(0) 编辑
摘要: In Oracle, you can create your own procedures.The syntax for a procedure is:CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ]IS [declaration_section]BEGIN executable_s... 阅读全文
posted @ 2006-05-30 09:59 Tim工作室 阅读(232) 评论(0) 推荐(0) 编辑
摘要: In Oracle, you can create your own functions.The syntax for a function is:CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatypeIS | AS [declaration_se... 阅读全文
posted @ 2006-05-30 09:53 Tim工作室 阅读(234) 评论(0) 推荐(0) 编辑