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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy