Viewing 8 posts - 1 through 8 (of 8 total)
hi phil, there is no error message, the wrong file ends in file stream directory and the trigger is somehow executed or not. i can see it only, because i...
October 2, 2024 at 10:15 am
--here the code:
CREATE OR ALTER TRIGGER [dbo].[tri_SAPA_UPDATE]
ON [dbo].[tbl_SAPA]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
DECLARE @AnzahlZeichenKopfzeile INT = 393;
DECLARE @Text NVARCHAR(MAX);
SELECT
@Text = CONVERT(VARCHAR(MAX), [Inserted].[file_stream])
FROM
[Inserted];
SET @Text = REPLACE(@Text, CHAR(13) + CHAR(10), '');
SET @Text = REPLACE(REPLACE(@Text,...
October 2, 2024 at 9:48 am
thanks, thats what i am looking for
November 17, 2016 at 9:39 am
hi ed, here the ddl, i want to recieve orderno 100 for article 2 as youngest order:
USE testDB
USE [testDB]
GO
/****** Object: Table [dbo].[Table_1] Script Date: 17.11.16 09:43:10...
November 17, 2016 at 1:48 am
you are right :-((( i just tested it once, when i save elsewhere it changes. so no solution so far, thanks anyway
November 15, 2016 at 1:32 am
Hi Thom~,
thanks again, i found it meanwhile. There is a registry entry called DefaultFileOpenLocation under HKCU. I wonder why you could not set up those settings in the application.
November 14, 2016 at 10:10 am
Hi Thom~, thanks, it worked now for STR + S (saving) a script, STR + O still goes to Desktop, but i could not find the word desktop in...
November 14, 2016 at 9:14 am
hi steve, i tried this, but its changing the path for opening projects. as i mentioned above, looking for changing the path for scripts, when you edit a script in...
November 14, 2016 at 1:49 am
Viewing 8 posts - 1 through 8 (of 8 total)