摘要：
string cc="aaaa";switch(cc){ case "aaaa ": response.write("OK");break;}小心空格。。。。不要相信 是系统的问题。。。。。。。。 阅读全文
摘要：
var obj = document.getElementById('TcElement_BDB_WinbidInstance'); //selectid var index = obj.selectedIndex; // 选中索引 //var text = obj.options[index].text; // 选中文本 var value = obj.options[index].value; // 选中值 alert(value); } </script> </head><body> <form id="form1&qu 阅读全文
摘要：
Create Table TEST(DATES Varchar(6),EMPNO Varchar(5),STYPE Varchar(1),AMOUNT Int)Insert TEST Select '200605', '02436', 'A', 5Union All Select '200605', '02436', 'B', 3Union All Select '200605', '02436', 'C', 3 Union All Select &# 阅读全文
摘要：
create table #1( a int, b varchar(10))insert into #1 values(1,'aa')insert into #1 select 1,'1a' union allselect 2,'1b' union allselect 3,'1c' goselect * from #1declare @str varchar(8000)declare @bb varchar(20)select @str= isnull(@str+',','')+bfrom #1 s 阅读全文
摘要：
Create Table TEST(DATES Varchar(6),EMPNO Varchar(5),STYPE Varchar(1),AMOUNT Int)Insert TEST Select '200605', '02436', 'A', 5Union All Select '200605', '02436', 'B', 3Union All Select '200605', '02436', 'C', 3 Union All Select &# 阅读全文
摘要：
需要新建一个数据库第一步：创建表空间 [注意路径正确]create tablespace OASEHYYJdatafile 'E:\oracle\product\10.2.0\oradata\orcl\OASEHYYJ.dbf' size 500Mautoextend on ---开启自动扩展表空间next 100M maxsize unlimited logging --- 每次100m 无最大限制extent management local autoallocatesegment space management auto;第二步： 创建用户CREATE USER ksx 阅读全文
摘要：
var starttime =document.getElementById('TcElement_BDB_CheckupDate').value; var endtime =document.getElementById('TcElement_BDB_EndBuyDate').value; var starttimes = starttime.split('-');var endtimes = endtime.split('-');var starttimeTemp = starttimes[0] + '/' + 阅读全文
摘要：
select name from sysobjects where xtype='TR' --所有触发器 select name from sysobjects where xtype='P' --所有存储过程 select name from sysobjects where xtype='V' --所有视图 select name from sysobjects where xtype='U' --所有表 以上为SqlServer用法 Select object_name From user_objects Where obj 阅读全文
摘要：
ALTER proc [dbo].[RoleUser](@RoleID varchar(20),@UserID varchar(20))asdeclare @count intset @count=(select count(PTU_Sub) from PT_Role where PTR_ID=@RoleID)declare @Sub varchar(200)set @Sub=(select PTU_Sub from PT_Role where PTR_ID=@RoleID)declare @newSub varchar(200)set @newSub=(@Sub+','+@U 阅读全文
摘要：
create function fenge(@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(a varchar(100))as begindeclare @i intset @SourceSql=rtrim(ltrim(@SourceSql))set @i=charindex(@StrSeprate,@SourceSql)while @i>=1begin insert @temp values(left(@SourceSql,@i-1)) set @SourceSql=substring(@Sour 阅读全文