View original (French)

Line break pl/sql

fidjy5 Posted messages 10 Status Member -  
fidjy5 Posted messages 10 Status Member -
Hello,
I am working on a script where I need to insert a database if it does not exist as well as other elements, and I cannot add a trigger on this table..

Here is the header of the code:
trigg="IF OBJECT_ID('stat_temp_"&schema&"') IS NOT NULL EXECUTE 'CREATE TRIGGER [verif_"&schema&"] ON [dbo].[stat_temp_"&schema&"] "
trigg=trigg&"AFTER INSERT AS "&vbCrLf&" DECLARE @cpt int;"&vbCrLf&" DECLARE @good int;"&vbCrLf&" DECLARE @tiers int;"
trigg=trigg&"SELECT @good=count(*) from stat_goods where code_good=(select code_good from inserted)"
trigg=trigg&" IF @good=0"
trigg=trigg&" begin"
......

So every time I concatenate, but it causes a problem that under SQL Server 2003 I cannot find the carriage return/new line symbol.. 
Configuration: Windows 2003 Firefox 2.0.0.14

2 answers

  1.
    Mimiste Posted messages 1159 Status Member 206
     
    ```html Pour le retour a la ligne normalement il faut que tu concatène le caractère 13 et 10 donc a la fin d'une ligne t'ajoute

    CHAR(13) & CHAR(10)

    --
    La sportivité commence là où le diesel s'arrête !
    You can still watch this? Wait until the VTEC kicks in! ```
    1
    1. fidjy5 Posted messages 10 Status Member
       
      Well, if I do something like
      trigg="IF OBJECT_ID('stat_temp_"&schema&"') IS NOT NULL EXECUTE 'CREATE TRIGGER [verif_"&schema&"] ON [dbo].[stat_temp_"&schema&"] "
      trigg=trigg&"AFTER INSERT AS CHAR(13) & CHAR(10) DECLARE @cpt int;"&vbCrLf&" DECLARE @good int;"&vbCrLf&" DECLARE @tiers int;"&vbCrLf
      trigg=trigg&"SELECT @good=count(*) from stat_goods where code_good=(select code_good from inserted)"
      trigg=trigg&" IF @good=0"

      to test this, it does not give me any line breaks.
      0