zencorn的专栏

1. Make sure you SQL Server version by using some T-SQL .Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT  SERVERPROPERTY('productversion'),

Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.   １.  As we knew SQL Server has provided a serices of XML execution function,  we can using SQL query to get the fi

关于SQL server2005中插入汉字变成问号的解决办法  1、右击你所建的数据库，点击“属性”，选择“选项”并点击。将其中的排序规则设置为：Chinese_PRC_CI_AS(选择下拉列表框即可设置)，然后“确定“。 2、在表中将你的汉字字段的数据类型设置为nvarchar型或ntext型，设置前最好先将表中的数据全部删除。（不要使用varchar或text型，因为它们只会继续使

1. INNER JOINselect a.* ,b.AGAServicePort from MC_Entity a INNER JOIN AGA_Status bON b.AGAServicePort = a.MC_ServicePortwhere a.MC_ServicePort   2. INSERT INTO 　　2.1 不带列名插进数据     　

Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.  Goal: Using java to run one SQL script file directly .Resource : Download the Java-Ant jar package from http

1.  Microsoft SQL Server 2008R2->Performance Tools->SQL Server Profiler.2. Before start to run a new Trace for you DB you should to get you DB id by this way; use masterSELECT * FROM sysdataba

Issue: SQL server does not work when the log file occupied all the disk space.Resolution: Remove the LOG file data .Step:1. Backup your database.2. Detach your database.3. Check the close

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->DBCC DROPCLEANBUFFERS;DBCC FREEPROCCACHE ;SET STATISTICS TIME ON;SELECT COUNT(*) FROM EmployeeSET STAT

SELECT name From sysobjects WHERE xtype = 'u'