|
Programming is thinking, not typing |
|
According to specification, "...constructor is a special non-static member function of a class that is used to initialize objects of its class type". In addition to basic concepts, C++11 introduces move constructors, initializer list type and brace-enclosed lists of comma-separated initializers.
However the impact of introducing new constructors combining …
Update. Since the version 2016 SQL Server supports anonymous constraint declaration:
CREATE TABLE #temp_table (
id1 int NOT NULL,
id2 int NOT NULL,
name1 nvarchar(100),
name2 nvarchar(100),
PRIMARY KEY (id1, id2),
UNIQUE (name1, name2)
);
For earlier versions the solution is below.
Local temporary tables are isolated in the scope …
In the case of linked circular list you need to add some checks to avoid memory corruption.
Full example (compiled OK with GCC 8.x)
#include <iostream>
#include <cstdlib>
struct Node
{
Node(Node* prev, int val)
: prev(prev), next(NULL), value(val)
{ }
Node *prev, *next;
int value;
};
void clear_list(Node …Unfortunately, SQL Server doesn't have a function like frac to extract the fractional part of number. The method is to subtract the integer part from the origin value.
DECLARE @n1 float, @n2 float, @n3 float;
SELECT @n1 = 123.456, @n2 = 234.567, @n3 = 456.789;
SELECT @n1 - round(@n1, 0 …Collection of methods to generate random string in a single SQL statement
On SQL Server the method is limited by 100 characters because of CTE recursion level limitation. The method has the performance issues when using in loops/joins because the table always have 100 rows …
This small example shows how to synchronize the data of two tables using the MERGE statement
CREATE TABLE table1 (id int NOT NULL PRIMARY KEY, str_value nvarchar(50));
CREATE TABLE table2 (id int NOT NULL PRIMARY KEY, str_value nvarchar(50));
GO
INSERT INTO table1 (id, str_value) VALUES (1, 'Value 1 …Notepad++ can count LOC (lines of code) of source files and give you the estimation of code size.
Press Ctrl+Shift+F shortcut to start "Find in files" dialog. Select "regular expression" search mode and start it.
Some regular expressions:
\S+\s*$ -- all non-empty lines^\s*$ -- only empty (white-space) lines …Delphi supports interfaces natively. Any variable of variant type can store an interface like any allowed data types.
program IntfDelphi;
{$APPTYPE CONSOLE}
{$R *.res}
uses
Classes, SysUtils, Variants;
type
ITest = interface(IInterface)
['{BEDC5E17-2C40-4F7C-8C78-34448F5CE146}']
procedure Foo(const Msg: string);
end;
TestImpl = class(TInterfacedObject, ITest)
public
procedure Foo(const Msg …I use C++Builder 10.1 (Berlin) that proposes both 'classic' bcc32 compiler and new clang bcc32c. Whether do you rather to use classic compiler or to switch to clang? The answer is not quite simple.
The advantages of new clang compiler:
This article is used in my book "Programming with databases".
Better to see once than to hear a hundred times. This small article explains what are the different kinds of joins in SQL.
At the first time you should take into account that SQL is a declarative 4th generation language …