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...
Wednesday, April 28, 2021
undefined
202
Tuesday, April 28, 2020
undefined
202
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...
Monday, February 17, 2020
undefined
202
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...
Friday, January 17, 2020
undefined
202
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.
...
Monday, January 13, 2020
undefined
202
Find nth highest salary without using top in SQL
1.Find nth highest salary without using top sql
...
undefined
202
1.how to find nth highest salary| max salary
...
Friday, January 10, 2020
undefined
202
1.SQL Language Element
SQL Language Element
Identifiers
...
SEVER TYPE IN SSMS ( Sql Server Managment studio)
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 ...
-
1.how to find nth highest salary| max salary ...
-
Find nth highest salary without using top in SQL 1. Find nth highest salary witho...
-
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...