ocean42234111的博客

sql  sql server 加行锁注意事项(防止锁全表)实例:BEGIN TRANSET TRANSACTION ISOLATION LEVEL REPEATABLE READ;SET LOCK_TIMEOUT 5000--初始化分配一个@sndeclare @SN varchar(20)select  top 1 @SN=SN from  Tablenam

优化SQL语句,唯一非聚集索引变量传入时索引失效解决方案

DECLARE @xml XML = '   xxx111    xxx222 ';SELECT  tab.col.value('(../@column_name)', 'nvarchar(100)') AS column_name ,        tab.col.value('.[1]', 'nvarchar(100)') AS va

1.备份事务日志2.截断（运行下边示例代码）3.再备份事务日志(观察LDF文件有没有变小)-----收缩大日志  SELECT * FROM sys.database_files   USE DBnameGO --截断日志CHECKPOINT--收缩日志DBCC SHRINKFILE(DBname_Log,1000)--查

INSERT EXEC嵌套问题 --第一个存储过程_TestAALTER PROCEDURE[dbo].[_TestA] @SNNVARCHAR(50)= NULLAS    SET NOCOUNT ON;    BEGIN        CREATE TABLE#Detail           (             sn VARCH

1. 建立文件组 2. 建立文件 3. 分区函数CREATE PARTITION FUNCTION [DAYOrderPartitionFunction] (datetime) AS RANGE RIGHT FOR VALUES (N'2016-05-23T00:00:00.000', N'2016-05-24T00:00:00.000', N'2016-05-25T00:

--1生成测试表CREATE TABLE [dbo].[TABLEA]([WO] [varchar](50) NOT NULL,[ColoumnName] [varchar](50) NULL,[ColoumnValue] [varchar](50) NULL,) insert into [TABLEA]values('PRD_100000048','SN','SN001')ins...