Viewing 6 posts - 76 through 81 (of 81 total)
Try this
DELETE TableA
WHERE COALESCE(Col1,Col2,Col3,'') = ''
Ram Ramamoorthy
February 23, 2006 at 7:01 am
USE master
GO
RESTORE DATABASE <DBNAme> WITH RECOVERY
December 28, 2005 at 5:10 am
USE master GO restore database <YourDBName> with recovery
try it out
December 28, 2005 at 5:07 am
DECLARE @DBFileName VARCHAR(100)
DECLARE @SQLString VARCHAR(500)
SELECT @DBFileName = 'D:\SQL2000\Data\xxx.mdf'
SELECT @SQLString = 'FILE = '+@DBFileName
PRINT @SQLString
-- The Syntax is FILE = 'D:\SQL2000\Data\xxx.mdf'
-- Hence
SELECT @SQLString = 'FILE = '''+@DBFileName+''''
-- or
SELECT @SQLString = 'FILE...
December 28, 2005 at 4:59 am
SET @SQLString = 'CREATE DATABASE ' + @DB_Name + ' ON ( NAME = PROD_datas, FILENAME = ' + QUOTENAME(@DB_Datas_Path,'''') + ' ) LOG ON ( NAME = PROD_logs, FILENAME...
December 28, 2005 at 4:49 am
USE master
GO
DECLARE @DB_Name varchar(128)
DECLARE @DB_Bak_file varchar(128)
DECLARE @DB_Import_file varchar(128)
DECLARE @DB_Datas_Path varchar(260)
DECLARE @DB_Logs_Path varchar(260)
DECLARE @DB_Login varchar(128)
DECLARE @DB_Password varchar(128)
DECLARE @SQLString nvarchar (2000)
-- Nom de la base de données à créer --
SET @DB_Name =...
December 28, 2005 at 4:25 am
Viewing 6 posts - 76 through 81 (of 81 total)