Tutorial by Examples: ble
INSERT INTO [dbo].[Customers]
([CustomerName])
VALUES
('Jerry'),
('Gorge')
SELECT * FROM [dbo].[Customers]
Results
CustomerIDCustomerName10001Jerry10002Gorge
Will be available till the current connection persists for the user.
Automatically deleted when the user disconnects.
The name should start with # (#temp)
CREATE TABLE #LocalTempTable(
StudentID int,
StudentName varchar(50),
Student...
Will start with ## (##temp).
Will be deleted only if user disconnects all connections.
It behaves like a permanent table.
CREATE TABLE ##NewGlobalTempTable(
StudentID int,
StudentName varchar(50),
StudentAddress varchar(150))
Insert ...
Depending on the structure of your data, you can create variables that update dynamically.
DECLARE @CurrentID int = (SELECT TOP 1 ID FROM Table ORDER BY CreateDate desc)
DECLARE @Year int = 2014
DECLARE @CurrentID int = (SELECT ID FROM Table WHERE Year = @Year)
In most cases, you will want...
Creating a temporal table with a default history table is a convenient option when you want to control naming and still rely on system to create history table with default configuration. In the example below, a new system-versioned memory-optimized temporal table linked to a new disk-based history t...
By default, LESS will use its own calc() unless told otherwise. So:
@column-count: 2;
.class-example {
width: calc(100% / @column-count);
}
Would compile to this:
.class-example {
width: 50%;
}
While it is our desired width, LESS has used it's own calc() function to calculate ...
set var=10
set /a var=%var%+10
echo %var%
The final value of var is 20.
The second line is not working within a command block used for example on an IF condition or on a FOR loop as delayed expansion would be needed instead of standard environment variable expansion.
Here is another, better w...
FOREIGN KEY constraint can be added on existing tables that are still not in relationship. Imagine that we have Company and Employee tables where Employee table CompanyId column but don't have foreign key relationship.
ALTER TABLE statement enables you to add foreign key constraint on an existing c...
FOREIGN KEY columns with constraint can be added on existing tables that are still not in relationship. Imagine that we have Company and Employee tables where Employee table don't have CompanyId column.
ALTER TABLE statement enables you to add new column with foreign key constraint that references ...
Create a set
local set = {} -- empty set
Create a set with elements by setting their value to true:
local set = {pear=true, plum=true}
-- or initialize by adding the value of a variable:
local fruit = 'orange'
local other_set = {[fruit] = true} -- adds 'orange'
Add a member to the ...
string[] portNames = SerialPort.GetPortNames();
Enable and upgrade setup
php bin/magento module:enable YKM_Custom
php bin/magento setup:upgrade
Disable the Module
php bin/magento module:disable YKM_Custom
Another One - module uninstall script is executed and whole module gets deleted afterwards. Only modules installed through Composer ca...
