07.11.2010

IF KULLANIMI

use eticaretDB
go

DECLARE @fiyatToplami int

SET @fiyatToplami = (select SUM(fiyati) from urunlerTbl where id=1);
--print @fiyatToplami

IF @fiyatToplami > 100
BEGIN
PRINT 'Urunler Listesindeki 1 Numarali Kayitin Fiyati 100 TL den Buyuktur'
END

ELSE IF @fiyatToplami < 100
BEGIN
PRINT 'Urunler Listesindeki 1 Numarali Kayitin Fiyati 100 TL den Kucuktur'
END

ELSE
BEGIN
PRINT 'Urunler Listesindeki 1 Numarali Kayitin Fiyati 100 TL dir'
END
go

***********************************************************************
YAPILAN İŞLEMİ SAYDIRMAMA KOMUTU

use eticaretDB
go

SET NOCOUNT ON
WHILE (select SUM(fiyati) from urunlerTbl) > 1000
BEGIN
UPDATE urunlerTbl
SET fiyati = fiyati-50
END

SET NOCOUNT ON
SELECT SUM(fiyati) FROM urunlerTbl

*****************************************************************
TARİH İŞLEMLERİ

use eticaretDB
go

select Current_Timestamp

select Dateadd(Day,2,getDate())
select Dateadd(Month,2,getDate())
select Dateadd(Year,2,getDate())

select isDate('03.11.2010')
select isDate('03112010')

select getDate()
select getutcdate()

select datepart(Day,getDate())
select datepart(Month,getDate())
select datepart(Year,getDate())


*****************************************************************
SERVER IN KULLANDIĞI DEĞİŞKENLER

use eticaretDB
go

SET DATEFIRST 1;
SELECT @@DATEFIRST AS 'Hafta Baslangici'
,DATEPART(dw, getDate()) AS 'Haftanin Kacinci Gunu';

select @@langid
select @@language
select @@connections
select @@max_connections
select @@servername
select @@servicename
select @@spid -- service process id
select @@textsize
select @@version

***********************************************************************

use eticaretDB
go

select col_length('urunlerTbl','isim')
select col_length('urunlerTbl','fiyati')

select db_id('eticaretDB')
select db_name(7)

select current_user
select session_user
select system_user

select datalength(isim) from urunlerTbl

select host_name()

select isNumeric('a')
select isNumeric('65')

select user
select user_id()
select user_name(1)