自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(6)
  • 资源 (10)
  • 收藏
  • 关注

原创 将一条T-SQL语句执行N次最简单的方法

 use tempdb;    go drop  table TestgoCreate  table Test(   A int identity primary key,B NVARCHAR(50))insert  into Test(B

2009-11-20 18:22:00 1390

原创 有趣的RAISERROR

RAISERROR (Invalid Input, 0, 9)RAISERROR (Invalid Input, 10, 9)相当于ShowMessage()----------Invalid InputRAISERROR (Invalid Input, 1, 9)...RAISERROR (Invalid Input, 9, 9)会先显示Message后显示message级别

2009-11-20 09:21:00 916

翻译 Truncate Table和Delete的简单比较

 TRUNCATE TABLE 语句比DELETE 使用更少的锁。使用TRUNCATE TABLE 时 SQL Server使用表锁(table) 和 页(page)而不会使用DELETE使用的行锁( row locks)。TRUNCATE TABLE 语句比DELETE 使用更少的事物日志空间。当使用TRUNCATE TABLE时,SQL Server 释放表页面并将该释放过程记录在

2009-11-18 13:40:00 686

原创 SQL Server2005四个排序函数简介

 排名函数是SQL Server2005新加的功能。在SQL Server2005中有如下四个排名函数:1. row_number 自动生成行号,序号由order by 字段决定2. rank over Filed, 由rank over的字段决定,名次不连续,如有3个并列第一名,则后续名次直接从4开始 3. dense_rank,和rank相似,只是名次连续,如有3个并列第一名,则后

2009-11-04 14:46:00 811

原创 ILMerge(将多个.Net Assembly合并成一个assembly的工具)连接地址

http://www.microsoft.com/downloads/details.aspx?familyid=22914587-b4ad-4eae-87cf-b14ae6a939b0&displaylang=en 

2009-11-04 14:33:00 852

转载 将存储过程返回结果转为视图(Methods For Converting a Stored Procedure Result to a View)

 http://www.sqlservercentral.com/articles/T-SQL/68233/    Create     proceduresp_ConvProc2View   ( @procName varchar(80), @viewName varchar(80)) 

2009-11-03 14:35:00 1611

关于SQL注入的资料-3

关于SQL注入的资料-3,讲解常见的sql注入攻击及其防范

2009-05-08

关于SQL注入的资料-2

关于SQL注入的资料-2,讲述sql注入高级技巧

2009-05-08

关于SQL注入的资料-1

关于SQL注入的资料-1,讲述如何通过sql注入操纵SQL Server

2009-05-08

一个Windows界面的TableDiff表比较工具

一个Windows界面的TableDiff表比较工具,可比较表记录差异

2009-04-16

SQL Server DBA best practice

SQL Server DBA best practice by EMC2

2009-04-14

SQL Server 执行计划详解

SQL Server 2005 执行计划详解

2009-04-10

戏说面向对象程序设计C#版.pdf

戏说面向对象程序设计C#版,语言幽默风趣很适合初学者入门面向对象编程。

2009-04-03

SQL Server2005微软认证教材

MCTS Self-Paced Training Kit (Exam 70-431) - Microsoft SQL Server 2005 Implementation and Maintenance

2009-04-03

C# 多线程编程 详解

This book provides an introduction to writing concurrent programs with “threads”. A threads facility allows you to write programs with multiple simultaneous points of execution, synchronizing through shared memory. The paper describes the basic thread and synchronization primitives, then for each primitive provides a tutorial on how to use it. The tutorial sections provide advice on the best ways to use the primitives, give warnings about what can go wrong and offer hints about how to avoid these pitfalls. The paper is aimed at experienced programmers who want to acquire practical expertise in writing concurrent programs. The programming language used is C#, but most of the tutorial applies equally well to other languages with thread support, such as Java.

2009-04-03

C# 技术面试 宝典

C# 技术面试 宝典 What methods are fired during the page load? Init () When the page is instantiated, Load() - when the page is loaded into server memory,PreRender () - the brief moment before the page is displayed to the user as HTML, Unload() - when page finishes loading.

2009-04-03

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除