Posts by Leonardo Palmieri • 71 points
13 posts
-
0
votes1
answer113
viewsQ: store select result in a table
Good afternoon I have the following query SELECT +cast((DATEDIFF(SECOND,r.start_time,GETDATE())/60)%60 as varchar)+'m ' duracao ,isnull(s.login_name, s.original_login_name) AS LOGIN ,r.session_id…
-
-1
votes1
answer43
viewsQ: Conversion of Procedures
Does anyone know or know an easy but easy way to migrate stored-procedures from SQL-Server to Oracle.
-
0
votes1
answer57
viewsQ: UPDATE IN MYSQL
I have an encrypted field in the MYSQL database. I’m trying to update this way UPDATE USUARIOS SET SENHA = md5(1234) WHERE ID = 216; but give me this error message: Error Code: 1406. Data Too long…
mysqlasked Leonardo Palmieri 71 -
0
votes1
answer70
viewsQ: ORACLE USERS
Good afternoon. I have two Owners on my oracle example Owner "X" and other Owner "Y". Where each has its own tables, but I want Owner "X" to be able to update, Insert and delete some Owner "Y"…
-
0
votes3
answers157
viewsA: Show comments table
Below is the script I made and returned: select ob.name,ep.value from sys.extended_properties ep inner join sys.objects ob ON ep.major_id=ob.OBJECT_ID AND class=1 where minor_id = 0 and ob.name not…
-
1
votes3
answers157
viewsQ: Show comments table
Good morning guys, I wonder if it is possible to list in SQL-SERVER all comments of my "table", not comments of the column, but only of the "tables""
-
3
votes1
answer398
viewsQ: User permissions
I’m having a hard time configuring a user’s permissions in sql server: Today I have a user who is currently the db_owner, I want to take this access from him, but I need this user to have full…
sql-serverasked Leonardo Palmieri 71 -
-2
votes1
answer29
viewsQ: Erasing OBJECT_TYPE from Oracle
Good afternoon. How do I pay for an OBJECT_TYPE from my OWNER? need to delete this object_type, because it is giving SYNON error
oracleasked Leonardo Palmieri 71 -
0
votes0
answers338
viewsQ: Join querys using Outer apply
I have these three querys, and I want to put them together using the outer apply. How can I do that? SELECT SR1.COMPANY, SR1.FILIAL, SR1.DOC, SR1.SERIE, SR1.LOCAL, SR1.TIPONF, SR1.CLIFOR,…
-
1
votes1
answer1350
viewsQ: Error "No column name was specified"
Could someone please let me know why you made that mistake? "Msg 8155, Level 16, State 2, Line 26 No column name was specified for column 1 of 'A'. Msg 8155, Level 16, State 2, Line 42 No column…
-
0
votes1
answer114
viewsQ: Optimization of SQL-SERVER query
I need to get the field EMISSION_DATE of TLX_VENDA and the countryside B9_DATA table TLX_ESTOQUE_INI, but I need to do this within the OUTER APPLY. I managed to get the result but it’s too slow.…
sql-serverasked Leonardo Palmieri 71 -
-1
votes1
answer33
viewsQ: Date choices
Good afternoon, you guys, I’m looking to make a iif in sql that if the field FLAG is equal to "And" it brings the date of the column DTDIGIT and store in variable @dataInicio, and when the FLAG for…
sql-serverasked Leonardo Palmieri 71 -
1
votes2
answers162
viewsQ: Previous dates
I am making report in which I need to always get the date of customer registration in a previous month. Example: I am in the month of December 2017, I want to pick up customers who were registered…