TomSun

享受编程的快乐!Attitude is everything!

导航

07 2005 档案

SQL Restore DB

摘要：1DECLARE @sql nvarchar(4000) 2DECLARE @dataname nvarchar(100) 3 4/**//* DELETE DB */ 5SET @dataname = N'ednchina'+REPLACE(CONVERT(varchar(10),getdate()-3,20),'-','') 6SET @sql = N'IF EXISTS (SELEC... 阅读全文

posted @ 2005-07-01 14:25 TomSun

SQL 健康报告

摘要：1SET NOCOUNT ON 2DECLARE @enter char(2) 3DECLARE @body AS varchar(8000) 4DECLARE @sql nvarchar(4000) 5SET @sql = '' 6 7/**//* 服务器剩余空间 */ 8SET @body = '服务器剩余空间'+ CHAR(13) 9CREATE TABLE #t(a varcha... 阅读全文

posted @ 2005-07-01 14:14 TomSun

SQL Backup differential

摘要：1SET NOCOUNT ON 2DECLARE @t table(id int IDENTITY,n sysname) 3DECLARE @i int 4DECLARE @n sysname 5DECLARE @sql Nvarchar(4000) 6DECLARE @cmd varchar(8000) 7 8INSERT INTO @t(n) 9SELECT name FROM dbo... 阅读全文

posted @ 2005-07-01 14:01 TomSun

SQL 数据备份

摘要：1DECLARE @s datetime 2DECLARE @e datetime 3DECLARE @body AS varchar(8000) 4 5SET @s = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate())-1,'1900-1-1') 6SET @e = DATEADD(mm,DATEDIFF(mm,'1900-1-1',getdate... 阅读全文

posted @ 2005-07-01 13:59 TomSun

SQL中使用联接

摘要：1DECLARE @a table(i int) 2DECLARE @b table(i int) 3 4INSERT INTO @a SELECT 1 UNION ALL SELECT 2 5INSERT INTO @b SELECT 1 UNION ALL SELECT 3 6 7SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i... 阅读全文

posted @ 2005-07-01 13:54 TomSun