上海网站建设 - 开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/专业的上海网站建设中心|上海网站制作|上海网站设计-----大海工作室 - RainbowSoft Studio Z-Blog 1.7 Laputa Build 70216zh-CN<META name="y_key" content="f238a0a5b34535a1" />Copyright 上海网站建设 <a href="http://www.miibeian.gov.cn" target="_blank">沪ICP备07037033号</a> Some Rights Reserved.<img src='http://ip.chinaz.com/ipshow.asp'><script type="text/javascript" src="http://js.tongji.yahoo.com.cn/0/35/500/ystat.js"></script><noscript><a href="http://js.tongji.yahoo.com.cn"><img src=http://js.tongji.yahoo.com.cn/0/35/500/ystat.gif></a></noscript>Sat, 11 Sep 2010 05:12:32 +0800actionscript按钮调用和清除影片剪辑shwebc@163.com (shwebc)http://www.shwebc.com/post/2007112105.htmlWed, 21 Nov 2007 14:42:12 +0800http://www.shwebc.com/post/2007112105.html
 attachMovie("btn3","trio_mc",1);
 trio_mc._x = 430.5;
 trio_mc._y = 460.5;
}
on (rollOut) {

 removeMovieClip("trio_mc");

} ]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007112105.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=532http://www.shwebc.com/cmd.asp?act=tb&id=532&key=0fc3cc07动感的伸缩菜单shwebc@163.com (shwebc)http://www.shwebc.com/post/2007112104.htmlWed, 21 Nov 2007 14:41:03 +0800http://www.shwebc.com/post/2007112104.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007112104.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=531http://www.shwebc.com/cmd.asp?act=tb&id=531&key=d08b1c48asp数据库连接语句shwebc@163.com (shwebc)http://www.shwebc.com/post/2007112103.htmlWed, 21 Nov 2007 14:40:02 +0800http://www.shwebc.com/post/2007112103.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007112103.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=530http://www.shwebc.com/cmd.asp?act=tb&id=530&key=50650953ASP的类型转换函数shwebc@163.com (shwebc)http://www.shwebc.com/post/2007112102.htmlWed, 21 Nov 2007 14:38:50 +0800http://www.shwebc.com/post/2007112102.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007112102.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=529http://www.shwebc.com/cmd.asp?act=tb&id=529&key=4aff0f4cWindow.Open详解shwebc@163.com (shwebc)http://www.shwebc.com/post/2007112101.htmlWed, 21 Nov 2007 14:38:17 +0800http://www.shwebc.com/post/2007112101.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007112101.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=528http://www.shwebc.com/cmd.asp?act=tb&id=528&key=7d287f8c国际网页Web设计流程（1）----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110106.htmlThu, 01 Nov 2007 21:32:36 +0800http://www.shwebc.com/post/2007110106.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110106.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=514http://www.shwebc.com/cmd.asp?act=tb&id=514&key=dcdc7b61怎样做网站规划-----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110105.htmlThu, 01 Nov 2007 21:31:26 +0800http://www.shwebc.com/post/2007110105.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110105.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=513http://www.shwebc.com/cmd.asp?act=tb&id=513&key=27ab1e57用CSS来控制网页背景-----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110104.htmlThu, 01 Nov 2007 21:30:21 +0800http://www.shwebc.com/post/2007110104.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110104.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=512http://www.shwebc.com/cmd.asp?act=tb&id=512&key=ee239f24网页设计的布局理念----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110103.htmlThu, 01 Nov 2007 21:29:20 +0800http://www.shwebc.com/post/2007110103.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110103.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=511http://www.shwebc.com/cmd.asp?act=tb&id=511&key=c524f0d5行业网站设计心得----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110102.htmlThu, 01 Nov 2007 21:28:15 +0800http://www.shwebc.com/post/2007110102.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110102.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=510http://www.shwebc.com/cmd.asp?act=tb&id=510&key=026137c1生成静态页面的方法（1）----上海网站建设shwebc@163.com (shwebc)http://www.shwebc.com/post/2007110101.htmlThu, 01 Nov 2007 21:26:50 +0800http://www.shwebc.com/post/2007110101.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/2007110101.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=509http://www.shwebc.com/cmd.asp?act=tb&id=509&key=86dd1292现数据库或对象为只读的解决方法shwebc@163.com (shwebc)http://www.shwebc.com/post/20071017016.htmlWed, 17 Oct 2007 22:05:33 +0800http://www.shwebc.com/post/20071017016.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/20071017016.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=464http://www.shwebc.com/cmd.asp?act=tb&id=464&key=f318a2a0生成静态页面的方法（1）shwebc@163.com (shwebc)http://www.shwebc.com/post/20071017015.htmlWed, 17 Oct 2007 22:04:36 +0800http://www.shwebc.com/post/20071017015.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/20071017015.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=463http://www.shwebc.com/cmd.asp?act=tb&id=463&key=bf61287aOracle数据库比SQLServer更存在缺陷shwebc@163.com (shwebc)http://www.shwebc.com/post/90.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/90.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/90.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=90http://www.shwebc.com/cmd.asp?act=tb&id=90&key=fb577013用OracleJDeveloper10.1.3构建Ajax应用程序shwebc@163.com (shwebc)http://www.shwebc.com/post/85.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/85.html关于 Ajax "Ajax" 表示异步 Javascript 和 XML，它是 "Web 2.0" 范型的核心。一种定义（Web 2.0 有多个定义）指出，Web 2.0 是可提高响应速率、提供丰富 UI 组件的新一代 Web 应用程序的简写，它使 Web 应用程序更贴近客户端-服务器桌面客户端的用户体验。Ajax 不是软件标准，而是对一组技术的描述，这些技术包括 JavaScript、文档对象模型 (DOM) 和浏览器 XmlHttpRequest 对象（IE 中为 XmlHttp 对象）。通过结合使用这些技术，用户可以构建基于浏览器的交互式用户界面。 ]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/85.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=85http://www.shwebc.com/cmd.asp?act=tb&id=85&key=b3c431d4如何删除oracle10g中的垃圾表?shwebc@163.com (shwebc)http://www.shwebc.com/post/86.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/86.html使用oracle10g的朋友可能会发现以前删除的表在数据库中出现了很多垃圾表，如：BINjR8PK5HhrrgMK8KmgQ9nw==之类的表无法删除无法用delete 删除,一般不影响正常使用，但是有以下情况使我们必须删除它 1,这些表占用空间2,如果使用Middlegen-Hibernate-r5的朋友会发现一些问题，不你象以前用oracle9时那么顺的生成hibernate配置文件,原因就在这里将它删除就没有问题了．3,其它情况 BINjR8PK5HhrrgMK8KmgQ9nw==之类的表这个是10g 的新特性。Drop Table 后，没有真正的删]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/86.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=86http://www.shwebc.com/cmd.asp?act=tb&id=86&key=0e84f6aboracle10g安装中一些问题解决shwebc@163.com (shwebc)http://www.shwebc.com/post/87.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/87.html 我在安装ORACLE 10g过程中遇到了两个主要问题：如何彻底删除旧版本和如何配制MS Loopback Adapter。现把解决办法贴出来，供大家参考。一，如何彻底删除旧版本的oracle  1，在cmd里运行DBCA，在这里删除oracle实例，有多少删多少；  2，在开始\程序中找到oracle子目录下的Universal Installer，运行以卸载oracle软件；  3，进入注册表，删除子项HKEY_LOCAL_MACHINE\SOFTWARE\Oracle;  4，重启计算机，物理删除Oracle的]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/87.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=87http://www.shwebc.com/cmd.asp?act=tb&id=87&key=cee5938eoracle存储过程的基本语法shwebc@163.com (shwebc)http://www.shwebc.com/post/88.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/88.html  1.基本结构 CREATE OR REPLACE PROCEDURE 存储过程名字(    参数1 IN NUMBER,    参数2 IN NUMBER) IS变量1 INTEGER :=0;变量2 DATE;BEGIN END 存储过程名字 2.SELECT INTO STATEMENT  将select查询的结果存入到变量中，可以同时将多个列存储多个变量中，必须有一条  记录，否则抛出异常(如果没有记录抛出NO_DATA_FOUND)  例子： &]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/88.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=88http://www.shwebc.com/cmd.asp?act=tb&id=88&key=d44f63ceoracle中的联合主键查询问题！shwebc@163.com (shwebc)http://www.shwebc.com/post/91.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/91.html1将重复的数据提取出来，然后进行人工比对，事实证明，有够笨的！     方法二：请教了一位资深人员，提供了一个更好的方法。就是将三]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/91.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=91http://www.shwebc.com/cmd.asp?act=tb&id=91&key=19c10885Oracle10g第2版新特性之SQL和PL/SQLshwebc@163.com (shwebc)http://www.shwebc.com/post/93.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/93.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/93.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=93http://www.shwebc.com/cmd.asp?act=tb&id=93&key=1516ae37Oracle10g第2版新特性之可管理性特性shwebc@163.com (shwebc)http://www.shwebc.com/post/94.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/94.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/94.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=94http://www.shwebc.com/cmd.asp?act=tb&id=94&key=eecb81ecOracle10g新特性之虚拟专用数据库shwebc@163.com (shwebc)http://www.shwebc.com/post/95.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/95.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/95.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=95http://www.shwebc.com/cmd.asp?act=tb&id=95&key=af19ec91Oracle中的数据字典技术初级入门shwebc@163.com (shwebc)http://www.shwebc.com/post/96.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/96.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/96.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=96http://www.shwebc.com/cmd.asp?act=tb&id=96&key=5f15a606Oracle的入门心得(1)shwebc@163.com (shwebc)http://www.shwebc.com/post/97.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/97.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/97.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=97http://www.shwebc.com/cmd.asp?act=tb&id=97&key=2dc1c6e5Oracle入门心得(2)shwebc@163.com (shwebc)http://www.shwebc.com/post/98.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/98.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/98.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=98http://www.shwebc.com/cmd.asp?act=tb&id=98&key=74915494Oracle10g第2版新特性之性能特性shwebc@163.com (shwebc)http://www.shwebc.com/post/92.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/92.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/92.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=92http://www.shwebc.com/cmd.asp?act=tb&id=92&key=8302c0e7超级PK:Sybase与Oracle的十二场性能比拼shwebc@163.com (shwebc)http://www.shwebc.com/post/89.htmlSun, 02 Sep 2007 22:12:01 +0800http://www.shwebc.com/post/89.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/89.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=89http://www.shwebc.com/cmd.asp?act=tb&id=89&key=aa200a24Oracle数据库如何查询记录时给记录加锁shwebc@163.com (shwebc)http://www.shwebc.com/post/82.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/82.html本文通过一个具体的实例来解决Oracle数据库如休在查询记录时给记录加锁呢？ 系统环境 1、操作系统：Windows 2000 。 2、数据库：　Oracle 8i R2 (8.1.6) for NT 企业版。 3、安装路径：C:\Oracle。 实现方法 利用SELECT的FOR UPDATE子句实现: conn system/manager--创建实验用户grant connect,resource to test identified by test;conn test/test--创建实验表1create table a(]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/82.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=82http://www.shwebc.com/cmd.asp?act=tb&id=82&key=86e996cc从Oracle的FORM中调用REPORT的实用技巧shwebc@163.com (shwebc)http://www.shwebc.com/post/77.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/77.html问：从Oracle的FORM中调用REPORT有什么常用的技巧？ 答：具体方法如下; 在菜单中调用REPORT程序（不传参数，传参数可用下面的程序段） Run_Product(REPORTS, '报表程序名.REP', SYNCHRONOUS, RUNTIME, FILESYSTEM, '', NULL);在FORM中调用REPORT程序（可传参数）DECLARE       pl_id ParamList;BEGIN       ]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/77.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=77http://www.shwebc.com/cmd.asp?act=tb&id=77&key=26aab1d9分享Oracle9i中建立自增字段的最新办法shwebc@163.com (shwebc)http://www.shwebc.com/post/78.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/78.html很多人都知道在Oracle中并没有像其他数据库中的自增字段，那么我们怎样才能实现Oracle的自增字段功能呢？下面我们通过Oracle中的Sequence和Trigger来实现此功能。 1、首先建立一个创建自增字段的存储过程 //Written by Sun Zhenfang 20040903create or replace procedure pr_CreateIdentityColumn(tablename varchar2,columnname varchar2)asstrsql varchar2(1000);begin  &n]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/78.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=78http://www.shwebc.com/cmd.asp?act=tb&id=78&key=4cbcab08在Oracle中使用登录触发器初始化用户会话shwebc@163.com (shwebc)http://www.shwebc.com/post/79.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/79.html你可能了解以前的USERENV函数，它返回会话值，如用户会话ID、语言、以及用户是否拥有数据库管理员权限。虽然由于遗留原因，USERENV函数仍在使用，但在Oracle 8i中，它已被一个新的函数所替代——SYS_CONTEXT。 　SYS_CONTEXT不仅能够返回USERENV数据——它还能返回应用程序定义的数据值。应用程序上下文包括一组可以被SYS_CONTEXT返回的名称（属性）和匹配数据（值）。例如，如果一个人事应用要返回用户的部门号，可以在应用程序中加入下面这行代码： v_dept := SYS_CONTEXT('HR_CONTEXT']]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/79.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=79http://www.shwebc.com/cmd.asp?act=tb&id=79&key=464ccdbe两种方法分析每月工作日计算程序shwebc@163.com (shwebc)http://www.shwebc.com/post/81.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/81.htmlSQL> SELECT TEXT FROM USER_SOURCE WHERE TYPE='PROCEDURE' AND NAME='GZR';　　　　TEXT　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　----------------------------------------------------------------------------------------------------　　procedure gzr(v_nowdate in varchar2) as　　　　　　　　　　]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/81.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=81http://www.shwebc.com/cmd.asp?act=tb&id=81&key=a486352f理解物化视图刷新过程中出现的约束冲突shwebc@163.com (shwebc)http://www.shwebc.com/post/83.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/83.html本文通过实例的方法来帮助您理解物化视图刷新过程中出现的约束冲突问题。 即使将物化视图的约束建立和基表完全一致，由于物化视图的刷新机制，也会产生约束冲突的现象。 一个简单的例子： SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30));--表已创建SQL> ALTER TABLE T ADD CONSTRAINT UN_T_NAME UNIQUE (NAME);--表已更改SQL> CREATE MATERIALIZED VIEW LOG ON T;--实体化视图日志已创建]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/83.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=83http://www.shwebc.com/cmd.asp?act=tb&id=83&key=b88ffe2b用Oracle10g列值掩码技术隐藏敏感数据shwebc@163.com (shwebc)http://www.shwebc.com/post/84.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/84.htmlOracle的虚拟私有数据库特性（也称作细颗粒度存取控制）对诸如SELECT等数据管理语言DML语句提供行级安全性检查。PL/SQL策略函数和某个数据表相关联，这个函数可以检查当前用户的上下文背景并添加查询中WHERE语句的条件（断言），一个用户或者应用可以这样来写： SELECT * FROM employees;但是实际上oracle将会执行这样的语句：SELECT * FROM employees WHERE department_id = 60; 因此，只有在查寻范围之内的行（在department数据表中的前60]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/84.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=84http://www.shwebc.com/cmd.asp?act=tb&id=84&key=d4d9db7a如何避免Oracle数据库密码出现@符号shwebc@163.com (shwebc)http://www.shwebc.com/post/80.htmlSun, 02 Sep 2007 22:12:00 +0800http://www.shwebc.com/post/80.html密码复杂性是IT审计人员检查一个系统是否安全的一个重要方面。IT策略中经常指出密码应该有最小的长度且应该包含大写字母、小字字母、数字和特殊字符的混合。 　Oracle中应该避免将特殊字符@用于密码中，因为在Oracle中，@符号用来表明使用哪一台Oracle服务器。SQL *Plus连接语句的完整格式如下： CONNECT username/password@alias 　其中alias是一个Oracle Net别名，代表一个服务器、断口和实例名。 　列表A显示了在密码中使用了@字符时，产生的错误：ORA-12154，“TNS：不能解析指定的连接标识符。”]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/80.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=80http://www.shwebc.com/cmd.asp?act=tb&id=80&key=c0ed2872SQLServer连接失败错误分析与排除shwebc@163.com (shwebc)http://www.shwebc.com/post/76.htmlSun, 02 Sep 2007 21:08:07 +0800http://www.shwebc.com/post/76.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/76.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=76http://www.shwebc.com/cmd.asp?act=tb&id=76&key=72a9cc8bsql查询like操作数剖析shwebc@163.com (shwebc)http://www.shwebc.com/post/70.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/70.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/70.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=70http://www.shwebc.com/cmd.asp?act=tb&id=70&key=c16eb2faSql语句：显示SqlServer中所有表中的信息shwebc@163.com (shwebc)http://www.shwebc.com/post/64.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/64.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/64.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=64http://www.shwebc.com/cmd.asp?act=tb&id=64&key=5909433f深入浅出SQL教程之SELECT语句的自连接shwebc@163.com (shwebc)http://www.shwebc.com/post/65.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/65.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/65.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=65http://www.shwebc.com/cmd.asp?act=tb&id=65&key=5aed2c1dSQL基础：Sql小结shwebc@163.com (shwebc)http://www.shwebc.com/post/66.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/66.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/66.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=66http://www.shwebc.com/cmd.asp?act=tb&id=66&key=28643eac深入浅出SQL之左连接、右连接和全连接shwebc@163.com (shwebc)http://www.shwebc.com/post/67.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/67.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/67.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=67http://www.shwebc.com/cmd.asp?act=tb&id=67&key=6876d0f7深入浅出SQL教程之SELECT语句中的表连接shwebc@163.com (shwebc)http://www.shwebc.com/post/69.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/69.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/69.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=69http://www.shwebc.com/cmd.asp?act=tb&id=69&key=ceaebcb2深入浅出SQL教程之Groupby和Havingshwebc@163.com (shwebc)http://www.shwebc.com/post/71.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/71.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/71.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=71http://www.shwebc.com/cmd.asp?act=tb&id=71&key=58f2e1cc深入浅出SQL系列教程之基本SELECT命令shwebc@163.com (shwebc)http://www.shwebc.com/post/72.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/72.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/72.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=72http://www.shwebc.com/cmd.asp?act=tb&id=72&key=efcf8eb4深入浅出SQL系列教程之SQL语言简介shwebc@163.com (shwebc)http://www.shwebc.com/post/73.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/73.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/73.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=73http://www.shwebc.com/cmd.asp?act=tb&id=73&key=bb497814SQL分页语句shwebc@163.com (shwebc)http://www.shwebc.com/post/74.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/74.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/74.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=74http://www.shwebc.com/cmd.asp?act=tb&id=74&key=787fe556SQLServer连接失败错误故障的分析与排除shwebc@163.com (shwebc)http://www.shwebc.com/post/75.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/75.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/75.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=75http://www.shwebc.com/cmd.asp?act=tb&id=75&key=23d9bb46SQLServer与Oracle的不同点(从微观上)shwebc@163.com (shwebc)http://www.shwebc.com/post/68.htmlSun, 02 Sep 2007 21:08:06 +0800http://www.shwebc.com/post/68.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/68.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=68http://www.shwebc.com/cmd.asp?act=tb&id=68&key=61e2f16csqlserver日期时间函数shwebc@163.com (shwebc)http://www.shwebc.com/post/59.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/59.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/59.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=59http://www.shwebc.com/cmd.asp?act=tb&id=59&key=593b20cdSQL优化34条shwebc@163.com (shwebc)http://www.shwebc.com/post/56.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/56.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/56.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=56http://www.shwebc.com/cmd.asp?act=tb&id=56&key=5b15ac8eSQLSERVER的ROWCOUNT关键字shwebc@163.com (shwebc)http://www.shwebc.com/post/58.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/58.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/58.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=58http://www.shwebc.com/cmd.asp?act=tb&id=58&key=d9c03f8aSQLServer的有效安装shwebc@163.com (shwebc)http://www.shwebc.com/post/60.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/60.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/60.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=60http://www.shwebc.com/cmd.asp?act=tb&id=60&key=33d85b2eSQLServer各种日期计算方法shwebc@163.com (shwebc)http://www.shwebc.com/post/61.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/61.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/61.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=61http://www.shwebc.com/cmd.asp?act=tb&id=61&key=6f2aae48sql经典语句shwebc@163.com (shwebc)http://www.shwebc.com/post/62.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/62.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/62.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=62http://www.shwebc.com/cmd.asp?act=tb&id=62&key=28962521得到内网可用的SqlServer及某数据库下的表及其他的架构shwebc@163.com (shwebc)http://www.shwebc.com/post/63.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/63.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/63.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=63http://www.shwebc.com/cmd.asp?act=tb&id=63&key=e780cc9esql语句查询结果合并unionall用法shwebc@163.com (shwebc)http://www.shwebc.com/post/57.htmlSun, 02 Sep 2007 21:08:05 +0800http://www.shwebc.com/post/57.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/57.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=57http://www.shwebc.com/cmd.asp?act=tb&id=57&key=1bfe431eSQLServer中索引使用及维护shwebc@163.com (shwebc)http://www.shwebc.com/post/49.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/49.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/49.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=49http://www.shwebc.com/cmd.asp?act=tb&id=49&key=e07b99b9SQLServerCompactEdition程序建立步骤shwebc@163.com (shwebc)http://www.shwebc.com/post/40.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/40.html <P>SQL Server 2005 任务<BR>在创建应用程序之前，必须在 SQL Server 2005 中配置发布。在下列步骤中，您将创建一个示例<U><FONT color=#0000ff>数据库</FONT></U>，然后从该数据库发布数据。您将使用预建的脚本文件创建数据库，然后使用新建发布向导来创建发布。<B]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/40.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=40http://www.shwebc.com/cmd.asp?act=tb&id=40&key=0d07244eSQLSERVERUPDATE的赋值次序shwebc@163.com (shwebc)http://www.shwebc.com/post/41.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/41.html <P>1) 先变量再字段</P>
<P>SET NOCOUNT ON;</P>
<P>DECLARE @i INT, @j INT<BR>DECLARE @Table TABLE<BR>(<BR> Id1 INT,<BR> Id2 INT<BR>]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/41.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=41http://www.shwebc.com/cmd.asp?act=tb&id=41&key=0b6216cbsqlserver2005(Express版）的配置shwebc@163.com (shwebc)http://www.shwebc.com/post/42.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/42.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/42.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=42http://www.shwebc.com/cmd.asp?act=tb&id=42&key=51099d9fSQLServer实现分页的方式shwebc@163.com (shwebc)http://www.shwebc.com/post/43.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/43.html <P>2000:</P>
<P>  首先获得所有的记录集合的存储过程:</P>
<P>create   PROCEDURE [dbo].[P_GetOrderNumber]<BR>AS<BR> select count(orderid) from orders]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/43.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=43http://www.shwebc.com/cmd.asp?act=tb&id=43&key=66babbcaSQLSERVER2000安装shwebc@163.com (shwebc)http://www.shwebc.com/post/44.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/44.html <P>症状1：安装时候提示程序挂起。<BR>解决方案1：（验证有效）<BR>                      开始\运行\输入reg]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/44.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=44http://www.shwebc.com/cmd.asp?act=tb&id=44&key=931a0f06SQLServer存储过程嵌套示例shwebc@163.com (shwebc)http://www.shwebc.com/post/45.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/45.html <DIV style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt"><SPAN>1)<SPAN style="FONT: 7pt 'Times New Roman'; font-size-adjust: none; font-stretch: normal"> &]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/45.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=45http://www.shwebc.com/cmd.asp?act=tb&id=45&key=c05f2507精通数据库系列之入门-技巧篇1shwebc@163.com (shwebc)http://www.shwebc.com/post/39.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/39.html <P>　　我们将实现对一个数据表单的添加、修改、删除以及对表中数据进行查询的功能。本例所使用的计算机软硬件环境为：Windows NT 4.0 Server，MS-SQL Server7.0，Borland Delphi]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/39.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=39http://www.shwebc.com/cmd.asp?act=tb&id=39&key=d3cc7c8a动态创建MSSQL数据库表存储过程shwebc@163.com (shwebc)http://www.shwebc.com/post/46.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/46.html <P align=left></P>
<TABLE style="BORDER-RIGHT: rgb(204,204,204) 1px dotted; TABLE-LAYOUT: fixed; BORDER-TOP: rgb(204,204,204]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/46.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=46http://www.shwebc.com/cmd.asp?act=tb&id=46&key=1d81add2sqlserver带列名导出至excelshwebc@163.com (shwebc)http://www.shwebc.com/post/50.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/50.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/50.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=50http://www.shwebc.com/cmd.asp?act=tb&id=50&key=7b7d71d8SQLSERVER2005EXPRESS不能远程连接的问题shwebc@163.com (shwebc)http://www.shwebc.com/post/51.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/51.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/51.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=51http://www.shwebc.com/cmd.asp?act=tb&id=51&key=013cb2e1sqlserver中orderby部分使用方式shwebc@163.com (shwebc)http://www.shwebc.com/post/52.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/52.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/52.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=52http://www.shwebc.com/cmd.asp?act=tb&id=52&key=94a52f59Sqlserver如何得到汉字的声母shwebc@163.com (shwebc)http://www.shwebc.com/post/53.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/53.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/53.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=53http://www.shwebc.com/cmd.asp?act=tb&id=53&key=128cbc2aWindowsVista下安装SQLServer2005shwebc@163.com (shwebc)http://www.shwebc.com/post/54.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/54.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/54.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=54http://www.shwebc.com/cmd.asp?act=tb&id=54&key=463f5159MS-SQL中多个表或结果集的组合的方法shwebc@163.com (shwebc)http://www.shwebc.com/post/55.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/55.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/55.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=55http://www.shwebc.com/cmd.asp?act=tb&id=55&key=8cd343c0SQLServer2000数据库分离与附加shwebc@163.com (shwebc)http://www.shwebc.com/post/48.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/48.html <tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/48.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=48http://www.shwebc.com/cmd.asp?act=tb&id=48&key=ae43d02b快速清除SQLServer日志的两种方法shwebc@163.com (shwebc)http://www.shwebc.com/post/47.htmlSun, 02 Sep 2007 21:08:04 +0800http://www.shwebc.com/post/47.html <P>　　第一种方法：清空日志。</P>
<P>　　1.打开查询分析器，输入命令</P>
<P></P>
<TABLE style="BORDER-RIGHT: rgb(204,204,204) 1px dotted; TABLE-LA]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/47.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=47http://www.shwebc.com/cmd.asp?act=tb&id=47&key=620aea84精通数据库系列之入门-技巧篇5shwebc@163.com (shwebc)http://www.shwebc.com/post/37.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/37.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/37.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=37http://www.shwebc.com/cmd.asp?act=tb&id=37&key=de50852csql2000卸载了后重新安装时不能安装的解决办法shwebc@163.com (shwebc)http://www.shwebc.com/post/28.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/28.html <P>C:Program FilesMicrosoft SQL Server80Tools。 <BR>C:Program FilesMicrosoft SQL ServerMSSQL。  </P>
<P>2、注册表中的相关信息删除： &l]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/28.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=28http://www.shwebc.com/cmd.asp?act=tb&id=28&key=8fe59c77学习SQLSERVER的存储过程-之一认识存储过程语法shwebc@163.com (shwebc)http://www.shwebc.com/post/29.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/29.html <P>CREATE PROCEDURE<BR>创建存储过程，存储过程是保存起来的可以接受和返回用户提供的参数的 Transact-SQL 语句的集合。可以创建一个过程供永久使用，或在一个会话中临时使用（局部临时过程），或在所有会话中临时使用（全局临时过程）。也可以创建在 Microsoft SQL ]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/29.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=29http://www.shwebc.com/cmd.asp?act=tb&id=29&key=35aea700用MSSQLReportingServices生成报表shwebc@163.com (shwebc)http://www.shwebc.com/post/30.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/30.html <P>　　Reporti]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/30.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=30http://www.shwebc.com/cmd.asp?act=tb&id=30&key=8834faeaMSSQLServer的事务日志简介一览shwebc@163.com (shwebc)http://www.shwebc.com/post/31.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/31.html <P>　　交易日志是针对数据库改变所做的记录，它可以记录针对数据库的任何操作，并将记录结果保存在独立的文件中。对于任何每一个交易过程，交易日志都有非常全面的记录，根据这些记录可以将数据文件恢复成交易前的状态。从交易动作开始，交易日志就处于记录状态，交易过程中对数据库的任何操作都在]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/31.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=31http://www.shwebc.com/cmd.asp?act=tb&id=31&key=ff1bffb5MSSQL数据库日志的压缩与清除技巧shwebc@163.com (shwebc)http://www.shwebc.com/post/32.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/32.html <P>　　1、设置数据库模式为简单模式：打开SQL企业管理器，在控制台根目录中依次点开Microsoft SQL Server-->SQL Server组-->双击打开你的服务器-->双击打开数据库目录-->选择你的数据库名称（如论坛数据库Forum）-->然后点击右键选择属]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/32.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=32http://www.shwebc.com/cmd.asp?act=tb&id=32&key=99746783SQLSERVER中易混淆的数据类型shwebc@163.com (shwebc)http://www.shwebc.com/post/33.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/33.html <P>数据类弄是数据的一种属性，表示数据所表示信息的类型。任何一种计算机语言都定义了自己的数据类型。当然，不同的程序语言都具有不同的特点，所定义的数据类型的各类和名称都或多或少有些不同。SQLServer 提供了 25 种数据类型： <BR>　　·Binary [(n)] <BR>　　·Varbinary [(n)] <BR>　　·Char [(n)]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/33.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=33http://www.shwebc.com/cmd.asp?act=tb&id=33&key=062e2b46Sqlserver提示挂起问题shwebc@163.com (shwebc)http://www.shwebc.com/post/34.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/34.html <P>安装sqlserver时候，提示挂起的解决方案：</P>
<P>1. 在系统盘中打开注册表  <BR>2. 在HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager</P>
<P>   删除Pending]]>开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/34.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=34http://www.shwebc.com/cmd.asp?act=tb&id=34&key=a9c2f339精通数据库系列之入门-技巧篇2shwebc@163.com (shwebc)http://www.shwebc.com/post/36.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/36.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/36.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=36http://www.shwebc.com/cmd.asp?act=tb&id=36&key=60611dc6精通数据库系列之入门-技巧篇3shwebc@163.com (shwebc)http://www.shwebc.com/post/38.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/38.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/38.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=38http://www.shwebc.com/cmd.asp?act=tb&id=38&key=e0fe89baSQLServer2005CE软件环境需求shwebc@163.com (shwebc)http://www.shwebc.com/post/27.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/27.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/27.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=27http://www.shwebc.com/cmd.asp?act=tb&id=27&key=00bccf05精通数据库系列之入门-技巧篇4shwebc@163.com (shwebc)http://www.shwebc.com/post/35.htmlSun, 02 Sep 2007 21:08:03 +0800http://www.shwebc.com/post/35.html开发专区[sql] [Asp] [Jsp]http://www.shwebc.com/post/35.html#commenthttp://www.shwebc.com/http://www.shwebc.com/sydication.asp?cmt=35http://www.shwebc.com/cmd.asp?act=tb&id=35&key=82848d22