小虫乱爬--爬爬也论技术 博客

 sql: not in和联接(left join)查询的比较 not in:select dn,ds from (select dn,dsfrom test where deleted=0and upper(dt)=LOAN) as a where dnnot in(select ld from test2 where deleted=0)联接(left join):se

function get_irc_pn(p_irc in pnrreg.irc%type, p_partid in pnrreg.partid%type) return varchar2 is o_irc_pn varchar2(200); -- p_pnrreg pnrreg%rowtype;

ALTER FUNCTION dbo.getsearchname(@partnumber varchar(30))RETURNS varchar(8000)ASBEGINdeclare @ret varchar(8000)select @ret= '' declare cur_res cursor for select DISTINCT A_search

DECLARE C_pro CURSOR FOR --此处 select 物料号及8个字段的集合表--SELECT au_id, au_fname, au_lname--FROM authors--WHERE state = "UT"--ORDER BY au_id---------------------------------OPEN authors_cur

Oracle imp、exp命令详解

Oracle Trigger实例

Oracle trigger中 动态创建表 创建序列 创建触发器

Oracle Function 自定义函数建立实例

很多资料中，对于事务的处理都很简单，抓捕SQL错误，仅仅是一个 @@error_count 吗？ 肯定不是。@@error_count 只记录上一次SQL操作的结果，对于存储过程中多条语句肯定是不行的。那么，怎么才能保证在存储过程中正确的回滚呢？让我们先来看个例子：view plaincopy to clipboardprint?CREATE TABLE `test` (`id` int(

 try        {            string _conStr = "Driver={MySQL ODBC 3.51 Driver};server=localhost;database=test;uid=test;password=1;option=3";            OdbcConnection _odbcCon = new OdbcConnection(_conS

mysql  各种级联查询后更新（update select）.CREATE TABLE `tb1` (  `id` int(11) NOT NULL,  `A` varchar(100) default NULL,  `B` varchar(100) default NULL,  `C` varchar(20) default NULL,  PRIMARY KEY  (`id`),  KEY

mysql 编写存储过程实例CREATE PROCEDURE `test`(out return_val int) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT begin DECLARE a,b,c,d char(100); DECLARE cur_1 CURSOR for

mysql 连接 asp.net Odbc连接 首先必须安装驱动(MySQL Connector ODBC 5.1.5 win32 msi.zip)mysql5.0数据库(mysql-5.0.18-win32.exe)以上都安装成功后:测试代码:using System.Data.Odbc;//odbcprotected void Page

sql exists和in两种写法 select * from f where exists(select FID from s where s.FID=f.IDD) select * from f where IDD in (select FID from s)  select * from f where IDD >any(select FID from s)--大

CREATE TABLE `f` ( --父表 `ID` int(11) NOT NULL auto_increment, `FDes` varchar(20) default NULL, `deleted` int(11) default NULL, `IDD` varchar(20) default NULL, --对应的外键 PRIMARY KEY

mysql创建功能函数格式化时间CREATE FUNCTION `Format_StrToDateTIme`( _in_date_str VARCHAR ( 50 )) RETURNS datetime NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT begindeclare _return_da

 实例: select TO_DAYS(str_to_date(12/1/2001 12:00:00 AM,%m/%d/%Y)) -TO_DAYS(str_to_date(11/28/2001 12:00:00 AM,%m/%d/%Y))  as a from table1

实例1: select if (str_to_date(column1, %m/%d/%Y %r) is null,if (str_to_date(column1, %Y-%m-%d) is null,str_to_date(column1,%c/%e/%Y %T), str_to_date(column1, %Y-%m-%d)),str_to_date(column1,

Create PROC [dbo].[sp_Test1]( @Number VarChar(10), @Result Int OutPut) Asset nocount onBEGIN---定义变量------------------------------------------------ Declare @Sum Int-------------