摘要：
SET @iSQL=N'BULK INSERT [TEST].[dbo].[TEST_Interim]'+' FROM '+quotename(@fullFileName,'''')+' WITH (BATCHSIZE=1000,FIELDTERMINATOR=''\t'',DATAFILETYPE=''widechar'',FIRSTROW=1,ROWTERMINATOR=''\n'',TAB... 阅读全文
posted @ 2017-05-31 10:50
芈璐
阅读(164)
评论(0)
推荐(0)
摘要：
SET @FilePath='D:\TEST.xls' SET @sql='bcp "SELECT * FROM XXX.dbo.XXX WITH(NOLOCK) WHERE XXX=''XXX'' AND XXX = '+@XXX+'" QueryOut '+@FilePath+' -c -T ' EXEC master..xp_cmdshell @SQL 阅读全文
posted @ 2017-05-31 10:49
芈璐
阅读(1119)
评论(0)
推荐(0)
摘要：
--exec master..xp_cmdshell CMD命令 --EXECUTE sys.sp_sqlexec 执行存储 --EXEC sp_executesql 执行DML语句 阅读全文
posted @ 2017-05-31 10:48
芈璐
阅读(249)
评论(0)
推荐(0)
摘要：
--根据关键字查询SP select distinct a.name from sysobjects a,syscomments b where a.id=b.id and a.xtype='P' and b.text like '%XXXXX%' order by name --根据列名查询table SELECT a.name AS TableName,b.Name,b.[length] F... 阅读全文
posted @ 2017-05-31 10:47
芈璐
阅读(219)
评论(0)
推荐(0)
摘要：
CREATE FUNCTION [dbo].[FormatDate] (@date as datetime, @formatstring as varchar(100) ) RETURNS varchar(100) AS BEGIN declare @datestring as varchar(100) set @datestring=@formatstring --year set @d... 阅读全文
posted @ 2017-05-31 10:46
芈璐
阅读(915)
评论(0)
推荐(0)
摘要：
CREATE FUNCTION [dbo].[Func_Split] ( @inputstr VARCHAR(max), @seprator VARCHAR(10) ) RETURNS @temp TABLE (A VARCHAR(200)) AS BEGIN DECLARE @i INT SET @inputstr = RTRIM(LTRIM(@inputstr)) SET ... 阅读全文
posted @ 2017-05-31 10:45
芈璐
阅读(142)
评论(0)
推荐(0)
摘要：
DECLARE cur1 CURSOR SCROLL FOR SELECT DISTINCT xxx,xxx,xxx FROM xxx WHERE xxx='xxx' ORDER BY xxx OPEN cur1 FETCH NEXT FROM cur1 INTO @xxx,@xxx,@xxx WHILE @@fetch_status=0 BEGIN -- sql FETCH NE... 阅读全文
posted @ 2017-05-31 10:44
芈璐
阅读(133)
评论(0)
推荐(0)
摘要：
Step1.将DB脱离可用性组 Step2.修改为简单恢复模式>收缩文件>修改回完整恢复模式 -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE [DB] SET RECOVERY 阅读全文
posted @ 2017-05-31 10:43
芈璐
阅读(606)
评论(0)
推荐(0)
摘要：
----恢复9月6号完全备份 RESTORE DataBase [DB] From Disk='D:\BackUp\DB_FULL20150906.BAK' with NORECOVERY, Move 'DB' to 'D:\SQLData\DB_Data.MDF',Move 'DB_log' to 'D:\SQLData\DB_log.LDF' ----恢复9月7号差异备份 RESTORE ... 阅读全文
posted @ 2017-05-31 10:42
芈璐
阅读(228)
评论(0)
推荐(0)
摘要：
--backup Use [DBName] Declare @FullFileName Varchar(200) Declare @FileFlag varchar(20) Set @FileFlag='20'+convert(char(6),getdate(),12) Set @FullFileName='d:\BackUp\'+@FileFlag+'.BAK' BackUp DataBase... 阅读全文
posted @ 2017-05-31 10:41
芈璐
阅读(157)
评论(0)
推荐(0)
浙公网安备 33010602011771号