Kodla Backup Almak

BACKUP DATABASE [database adı] TO
DISK = N''H:\BACKUP\kaydedilecek dosya ismi ve yeri.bak''
WITH NOFORMAT, NOINIT,  NAME = N''kaydedilecek dosya ismi'',
SKIP, REWIND, NOUNLOAD, COMPRESSION,  STATS = 10

MS SQL de XML okuma

DECLARE @idoc int
DECLARE @doc xml
DECLARE @TEMPSQL NVARCHAR(2000)
DECLARE @DOCPATH NVARCHAR(2000)
 set @DOCPATH = ‘C:\param.xml’
 SET @TEMPSQL = ‘SET @doc = (SELECT * FROM OPENROWSET(bulk ”’ + @DOCPATH + ”’,single_blob) as doc)’
 EXEC SP_EXECUTESQL @TEMPSQL, N’@doc xml OUTPUT’,
@doc = @doc OUTPUT
 EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
 SELECT    * FROM      OPENXML (@idoc, ‘/ParametreBilgileri/OzelParametreler/PRGOZELPRM/Kayit_1′,2)
WITH (GRUPKOD  varchar(20),  ANAHTAR varchar(20)) WHERE GRUPKOD=‘BANKA’
EXEC sp_xml_removedocument @idoc

SQL de Table Özelliklerini Öğrenme

Procedure ;

create proc getTableSize

as

Declare @T TABLE(name varchar(1000),
[rows] varchar(100),
[reserved] varchar(100),
[data] varchar(100),
[index_size] varchar(100),
[unused] varchar(100))

DECLARE P1 CURSOR FOR
SELECT NAME FROM SYS.OBJECTS WHERE TYPE='U'
OPEN P1
DECLARE @N AS VARCHAR(100)
FETCH NEXT FROM P1
INTO @N
WHILE @@FETCH_STATUS=0
BEGIN
INSERT INTO @T
exec sp_spaceused @N

FETCH NEXT FROM P1
INTO @N
END
CLOSE P1
DEALLOCATE P1
SELECT * FROM @T ORDER BY name ASC


-------------------------------------------------------


Stored prosedürü kullanmak için;


exec getTableSize

Ms SQL Server Versiyon Öğrenme

SELECT SERVERPROPERTY('productversion') Version,
SERVERPROPERTY ('productlevel') SP,
SERVERPROPERTY ('edition') Edition