Posts by Marc.Adans • 190 points
6 posts
-
0
votes2
answers365
viewsA: Convert Header C/C++ to Delphi
Menu Project->Import Type library Puts the dll there that it generates a *_TBL.pas file She must be a COM object+
-
1
votes3
answers162
viewsA: Create tables randomly
I think that’s what you expect. DECLARE @nQtdeGrupo INT = 5 SELECT cNome , iGrupo FROM (SELECT cNome = PESSOAS.NOME , iGrupo = (ROW_NUMBER() OVER(ORDER BY NEWID() DESC) % @nQtdeGrupo) + 1 FROM…
-
-2
votes2
answers315
viewsA: Insert error with Adocommand
The reserved word INTO is not missing? Insert into table (a,b,c) INTO (1,1,1)
-
11
votes2
answers40729
viewsA: Difference between CROSS APPLY and OUTER APPLY?
To summarize: CROSS APPLY - Similar to INNER JOIN OUTER APPLY - Similar to LEFT JOIN You can use the fields of the other tables referenced in Where, Functions, Use Top.
-
1
votes2
answers1405
viewsA: Best way to add multiple order items to a table
Use Table Value Constructor, for SQL-Server 2008 or higher http://technet.microsoft.com/en-us/library/dd776382.aspx INSERT INTO TB_PEDIDOS (QTD, PRECO, ...) SELECT QTD, PRECO--, ... FROM ( VALUES…
-
4
votes5
answers36671
viewsA: How to get the total character size of an SQL column?
Make a query in the following tables: sys.types sys.all_columns Follow the consultation SELECT cNmColuna = C.name ,cTpColuna = UPPER(TYPE_NAME(C.user_type_id)) ,iMaxDigit = CASE WHEN T.precision = 0…