Knowledge Hub

 

SQL Server Tips: SQL CRUD

SQL Server Tips: SQL CRUD

CRUD? Create Read Update Delete – CRUD. This term refers to the four general actions that can be taken when it comes to data. This is a global term and does not just apply to databases (although it will be databases where you hear it the most). In SQL we use the INSERT command for creating data, SELECT to read, UPDATE to update and DELETE to delete.

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

When it comes to retrieving data from your tables, indexes play a fundamental role in finding that data you require and finding it fast. Pretty much every table you create will have an index of one type or another; whether it is a regular index, a primary key or a foreign key.

SQL Server Tips: Tables and Columns

SQL Server Tips: Tables and Columns

A database is made up primarily of tables, a table is made up of columns and rows and each row contains data for each column. When creating or modifying your database structure there are a few things that may save you time.

Navigation

Social Media