C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe
C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
USE [TestDB]
GO
DECLARE @id int
SET @id = 2
PRINT 'ID: ' + CAST( @id AS nvarchar(MAX) )
DECLARE @params nvarchar(MAX)
SELECT @params=[Params]
FROM [TestTBL]
WHERE [ID]=@id
PRINT @params
UPDATE [TestTBL]
SET [Params] = REPLACE(
-- CAST( [Params] AS nvarchar(MAX) ), -- 型が合わない時はCASTする
[Params],
'<PARAM NAME="JPG_RES" VALUE="72"/>',
'<PARAM NAME="JPG_RES" VALUE="150"/>'
)
WHERE [ID]=@id
SELECT @params=[Params]
FROM [TestTBL]
WHERE [ID]=@id
PRINT @params
GO
SQL スクリプトを実行する。
SELECT
[name],
[crdate],
[filename]
FROM
[sysdatabases]
WHERE
-- システムデータベースは除く
NOT [name] IN ('master', 'model', 'msdb', 'tempdb');
GO
-- 全てのデータベースを一括完全バックアップ
-- SQL Server 2005/2008/2008R2
DECLARE @DBName NVARCHAR(128)
DECLARE @OutputFolder NVARCHAR(1024)
DECLARE @OutputName NVARCHAR(1024)
DECLARE @CRLF NVARCHAR(2)
-- SQL Server 上のパスを指定
SET @OutputFolder = 'D:/DB_Backup/'
-- 改行コード
SET @CRLF = NCHAR(13) + NCHAR(10)
DECLARE DBCursor CURSOR FOR
SELECT [name]
FROM [sysdatabases]
-- システムデータベースは除外
WHERE NOT [name] IN ('master', 'model', 'msdb', 'tempdb')
OPEN DBCursor
FETCH NEXT FROM DBCursor
INTO @DBName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @CRLF + @DBName
SET @OutputName = @OutputFolder + @DBName + '.bak'
BACKUP DATABASE @DBName
TO DISK = @OutputName
WITH FORMAT
FETCH NEXT FROM DBCursor
INTO @DBName
END
CLOSE DBCursor
DEALLOCATE DBCursor