- NULL value in SQL
NULL in SQL is the term used to represent a missing value. - Create a temporary name using ALIAS in SQL
SQL ALIAS is used to create a temporary name (called an alias) for a column or table. - Index (INDEX) in SQL
SQL index (INDEX) is a special lookup table that database search engines can use to quickly increase the time and performance of data retrieval. - ALTER TABLE statement in SQL
The ALTER TABLE statement in SQL is used to add, delete, and modify columns in an existing table. - Adjust performance in SQL Server: find slow queries
Adjusting SQL performance is a never-ending battle. This article will provide some tips for you to find slow SQL queries and perform performance tuning in SQL Server. - Use code to quickly create T-SQL scripts in SQL Operations Studio (preview)
The code in SQL Operations Studio (preview) is the template that makes it easier to create databases and database objects. - Manage servers and databases with detailed utilities in SQL Operations Studio (preview)
Detailed utilities retrieve the Transact-SQL (T-SQL) queries you use to monitor servers and databases, then turn them into visual images. - UPDATE command in SQL
UPDATE is the query used to edit existing records in the table. You can use the WHERE clause with the UPDATE statement to update selected rows, if not all rows in the table are - Boolean operators AND and OR in SQL
The AND and OR operators are used to combine multiple conditions to narrow the data in SQL statements. These two operators are called conjugate operators in SQL. AND and OR allow