SQL Query Notlarım.
( Basit Sorgular )
( Uyarı : Bu Query’leri Live Veritabanlarınızda denemeyiniz ! )
SQL 2005 Dil Değiştirme
******************************************************
EXECUTE sp_configure ‘default language’, 22RECONFIGURE WITH overrideALTER LOGIN sa WITH DEFAULT_LANGUAGE = Turkish
GO
——————————————————————
SQL NETWORK PERFORMANCE
*************************
DBCC SQLPERF(NETSTATS)
BEllek YApılandırması
***********************************************
sp_configure ‘show advanced options’, 1
RECONFIGURE
GO
sp_configure ‘awe enabled’, 1
RECONFIGURE
GO
sp_configure ‘max server memory’, 6144
RECONFIGURE
GO
Tablo Tranfer
*********************************************************
SELECT * INTO TARGETTABLE from SOURCETABLE
—————————————————————–
SQL Dil Değiştirme
*********************************************************
EXECUTE sp_configure ‘default language’, 22
RECONFIGURE WITH override
ALTER LOGIN sa WITH DEFAULT_LANGUAGE = Turkish
GO
EXEC SP_HELPLANGUAGE
SELECT @@LANGUAGE
*******************************************************************************************
Connect OSQL Database
———————————————————————
c:> osql -U sa -P Şifre -S SUNUCUADI
> USE master
> SELECT name,dbid FROM sysdatabases
Sunucu üzerindeki Tüm DB’leri listeler.
———————————————————————
Cursor Triger
*********************************************************
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[updatetable] ON [dbo].[TAHSILATMAIN]
FOR UPDATE
AS
DECLARE @IDno INT
DECLARE Denetim CURSOR
FOR
SELECT IDno FROM Inserted
OPEN Denetim
FETCH NEXT FROM Denetim Into @IDno
WHILE (@@FETCH_STATUS <> -1)
BEGIN
INSERT INTO TEST VALUES(@IDno)
FETCH NEXT FROM Denetim INTO @IDno
END
CLOSE Denetim
Connect OSQL Database
———————————————————————
c:> osql -U sa -P Şifre -S SUNUCUADI
> USE master
> SELECT name,dbid FROM sysdatabases
Sunucu üzerindeki Tüm DB’leri listeler.
———————————————————————