<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/liangCK</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; liangCK]]></copyright><item><title><![CDATA[SSSI导EXCEL数据常见问题一]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/4555540</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/4555540</guid><author>liangCK</author><pubDate>Tue, 15 Sep 2009 17:10:00 +0800</pubDate><description><![CDATA[在使用SQL SERVER将EXCEL导入到数据库中的时候.经常会发生一些问题.会让我们有些感觉到莫名其妙.今天在论坛上.一个朋友在使用SSIS将EXCEL导入到SQL SERVER的数据库内的时候.发生了这个错误:Excel 源 [1]] 错误: 输出“Excel 源输出”(9) 上的输出列“Description 3”(546) 出错。返回的列状态是:“文本被截断，或者一个或多个字符在]]></description><category></category></item><item><title><![CDATA[非聚集索引与ORDER BY排序的问题]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/4543043</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/4543043</guid><author>liangCK</author><pubDate>Fri, 11 Sep 2009 15:22:00 +0800</pubDate><description><![CDATA[ 写写如果SELECT列表中,使用*和不使用*的索引使用情况，如果错了，希望各位改正。例子以Northwind.dbo.Orders表为例，因为对这个表比较熟悉。先创建出示例数据库：CREATE DATABASE Test;GOUSE TestGO--将Northwind.dbo.Orders表的数据导到我们的测试数据库当中.SELECT * INTO dbo.Orders FROM Northw]]></description><category></category></item><item><title><![CDATA[SQL 2005 + CLR 压缩文件夹]]></title><link>https://blog.youkuaiyun.com/liangck/article/details/4343782</link><guid>https://blog.youkuaiyun.com/liangck/article/details/4343782</guid><author>liangck</author><pubDate>Mon, 13 Jul 2009 11:23:00 +0800</pubDate><description><![CDATA[//新建一个数据库项目,并新建一个类.Compress.cs文件内容如下:using System;using System.IO;using System.IO.Compression;using System.Text;using System.Collections; namespace CompressProject{    public class]]></description><category></category></item><item><title><![CDATA[每N条记录一个Worksheet,导出同一个Workbook中]]></title><link>https://blog.youkuaiyun.com/liangck/article/details/4274390</link><guid>https://blog.youkuaiyun.com/liangck/article/details/4274390</guid><author>liangck</author><pubDate>Tue, 16 Jun 2009 20:09:00 +0800</pubDate><description><![CDATA[ /*Author      : 梁嘉辉Date        : 2009-06-15Function    : 分Sheet导出同一Excel工作薄Comment     : 使用或转载请保留此信息*/ ---------------------------------------------------------------------创建存储过程-]]></description><category></category></item><item><title><![CDATA[SQL SERVER连接MySQL]]></title><link>https://blog.youkuaiyun.com/liangck/article/details/4258921</link><guid>https://blog.youkuaiyun.com/liangck/article/details/4258921</guid><author>liangck</author><pubDate>Wed, 10 Jun 2009 21:41:00 +0800</pubDate><description><![CDATA[-- MySQL mysql> create table tb(id int,data varchar(20),            chs_data varchar(50) character set gbk) character set latin1;Query OK, 0 rows affected (0.09 sec) mysql> insert into]]></description><category></category></item><item><title><![CDATA[导出数据库的视图,函数,存储过程以前触发器]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/4092430</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/4092430</guid><author>liangCK</author><pubDate>Sun, 19 Apr 2009 18:57:00 +0800</pubDate><description><![CDATA[CREATE PROC dbo.usp_OutObjects    @dbname sysname,    @Path NVARCHAR(1024)ASBEGIN    DECLARE         @viewPath NVARCHAR(1024),        @functionPath NVARCHAR(1024),        @procedurePat]]></description><category></category></item><item><title><![CDATA[重写ISNUMERIC函数]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3959641</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3959641</guid><author>liangCK</author><pubDate>Thu, 05 Mar 2009 14:07:00 +0800</pubDate><description><![CDATA[declare @test table(strings varchar(50)) Insert into @test Select 12d3 union all Select 87234.45 union all Select $123,456.00 union all Select   12   union all Select c]]></description><category></category></item><item><title><![CDATA[字符串中数据的运算和统计]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3918261</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3918261</guid><author>liangCK</author><pubDate>Sat, 21 Feb 2009 18:11:00 +0800</pubDate><description><![CDATA[问题:数据表如下 cate            values                                  dates A1           12.32,15.6,14.5,45.00,78.12,23.45         2006-04-01 A2           14.56,67.23,45.12,23.1,34.67,56.98      ]]></description><category></category></item><item><title><![CDATA[树形结构分析汇总]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3901949</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3901949</guid><author>liangCK</author><pubDate>Tue, 17 Feb 2009 19:13:00 +0800</pubDate><description><![CDATA[t1id     parentidm    an    ae    mf    mx    fy    fz    b t2row    id      amount1    a    13.002    b    20.003    e    20.004    f    20.005    x    20.006    y  ]]></description><category></category></item><item><title><![CDATA[关于一个分级汇总 ]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3901644</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3901644</guid><author>liangCK</author><pubDate>Tue, 17 Feb 2009 17:42:00 +0800</pubDate><description><![CDATA[关于一个分级汇总的问题.. 有多少级是不确定的, ID  PID    Name 1    null    A 2   1       B 3    1      C 4   3       D 5   4       E : :  : 要求结果为: ID  Name1 Name2 Name3 Name4 .... 1    A 2    A        B 3    A        C 4 ]]></description><category></category></item><item><title><![CDATA[SQL Server 2005分区表——分区切换]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3733670</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3733670</guid><author>liangCK</author><pubDate>Thu, 08 Jan 2009 12:37:00 +0800</pubDate><description><![CDATA[本文演示了SQL Server 2005 分区表分区切换的三种形式：1. 切换分区表的一个分区到普通数据表中：Partition to Table；2. 切换普通表数据到分区表的一个分区中：Table to Partition；3. 切换分区表的分区到另一分区表：Partition to Partition。并指出了在分区表分区切换过程中的注意事项。 -- 创建分区函数create p]]></description><category></category></item><item><title><![CDATA[sql 返回xml问题]]></title><link>https://blog.youkuaiyun.com/liangck/article/details/3694890</link><guid>https://blog.youkuaiyun.com/liangck/article/details/3694890</guid><author>liangck</author><pubDate>Sat, 03 Jan 2009 18:23:00 +0800</pubDate><description><![CDATA[问题描述: 有一表tbl 如下： col1 col2                col4 ---- -------------------- ---------------------- a    1,2,3,4,5            .net,c#,delph,java,c++ b    4,6                  java,J# 我要查询全部返回xml 结果集：]]></description><category></category></item><item><title><![CDATA[SSIS压缩文件并以邮件附件发送]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3492303</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3492303</guid><author>liangCK</author><pubDate>Wed, 10 Dec 2008 19:16:00 +0800</pubDate><description><![CDATA[PS: 1.由于本文使用了msdb..sp_send_dbmail发送邮件.所以应先对数据库邮件进行配置.   2.在压缩文件时,使用了7-Zip进行压缩,所以请到http://www.7-zip.org/下载该压缩工具,由于该压缩工具基于 GNU LGPL 许可协议,所以可自由使用.下载完.安装到E:/7-Zip/ 由于本文使用的是这个路径,所以可以自行设置路径.并在以下使用到7z.exe时]]></description><category></category></item><item><title><![CDATA[SQL Server XML应用实例]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3335158</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3335158</guid><author>liangCK</author><pubDate>Wed, 19 Nov 2008 15:23:00 +0800</pubDate><description><![CDATA[/*  Author: liangCK  小梁        Date  : 2008-11-19*/ 示例一: 如在一个10/20/30/50/40/90的字符串当中.需要得到前N个”/”的字串,或得到前N个”/”的和.如上的字符串.如果得到前3个”/”的字符串.也就是10/20/30/,要得到前3个”/”的数的和,就是60.这样的操作在以前通常会写一个函数,然后循环记数得到]]></description><category></category></item><item><title><![CDATA[SQL Express自动备份]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3311933</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3311933</guid><author>liangCK</author><pubDate>Sun, 16 Nov 2008 15:53:00 +0800</pubDate><description><![CDATA[--第一步--在master库中建立一个备份数据库的存储过程.USE master GOCREATE PROC p      @db_name sysname,         --数据库名      @bk_path NVARCHAR(1024)     --备份文件的路径 AS      IF ISNULL(@db_name,)=          ]]></description><category></category></item><item><title><![CDATA[查每个分组前N条记录]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3292540</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3292540</guid><author>liangCK</author><pubDate>Thu, 13 Nov 2008 17:35:00 +0800</pubDate><description><![CDATA[-----------------------------------  Author: liangCK 小梁--  Title : 查每个分组前N条记录--  Date  : 2008-11-13 17:19:23--------------------------------- --> 生成测试数据: #TIF OBJECT_ID(tempdb.dbo.#T]]></description><category></category></item><item><title><![CDATA[批量导出存储过程]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3249430</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3249430</guid><author>liangCK</author><pubDate>Fri, 07 Nov 2008 19:47:00 +0800</pubDate><description><![CDATA[--问题描述: 将某个数据库下的所有存储过程生成一个对应名称的脚本文件. CREATE PROC p   @dbname sysname,      --数据库名   @bkpath nvarchar(1024)=D:/         --生成脚本的路径名AS   IF ISNULL(@dbname,)=      --传入的@dbname参数为空时,表示生成]]></description><category></category></item><item><title><![CDATA[TRIM字符串的指定的头尾字符]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3124245</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3124245</guid><author>liangCK</author><pubDate>Wed, 22 Oct 2008 14:35:00 +0800</pubDate><description><![CDATA[CREATE FUNCTION dbo.trimChar(@char VARCHAR(5),@str VARCHAR(50))     RETURNS VARCHAR(50) AS BEGIN      DECLARE            @RE VARCHAR(50),           @TEMP VARCHAR(50),           @i INT; ]]></description><category></category></item><item><title><![CDATA[利用Log Explorer将你已经delete,truncate,drop过的数据进行恢复 ]]></title><link>https://blog.youkuaiyun.com/liangCK/article/details/3118397</link><guid>https://blog.youkuaiyun.com/liangCK/article/details/3118397</guid><author>liangCK</author><pubDate>Tue, 21 Oct 2008 17:11:00 +0800</pubDate><description><![CDATA[原地址： http://blog.youkuaiyun.com/jiangopen/archive/2004/07/14/41684.aspx作者：jiangopen 了解数据库的人都知道，数据库的日志记录了我们所有对数据库的操作动作，正是有了日志才使得事务的回滚成为可能。也就是说日志可以让所有的动作可逆，尽管我们知道这个原理，但是很少有人去分析sqlserver的日志，然后生成逆向的脚本，将已经执行]]></description><category></category></item><item><title><![CDATA[全文索引同义词搜索没作用的问题]]></title><link>https://blog.youkuaiyun.com/liangck/article/details/3090057</link><guid>https://blog.youkuaiyun.com/liangck/article/details/3090057</guid><author>liangck</author><pubDate>Fri, 17 Oct 2008 10:05:00 +0800</pubDate><description><![CDATA[--显示版本信息SELECT @@VERSION;GOCREATE TABLE FullText_Test(  ID int IDENTITY(1,1),  DATA nvarchar(max),  --如果这里使用varchar(max),下面的插入也不带N,那CONTAINS得不到任何记录  CONSTRAINT PK_ID_FullText_Test       PRIMARY KEY(]]></description><category></category></item></channel></rss>