We can add a column to the table in two ways. First is using sql server management studio graphical interface. Second one is using SQL command ADD COLUMN. T-SQL ADD COLUMN Syntax: ALTER TABLE dbo.Table ADD <Column> <Data Type> NULL (or) NOT NULL Column will be created on the end of the table. If the… Read More »
UPDATE Statement is used in SQL to change existing records in a table. This way, we can change one record, multiple records or all of them. Condition based on which are records restricted is placed in WHERE clause. Syntaxe – 3 Ways of UPDATE Usage A) Simple form: Change of the values in certain column… Read More »
SELECT clause is used to gain data from a table. This clause is followed by a list of columns, which we need to display. SELECT must always be used in combination with clause FROM by which we state from which table we want the data to be selected. Ideally, we also add clause WHERE which… Read More »
SELECT DISTINCT is a command used to show unique records in a table. Its use is broad but it is mainly used to remove duplicities in the records when taking multiple views on data. Hint: If we select more than 1 column, DISTINCT will return unique combinations of selected columns SELECT DISTINCT Syntax Syntax is… Read More »