SQL SUBSTRING()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
Home » SQL SERVER » SQL Basics »
SQL Basics
SQL Server Basics Concepts includes SQL Database Creation, Tables, SQL DML , and DDL Commands, Joins, Key Constraints, Functions and so on..
SQL DATALENGTH Function
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
SQL Server RTRIM()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
SQL Server LTRIM()
SQL Server LTRIM() function is used to trim leading characters from a character string.
SQL SERVER REPLACE
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
SQL LEN()
SQL LEN() function is used to count the number or length of character in given string. It returns integer value always and null for empty string.
SQL EOMONTH()
SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.
SQL Server DELETE
SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.
SQL TRUNCATE TABLE
SQL TRUNCATEÂ TABLE statement is used to delete complete data from an existing table. It is similar to a delete statement without a WHERE clause.
SQL ALTER TABLE
SQL ALTER TABLE  statement is used to modify the data type of a column , add a new column ,delete an old column from table and add a new constraints and remove an existing constraints on table.
SQL INSERT INTO SELECT
SQL INSERT INTO SELECT statement selects data from one table and insert it into another table.
SQL SERVER DISTINCT
SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.
- « Previous
- 1
- …
- 4
- 5
- 6