Unix and Linux
SQL Server
SQL
Python
Programming C
PHP
NodeJS
MongoDB
jQuery
JavaScript
HTTP
HTML
Git
Database
Data structure and algorithm
CSS and CSS3
C ++
C #
AngularJS
25 May 2019
The CREATE USER command in SQL Server
This article will show you in detail how to use the CREATE USER command in SQL Server, with specific syntax and examples to better visualize and capture commands.
Program - Page 65
Learn basic programming with C, C++, Python, JavaScript, PHP, CSS, HTML5 programming languages. You can also find tutorials on databases, SQL Server here.
25 May 2019
Instructions for installing SQL Server 2017 step by step
SQL Server 2017 comes with new features in the installation process. It now supports the Machine Learning Service for R and Python. It also includes SSIS Scale Out Master and
25 May 2019
DROP USER command in SQL Server
This article will show you in detail how to use the DROP USER command in SQL Server with specific syntax and examples to better visualize and capture commands.
25 May 2019
Use annotations in SQL Server
This article will show you how to use annotations in SQL Server statements.
25 May 2019
LITERAL in SQL Server
The article details how to use Literal - Hang (strings, integers, decimals, and datetime values) in SQL Server.
25 May 2019
Declare variables in SQL Server
SQL Server fully exists the concepts of data types, variables and declarations of variables as other programming languages. The article will learn how to declare a variable,
25 May 2019
SEQUENCE in SQL Server
Sequence is often used in databases because it is necessary for many applications. The article will provide syntax and examples of how to create and delete the sequence and its
25 May 2019
FUNCTION (Function) in SQL Server
The function in SQL Server is stored in the database so you can pass the parameters as well as return the values. The article will give you the syntax and examples of how to
25 May 2019
PROCEDURE (Procedure) in SQL Server
Procedure is a program in the database that contains many statements that you save for later use but have different points from Function. The article will give you the syntax and
25 May 2019
INTERSECT operator in SQL Server
In SQL Server (Transact-SQL), INTERSECT operator is used to return records in both data sets or SELECT statements.
25 May 2019
EXCEPT operator in SQL Server
The EXCEPT operator in SQL Server is used to return the rows in the first SELECT statement that are not returned in the second SELECT statement.
25 May 2019
Query SUBQUERY child in SQL Server
The following article will show you how to use sub-queries in SQL Server along with syntax and examples.
25 May 2019
PIVOT clause in SQL Server
In SQL Server (Transact-SQL), the PIVOT clause allows cross tabulation to pass data from one table to another.
25 May 2019
Data types in SQL Server
Below are the data types (data types) in SQL Server, including character strings, numbers and times / dates.
25 May 2019
CREATE TABLE command in SQL Server
In SQL Server (Transact-SQL), the CREATE TABLE statement is used to create and define tables.
25 May 2019
Primary key PRIMARY KEY in SQL Server
Learn how to create, delete, disable or enable primary keys in SQL Server with syntax and examples.
25 May 2019
ALTER TABLE statement in SQL Server
In SQL Server, the ALTER TABLE statement is used to add columns, edit columns, delete columns, rename columns or rename tables.
25 May 2019
DROP TABLE command in SQL Server
In SQL Server, the DROP TABLE command is used to delete a table from the database.
25 May 2019
VIEW in SQL Server
The article explains how to create, update and delete VIEW in SQL Server with syntax and examples.