Kod Kütüphanem ama elime ne gelirse burada dursun diye…

Menu

SQL ve XML

T SQL by modestus 
DECLARE @XML XML='<IDLIST><ID VALUE="00000000-0000-0000-0000-000000000000"/></IDLIST>'

DECLARE @docHandle INT
CREATE TABLE #tmp
(
ID UNIQUEIDENTIFIER 
)
EXEC sp_xml_preparedocument @docHandle OUTPUT, @XML

INSERT INTO #tmp
SELECT  *
FROM OPENXML (@docHandle, '/IDLIST/ID', 1) WITH(VALUE UNIQUEIDENTIFIER)
EXEC sp_xml_removedocument @docHandle

 

modestus

modestus

Related articles

STUFF ile istenilen alana ait değerleri “,” ile bir araya getirme

T SQL by modestus

SELECT T2.FieldSomething, STUFF(( SELECT ‘,’ T1.Field FROM Table1 T1 WHERE T1.IDField =T2.IDField ORDER BY T1.Field FOR XML PATH(”) ), 1, 1, ”) AS FieldName FROM Table2 T2  

Learn More

Truncate Table Foreign Key varken

T SQL by modestus

DECLARE @TableName NVARCHAR(128)=’TabloAdi’ BEGIN TRAN DECLARE @NextId NUMERIC = CASE WHEN (IDENT_CURRENT(@TableName) = 1) THEN 1 ELSE 0 END DECLARE @Sql NVARCHAR(MAX) = ‘DELETE FROM [‘ + @TableName + ‘]’ EXECUTE sp_executesql @Sql IF (@@ERROR = 0) BEGIN DBCC CHECKIDENT (@TableName, RESEED, @NextId) COMMIT TRAN END ELSE BEGIN ROLLBACK END     Kaynak: Eduardo Cuomo

Learn More

Group by Day – Örnekleri ile

T SQL by modestus

Grouping By Day Of month: In order to group the data by day you can use sql server in built DAY() funtion. Grouping By Day Of week: For this you can use DATEPART(weekday,[date column]) Grouping By week: For this you can use DATEPART(week,[date column]) Grouping By DAY of Year: For this you can use DATEPART(dayofyear,[date […]

Learn More

Bir yanıt yazın

E-posta adresiniz yayınlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Close Menu