摘要:
#region Chart Chart1 = new Chart(); Chart1.Width = 1000; Chart1.Height = 400; axisYMaximum = GetMax(dtsource); double axisYMinimum = GetMin(dtsource); 阅读全文
摘要:
alter table 表名 add constraint DF_表名_字段名 DEFAULT 默认值 for 字段名 阅读全文
摘要:
use master;alter database [A] modify name=[B] 阅读全文
摘要:
exec sp_rename 'MsCheckOut.SQLScript','QryScript','column'--1alter table table_name alter column column_name datatype--2 阅读全文
摘要:
select count(*) 总表数 from sysobjects where xtype='u' 阅读全文
摘要:
use master;gocreate procedure bakdb (@f varchar(max))asbegin declare @file varchar(max) set @file=@f declare auth_cur cursor for select name from sysd 阅读全文
摘要:
DECLARE @x XML SET @x='<root> <rogue id="001"> <hobo id="1"> <name>彪</name> <nickname>阿彪</nickname> <type>流氓</type> <name>含</name> </hobo> </rogue> <r 阅读全文
摘要:
SELECT STUFF(( select '/'+convert(varchar,ID) from ( SELECT TOP 2 ID FROM dbo.T ) as a FOR XML PATH ('')),1,1,'') 阅读全文
摘要:
with a(a,b,c)as( SELECT [deptid],[deptname],[deptmgrid] FROM [T].[dbo].[Departments])select * from a 阅读全文
摘要:
select 1 where '[^A-Z]ABCDE' like 'a[a^Aa-Za]%' escape 'a' 阅读全文
摘要:
select a.ProjectID,c.* from BatchTask a cross apply (select * from TaskLog b where a.RsIndex=b.BatchTaskID) as c 同理,outer apply 阅读全文
摘要:
CREATE TABLE [dbo].[t]( [id] [int] IDENTITY(1,1) NOT NULL, [p] [nvarchar](max) NULL) ON [PRIMARY]insert into t(p) values('a,b,c')insert into t(p) valu 阅读全文