Posts by Robson Braz • 91 points
4 posts
-
6
votes1
answer1038
viewsQ: Couldn’t perform the Edit because Another user changed the record
Does anyone know if there is any trace of a table that is dropped from a bank? To make it easier if it’s recreated, for example, and when I say vestige is in the bowels of the bank itself. I’m going…
-
0
votes1
answer141
viewsQ: SP_HELPTEXT without formatting
When a Trigger is compiled by TOAD for SQL, using the F9 button and not F5, it is inserted into syscomments with wrong formatting, as if it were a single line, where line breaks are disregarded. The…
-
2
votes1
answer598
viewsA: How to select a String in column format? SQL SERVER
I adapted a function I found personal, thanks for the help. create FUNCTION Split(@String varchar(MAX), @Delimiter char(1)) returns @temptable TABLE (items varchar(MAX)) as begin declare @idx int…
-
1
votes1
answer598
viewsQ: How to select a String in column format? SQL SERVER
I have a field STATUS in a table with the following data: VENDA,COMPRA,DEV.VENDA I need to make a query in this field that the result is a column, where each row will be one of the strings between…