Database

Saksida Bojan wrote:

What is diffrent by Windows Service and Web service?

Saksida Bojan wrote:

Can Windows Service uses protocol such as TCP or UDP?

select distinct(tb.[name]) as TableName,tb.[Object_Id] as ObjectId,fk.type_desc,fk.[type] as [type] from sys.tables tb left join sys.foreign_keys fk
on tb.[object_Id] = fk.parent_object_Id
where tb.[type]='U' and tb.is_ms_shipped=0 and tb.[name] not like 'asp%' and tb.[name] not like 'sys%'
order by fk.[type] asc

SELECT K.*,'|',O.NAME,p.name 
FROM sys.foreign_keys K
	INNER JOIN sysobjects O ON O.id = K.referenced_object_id
	INNER JOIN sysobjects P ON P.id = K.parent_OBJECT_ID

select distinct(t.name),t.[object_id] from sys.tables t left join sys.foreign_keys k
on t.object_id=k.parent_object_id
where t.[type]='U' and t.is_ms_shipped=0 and t.[name] not like 'asp%' and t.[name] not like 'sys%'
order by t.[name] desc

select min(PK) from FEE 
where Trans.ID in (select distinct Trans.ID from FEE)
group by Trans.ID

create table #b1(pk int identity, refid int)

insert into #b1 (refid)
select 1
union all
select 2
union all
select 3
union  all
select 1
union all
select 2
union all
select 3

select min(PK) from #b1 where refid in (select distinct refid from #b1)group by refid

select min(PK),Trans.ID from FEE 
group by Trans.ID

select TransId, min(PK) from FEE group by TransId