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 JOIN select a.* ,b.AGAServicePort from MC_Entity a  INNER JOIN AGA_Status b ON b.AGAServicePort = a.MC_ServicePort where 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 master SELECT * 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'