SQL CHARINDEX()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
![]()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
![]()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
![]()
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
![]()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
![]()
SQL Server LTRIM() function is used to trim leading characters from a character string.
![]()
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
![]()
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() function is a date function , it returns the last day of the month of a specified date, with an optional offset.
![]()
SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.
![]()
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 statement selects data from one table and insert it into another table.
![]()