SQL DATEADD()


SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.

 65 total views

Read More...

SQL TRIM()


SQL Server 2017 has released a new TRIM() function that is used to remove both Leading and Trailing spaces from any given string.

 381 total views

Read More...

SQL UPPER()


SQL UPPER() function converts all the characters in a string into uppercase.

 101 total views,  1 views today

Read More...

SQL CURRENT_TIMESTAMP


SQL CURRENT_TIMESTAMP function returns the current date and time .

 85 total views

Read More...

SQL GETDATE()


SQL  GETDATE() function returns the current date and time.

 92 total views

Read More...

SQL CHARINDEX()


SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.

 148 total views

Read More...

SQL SUBSTRING()


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

 129 total views

Read More...

SQL DATALENGTH Function


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

 145 total views,  1 views today

Read More...

SQL Server RTRIM()


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

 125 total views,  1 views today

Read More...

SQL Server LTRIM()


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

 106 total views

Read More...

SQL SERVER REPLACE


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

 131 total views

Read More...

SQL LOWER()


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

 84 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.

 81 total views

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.

 647 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.

 164 total views

Read More...

SQL SERVER INSERT


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

 191 total views,  2 views today

Read More...

SQL SERVER UPDATE


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

 272 total views,  1 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.

 202 total views,  1 views today

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.

 2,118 total views,  8 views today

Read More...

SQL DROP TABLE


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

 278 total views,  1 views today

Read More...