http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 17 Apr 2026 18:32:29 +0000 Thu, 15 Jan 2015 14:51:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=3966 http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ http://www.erpne.org/dbo-yilay_topic3966_post21088.html#21088 Yazar: Conari
Konu: 3966
Gönderim Zamanı: 15 Ocak 2015 Saat 14:51

Son Dbupdate dosylarynda RECETEGETIR fonksiyonu scripti de bozulmu? bilginize, Eski dbupdate dosyalaryndan bulup create ettim.]]> Thu, 15 Jan 2015 14:51:48 +0000 http://www.erpne.org/dbo-yilay_topic3966_post21088.html#21088 http://www.erpne.org/dbo-yilay_topic3966_post21085.html#21085 Yazar: Conari
Konu: 3966
Gönderim Zamanı: 15 Ocak 2015 Saat 13:47

Eyvallah.]]> Thu, 15 Jan 2015 13:47:56 +0000 http://www.erpne.org/dbo-yilay_topic3966_post21085.html#21085 http://www.erpne.org/dbo-yilay_topic3966_post21081.html#21081 Yazar: rhan
Konu: 3966
Gönderim Zamanı: 15 Ocak 2015 Saat 13:31

GO

CREATE FUNCTION [dbo].[YILAY] (@YIL INT, @AY INT) RETURNS VARCHAR(6)
WITH SCHEMABINDING
AS
BEGIN
  RETURN (CAST(@YIL AS VARCHAR(6))+
          CASE WHEN @AY<10 THEN '0'+CAST(@AY AS VARCHAR(6)) ELSE CAST(@AY AS VARCHAR(6)) END)
END

GO

]]> Thu, 15 Jan 2015 13:31:59 +0000 http://www.erpne.org/dbo-yilay_topic3966_post21081.html#21081 http://www.erpne.org/dbo-yilay_topic3966_post21080.html#21080 Yazar: Conari
Konu: 3966
Gönderim Zamanı: 15 Ocak 2015 Saat 13:28

dbupte bu ?ekilde bir fonk. aryyor
elinde olan varmy PER dbsi.]]> Thu, 15 Jan 2015 13:28:11 +0000 http://www.erpne.org/dbo-yilay_topic3966_post21080.html#21080