We can use Cross Join with WHERE clause and Without WHERE clause, When we use the Cross Join without WHERE clause,produces the Cartesian results from the tables. The resultset contains records that are multiplication of record number from both the tables.
SQL server installation create some system databases automatically, you can see these database in your SQL server management studio:
COALESCE function returns the first nonnull expression among its arguments. you can use the COALESCE function like as:
SQL Server 2008 was released in August of 2008. SQL Server 2008 was basically a part of a joint launch of Windows Server 2008 and Visual Studio 2008. In SQL Server 2008, there are a number on enhancements and new features added by Microsoft, here is a list of some of the new features … Continue reading What’s new in SQL Server 2008
Microsoft SQL Server is a relational database management system developed by Microsoft. SQL Server 2005 was released in October 2005. It is the successor of the Microsoft SQL Server 2000.
You can use some alias for table in the select query for better readability of the query, Aliases of the table are very useful when you are using complex query with multiple lines. Aliases of the tables in the Sql server are also called as a correlation name or range variable.
Joins are used to extract information from more than one table based on the related column/columns means you can retrieve data from two or more tables based on logical relationships between the tables.
Update statement is different from INSERT and DELETE statements.UPDATE statements is used for updating a single records to multiple records. UPDATE statements use a WHERE clause, same as SELECT statement.
IN operator we use when we Determines whether a specified value matches any value in a sub query or a list. The IN operator allows you to specify multiple values in a WHERE clause.it also helps reduce the need to use multiple OR conditions.
DATEPART() function returns a value equal to the part of a specified date. Summery DATEPART(datepart, date) where date is the valid date or a string in date format and datepart can be one of the following: datepart Abbreviation year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week … Continue reading DATEPART() function in SQL Server