When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers are there, and what is the work of that four types of SQL servers. when we have to use that server. let's see what are they:-Database EngineAnalysis ServicesReporting ServicesIntegration...

SQL SERVER TYPE IN SSMS In SQL server,server is a also called services why because every services act like server.there are some type of SQL server. 1.Server type SSAS, SSRS , SSIS tools we called as a MSBI Tools to intreat with MSBI tool we need a developing tool that developing tool is a BIBS. 2.Business Intelligence...

SQL JOIN:- SQL join and type of join  SQL join clause is used to combine rows from the two or more tables or joins in SQL are used to retrieve data from two or more related tables.In general tables are related to each other using foreign key constraint. In SQL there are different types of joins Inner...

Date and Time format in SQL In SQL we have date and time format to show the date and time format in different ways lets see what are the date and time formats are there.                                          ...

Find nth highest salary without using top in SQL                                                      1.Find nth highest salary without using top sql          ...

                                                     1.how to find nth highest salary| max salary                        ...

                                                         1.SQL Language Element SQL Language Element Identifiers                ...