<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Mevin的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/Mevin</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; Mevin]]></copyright><item><title><![CDATA[sqlserver中判断表或临时表是否存在]]></title><link>https://blog.csdn.net/Mevin/article/details/13507325</link><guid>https://blog.csdn.net/Mevin/article/details/13507325</guid><author>Mevin</author><pubDate>Tue, 29 Oct 2013 14:04:57 +0800</pubDate><description><![CDATA[1、判断数据表是否存在

　　方法一：

use yourdb;
go

if object_id(N'tablename',N'U') is not null
print '存在'
else 
print '不存在'


例如：
use fireweb;
go

if object_id(N'TEMP_TBL',N'U') is not null
print ]]></description><category></category></item><item><title><![CDATA[日期函数的计算（计算两个日期的天数差，除去工作日（工作日表自己定义））]]></title><link>https://blog.csdn.net/Mevin/article/details/11610275</link><guid>https://blog.csdn.net/Mevin/article/details/11610275</guid><author>Mevin</author><pubDate>Thu, 12 Sep 2013 16:56:45 +0800</pubDate><description><![CDATA[1.节假日表

CREATE TABLE [DicDate] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [DateStr] [varchar10] NULL ,
 [WorkFlag] [Flag] NOT NULL CONSTRAINT [DF_DicDate_WorkFlag] DEFAULT ('1101'),
  CONSTRAINT ]]></description><category></category></item><item><title><![CDATA[SQL取出 所有周六 周日的日期]]></title><link>https://blog.csdn.net/Mevin/article/details/11609601</link><guid>https://blog.csdn.net/Mevin/article/details/11609601</guid><author>Mevin</author><pubDate>Thu, 12 Sep 2013 16:50:10 +0800</pubDate><description><![CDATA[CREATE TABLE [dbo].[DicDate](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateStr] [smalldatetime] NULL,
 CONSTRAINT [PK_DicDate] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NO]]></description><category></category></item><item><title><![CDATA[base64编码解码存储过程]]></title><link>https://blog.csdn.net/Mevin/article/details/9250425</link><guid>https://blog.csdn.net/Mevin/article/details/9250425</guid><author>Mevin</author><pubDate>Fri, 05 Jul 2013 11:30:33 +0800</pubDate><description><![CDATA[-创建base64编码的函数
CREATE    FUNCTION    base64_encode  
   (  
       @plain_text    varchar(6000)  
   )  
   RETURNS    
                       varchar(8000)  
   AS    BEGIN  
   --local    va]]></description><category></category></item><item><title><![CDATA[如何用SQL语句查询Excel数据？]]></title><link>https://blog.csdn.net/Mevin/article/details/9167177</link><guid>https://blog.csdn.net/Mevin/article/details/9167177</guid><author>Mevin</author><pubDate>Tue, 25 Jun 2013 09:40:18 +0800</pubDate><description><![CDATA[2007和2010版本:

 SELECT *
 FROM OpenDataSource( 'Microsoft.ACE.OLEDB.12.0',
 'Data Source="c:\book1.xlsx";User ID=Admin;Password=;Extended properties=Excel 12.0')...[Sheet1$]




SELECT * FROM]]></description><category></category></item><item><title><![CDATA[.Net读取xlsx文件Excel2007]]></title><link>https://blog.csdn.net/Mevin/article/details/8992655</link><guid>https://blog.csdn.net/Mevin/article/details/8992655</guid><author>Mevin</author><pubDate>Thu, 30 May 2013 10:17:57 +0800</pubDate><description><![CDATA[.NET
 读取Excel 2007的xlsx文件和读取老的.xls文件是一样的，都是用Oledb读取,仅仅连接字符串不同而已。

读取xlsx
 用的是Microsoft.Ace.OleDb.12.0;

具体操作方法如下：

public static DataTable
 GetExcelToDataTableBySheet(string FileFullPath,
st]]></description><category></category></item><item><title><![CDATA[javascript下拉列表框取值]]></title><link>https://blog.csdn.net/Mevin/article/details/8911891</link><guid>https://blog.csdn.net/Mevin/article/details/8911891</guid><author>Mevin</author><pubDate>Fri, 10 May 2013 17:22:33 +0800</pubDate><description><![CDATA[选择
be
ce
de
ee


function getSelect() {
   //得到select下拉列表中option的value
   var optionValue = document.getElementById("sel").options[document.getElementById("sel").options.selectedIndex].value;]]></description><category></category></item><item><title><![CDATA[Oracle 进制转换]]></title><link>https://blog.csdn.net/Mevin/article/details/8616199</link><guid>https://blog.csdn.net/Mevin/article/details/8616199</guid><author>Mevin</author><pubDate>Wed, 27 Feb 2013 09:57:31 +0800</pubDate><description><![CDATA[一.16进制转换为10进制to_number函数

-- 此处必须为大于或等于16进制字符数的xxxxxx,此处可以为>=6个x

select to_number('1195A5','xxxxxx') from dual

TO_NUMBER('1195A5','XXXXXX')
----------------------------
1152421

select to_]]></description><category></category></item><item><title><![CDATA[C#调用DLL时参数问题]]></title><link>https://blog.csdn.net/Mevin/article/details/8609794</link><guid>https://blog.csdn.net/Mevin/article/details/8609794</guid><author>Mevin</author><pubDate>Mon, 25 Feb 2013 15:36:21 +0800</pubDate><description><![CDATA[C#导入DLL时，参数怎么定义是一个比较头痛的问题。特别是指针类型的参数，关于此问题本人有点不成熟的经验。

以 GetComputerName这个函数为例。

函数原型如下:


BOOL GetComputerName(
  LPTSTR lpBuffer,
  LPDWORD lpnSize
);

这个lpBuffer就是下个string型的指针，其实无论是什么类型]]></description><category></category></item><item><title><![CDATA[获取日期第二新的记录]]></title><link>https://blog.csdn.net/Mevin/article/details/8597525</link><guid>https://blog.csdn.net/Mevin/article/details/8597525</guid><author>Mevin</author><pubDate>Thu, 21 Feb 2013 11:01:26 +0800</pubDate><description><![CDATA[表结构：
         id       a         b        c
1 01 1 2004-8-25 16:00:47
2 01 2 2004-9-25 16:01:08
3 01 3 2004-10-25 16:01:10
4 01 4 2004-11-25 16:02:23
5 02 1 2004-8-25 16:02:41
6 02 2 2004-9-25]]></description><category></category></item><item><title><![CDATA[Sqlserver 获取每组中的第一条记录]]></title><link>https://blog.csdn.net/Mevin/article/details/8597510</link><guid>https://blog.csdn.net/Mevin/article/details/8597510</guid><author>Mevin</author><pubDate>Thu, 21 Feb 2013 10:59:30 +0800</pubDate><description><![CDATA[例子









 id 

grp  

data  

createtime  



  1

  g1

  10

  2011-9-1



  2

  g1

  11

  2011-9-2



  3

  g2 

  111

  2011-10-12



  4]]></description><category></category></item><item><title><![CDATA[asp.net GridView 删除时弹出确认对话框(包括内容提示)]]></title><link>https://blog.csdn.net/Mevin/article/details/8518132</link><guid>https://blog.csdn.net/Mevin/article/details/8518132</guid><author>Mevin</author><pubDate>Fri, 18 Jan 2013 17:42:58 +0800</pubDate><description><![CDATA[效果图：
 
html代码

复制代码代码如下:


 
 
 
GridView演示 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


C#代码

复制代码代码如下:


using System; 
using System.Data; 
using System.Data.SqlClient;]]></description><category></category></item><item><title><![CDATA[sqlserver把一列中的多行数据在一行显示]]></title><link>https://blog.csdn.net/Mevin/article/details/8513472</link><guid>https://blog.csdn.net/Mevin/article/details/8513472</guid><author>Mevin</author><pubDate>Thu, 17 Jan 2013 14:39:01 +0800</pubDate><description><![CDATA[表jizhan
region cell
station zaipin
fujiao tianxian
建邺 应天路1 
应天路 5 6
90
建邺 应天路2 
应天路 6 9
200
建邺 应天路3 
应天路 3 6
310
玄武 1101厂1 
1101厂 3 
8 310
玄武 1101厂2 
1101厂 3 
10 90
玄武 1101厂3 
1101]]></description><category></category></item><item><title><![CDATA[文件夹中文件夹(文件)按时间排序,读取最新的文件夹(文件)]]></title><link>https://blog.csdn.net/Mevin/article/details/8473762</link><guid>https://blog.csdn.net/Mevin/article/details/8473762</guid><author>Mevin</author><pubDate>Sun, 06 Jan 2013 16:53:31 +0800</pubDate><description><![CDATA[using System.IO;  
  
 private void button1_Click(object sender, EventArgs e)  
        {  
            //DirectoryInfo[] list = new DirectoryInfo(path).GetDirectories();// path：文件夹路径]]></description><category></category></item><item><title><![CDATA[jquery 内容改变时触发事件]]></title><link>https://blog.csdn.net/Mevin/article/details/8269182</link><guid>https://blog.csdn.net/Mevin/article/details/8269182</guid><author>Mevin</author><pubDate>Fri, 07 Dec 2012 14:03:40 +0800</pubDate><description><![CDATA[$("#textboxID").bind("input propertychange", function()
 {
alert($(this).val());
});]]></description><category></category></item><item><title><![CDATA[在SQL Server 2005中连接Oracle，完成查询、插入操作]]></title><link>https://blog.csdn.net/Mevin/article/details/8268074</link><guid>https://blog.csdn.net/Mevin/article/details/8268074</guid><author>Mevin</author><pubDate>Fri, 07 Dec 2012 09:44:07 +0800</pubDate><description><![CDATA[建立指向Oracle的连接

假设Oracle数据库的用户名为test，密码为test，在SQL Server数据库所在服务器上建立的指向Oracle数据库的服务命名为hisorcl.
1. 在SQL Server的企业管理器中的对象资源管理器中，展开“服务器对象”，在“链接服务器”上右击，选“新建链接服务器”。如下图所示进行配置。





通过连接查询Oracle数据库中的数]]></description><category></category></item><item><title><![CDATA[SQL Server 2008连接Oracle操作步骤详细记录]]></title><link>https://blog.csdn.net/Mevin/article/details/8267952</link><guid>https://blog.csdn.net/Mevin/article/details/8267952</guid><author>Mevin</author><pubDate>Fri, 07 Dec 2012 09:25:36 +0800</pubDate><description><![CDATA[SQL Server Management Studio Express（简写SSMS）
SQL Server配置管理器：SQL Server Configuration Manager（简写SSCM）
一、 开启SQL Server 2008远程连接---如果已经开启，则可以跳过
1. 打开SSMS，用Windows身份连接数据库后，右键点击数据库引擎，选择“属性”
2. 左侧选择“安全]]></description><category></category></item><item><title><![CDATA[SQL Server链接服务器 Linked Server]]></title><link>https://blog.csdn.net/Mevin/article/details/8267937</link><guid>https://blog.csdn.net/Mevin/article/details/8267937</guid><author>Mevin</author><pubDate>Fri, 07 Dec 2012 09:17:23 +0800</pubDate><description><![CDATA[使用方法

exec sp_addlinkedserver @server,@srvproduct,@provider,@datasrc,@location,@provstr,@catalog;
exec sp_addlinkedsrvlogin @rmtsrvname,@useself,@locallogin,@rmtuser,@rmtpassword;
exec sp_serverop]]></description><category></category></item><item><title><![CDATA[Sql Server十六进制转换为十进制]]></title><link>https://blog.csdn.net/Mevin/article/details/8225170</link><guid>https://blog.csdn.net/Mevin/article/details/8225170</guid><author>Mevin</author><pubDate>Mon, 26 Nov 2012 12:08:38 +0800</pubDate><description><![CDATA[CREATE  function HexToInt (@hex varchar(100))
returns int
as
begin
    Declare @result int,@iPos int,@iTmp int,@iLoop int,@tmp varchar(16)
    Set @tmp = '0123456789ABCDEF'
    Select @result =]]></description><category></category></item><item><title><![CDATA[sql server取当天8点到20点的数据]]></title><link>https://blog.csdn.net/Mevin/article/details/8139419</link><guid>https://blog.csdn.net/Mevin/article/details/8139419</guid><author>Mevin</author><pubDate>Fri, 02 Nov 2012 09:46:29 +0800</pubDate><description><![CDATA[select * from dbo.response_msg_log 
where datepart(hh,ResponseTime) between 8 and 20  
and convert(varchar(10),getdate(),120)=convert(varchar(10),ResponseTime,120)]]></description><category></category></item></channel></rss>