SQL Server
This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
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.
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.
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.
- « Previous
- 1
- …
- 10
- 11
- 12