Posts by Lário Diniz • 126 points
8 posts
-
0
votes1
answer456
viewsA: Create dynamic table of the result of an exec return with Sql server variable
Place the following command inside the @QUERY string: SELECT * INTO [TABELANOVA] FROM (SEU SELECT)A
-
1
votes1
answer1371
viewsA: decimals of a variable Numeric field depending on CASE in SQL
Good morning. A friend here at work arrived at a "solution", converting the field to varchar(MAX) Follow answer to help others: DECLARE @VALOR DECIMAL(18,2), @PORCENTOJUROS DECIMAL(18,2), @CODJUROS…
-
2
votes1
answer1371
viewsQ: decimals of a variable Numeric field depending on CASE in SQL
I have a query where, depending on a parameter, I need the result in a field to be 5 decimal places or 2 decimal places, this is possible in SQLSERVER 2008? Example DECLARE @VALOR DECIMAL(18,2),…
-
1
votes1
answer1383
viewsA: How to perform only 1 specific table Restore in SQL Server 2012
You can make an insert from one bank to the other by creating the table in the production bank in this process. IF NOT EXISTS(SELECT * FROM [Producao]..SysObjects WHERE Name LIKE 'complemento')…
-
0
votes3
answers667
viewsA: Create objects in Runtime faster
Use the "Application.Processmessages" at some points in your code. More information:…
-
2
votes2
answers873
viewsA: Doubt about query in Delphi 7
Error occurred because your query has no quotes in the text fields. There are a few ways to quote a string in Delphi: Function Quotedstr('string'): ShowMessage(QuotedStr('teste')); Use three single…
-
1
votes2
answers2456
viewsA: Download events Onkeydown and Onexit
When you press the Enter key on Edit, your Keydown precedent perform a number of things and at the end "arrow" the focus on another component, when this occurs, the Onexit Precedent is called and in…
-
4
votes2
answers7126
viewsA: How to create an executable for a python program that installs the used libraries?
You can also use the cx_freeze to "package" your program and generate an executable. A friend and I created a graphic version for the compiler using the library a while ago Tkinter, that you can…
pythonanswered Lário Diniz 126