SQL SUBSTRING()


SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.

 66 total views

Read More...

SQL DATALENGTH Function


SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.

 76 total views,  4 views today

Read More...

SQL Server RTRIM()


SQL Server RTRIM() function is used to trim trailing characters from a character string.

 64 total views,  2 views today

Read More...

SQL Server LTRIM()


SQL Server LTRIM() function is used to trim leading characters from a character string.

 61 total views,  1 views today

Read More...

SQL SERVER REPLACE


SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .

 83 total views,  1 views today

Read More...

SQL LOWER()


SQL LOWER() function converts all the characters in a string into lowercase.

 52 total views

Read More...

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.

 49 total views,  2 views today

Read More...

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.

 419 total views,  2 views today

Read More...

SQL Server DELETE


SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.

 94 total views

Read More...

SQL SERVER INSERT


SQL insert statement is used to insert a new records in table.

 125 total views

Read More...

SQL SERVER UPDATE


SQL UPDATE Statement is used to modify an existing
records in table .

 176 total views,  4 views today

Read More...

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.

 122 total views

Read More...

Primary Key VS Composite Key ?


A PRIMARY KEY constraint uniquely identifies each record in a table .

A COMPOSITE KEY is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.

 1,208 total views,  9 views today

Read More...

SQL DROP TABLE


SQL DROP TABLE statement is used to delete the table from database.

 177 total views,  4 views today

Read More...

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.

 366 total views,  1 views today

Read More...

SQL CREATE TABLE


SQL CREATE TABLE statement is used to create a new table in a database.

 312 total views

Read More...

SQL SELECT INTO SELECT


SQL SELECT INTO statement copies data from one table into new table.

 202 total views

Read More...

SQL INSERT INTO SELECT


SQL INSERT INTO SELECT statement selects data from one table and insert it into another table.

 186 total views

Read More...

SQL SERVER DISTINCT


SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.

 68 total views,  1 views today

Read More...

SQL Server SELECT


SQL server SELECT Statement is used to fetch the data from any table .

 140 total views

Read More...