sysobjects tablosundaki xtype açıklamaları

———- sysobjects tablosundaki xtype açıklamaları

/*** XTYPE

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

L = Log

FN = Scalar function

IF = In-lined table-function

P = Stored procedure

PK = PRIMARY KEY constraint (type is K)

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

UQ = UNIQUE constraint (type is K)

V = View

X = Extended stored procedure

****/

——- sysobjects içindeki type tanımlamaları ————-

/**** TYPE

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

FN = Scalar function

IF = In-lined table-function

K = PRIMARY KEY or UNIQUE constraint

L = Log

P = Stored procedure

R = Rule

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

V = View

X = Extended stored procedure

**********/

exec usp_ListCustomers

go

execute usp_ListCustomers

go

usp_ListCustomers

go

alter procedure usp_ListCustomers

as

select CustomerID,CompanyName from customers

where Country = ‘UK’

go

drop procedure usp_ListCustomers

select * from [order details]

–declare @pid int

–set @pid = 111

alter proc usp_GetTotalbyProductID

@pid int

as

IF EXISTS (select productID from [order details] where ProductID = @pid)

begin

select SUM(Unitprice * Quantity) as ‘Total’

from [order details]

where ProductID = @pid

end

ELSE

raiserror(‘Unmatched ProductID…’,14,1)

return

GO

exec usp_GetTotalbyProductID 11

select top 2 * from [order details]

select * from orders

select top 2 * from customers

select top 2 * from products

declare @startdate datetime , @enddate datetime

set @startdate = ‘19960701 00:00:00′

set @enddate = ‘19960801 00:00:00′

create procedure usp_GetTotalReport

@startdate datetime ,

@enddate datetime

as

select p.productname , sum(od.unitprice * od.quantity) as total

from [order details] od inner join orders o

on o.orderID = od.OrderID

inner join products p

on p.productID = od.productID

where o.orderdate between @startdate and @enddate

group by p.productname

order by p.productname

GO

usp_GetTotalReport ‘19960701 00:00:00′,’19960801 00:00:00′

create proc topla2

@sayi1 int,

@sayi2 int,

@sonuc int output

with recompile

as

select @sonuc = @sayi1 + @sayi2

GO

declare @sonuc int

EXEC topla 1,2,@sonuc output

select @sonuc

sp_recompile topla

declare @startdate datetime , @enddate datetime

set @startdate = ‘19960101 00:00:00′

set @enddate = ‘20060801 00:00:00′

alter proc usp_deleteproduct

@pid int

as

delete from products where productID = @pid

if @@rowcount = 0

begin

print ‘Hata oluştu…’

return 99

end

else

print ‘Product that has the number’ + cast(@pid as varchar(10)) + ‘was deletede successfully’

return 0

go

usp_deleteproduct 11

sysobjects tablosundaki xtype açıklamaları