随笔分类 -  SQL Server

摘要：--测试环境MSSQL2008 --建表 Create Table M ( Id int, Name Varchar(20), PId int ) Create Table N ( Id int, DesContent Varchar(20), M_Id int, TotalMoney int ) --插入数据 Insert int... 阅读全文

摘要：SELECT　* FROM Tablewhere a.TenantKey=@TenantId AND (@ProjectKeys is null or b.RecuritProjectKey in (select * from dbo.f_SplitToInt(@ProjectKeys,',')))... 阅读全文

摘要：--合并分拆表/********************************************合并分拆表数据整理人：中国风(Roy)日期:2008.06.06*********************************************/--> --> (Roy)生成測試數據if not object_id('Tab') is nulldrop table TabGoCreate table Tab([Col1] int,[Col2] nvarchar(1))Insert Tabselect 1,N'a' union allse 阅读全文

摘要：CREATE PROC [dbo].[dba_WhatSQLI***ecuting]AS/*--------------------------------------------------------------------Purpose: Shows what individual SQL statements are currently executing.----------------------------------------------------------------------1. exec YourServerName.master.dbo.dba_WhatSQLI 阅读全文