SQL Server Management Studio (SSMS)
a) Open SSMS (SQL server management studio)
b) Select server type in the following
-
Database engineàTo connect and work with normal database.
-
Integration service à To and work with normal database.
-
Analysis service àTo connect and work with analysis service database.
-
Reporting servicesà To connect and work reporting services databases.
-
SQL server compact EditionàTo connect and work with mobile applications.
Subscribe to our youtube channel to get new updates..!
c) Server name –> Either IP Address (or) actual server name.
d) Select authentication –>
i) Window authentication –> Consider window credentials to logon
ii) SQL server Authentication –> Server database credentials.
Note: Select the option: ii)for the real time work process.
e) Click connect…. Next…
Creating databases –> Right click on database
New database window
Database Name: DMNEW
–> Click ok
Creating tables –> DBNe3wq –> Tables –> Right click–> Select ‘new tables’
Column Name Data Type
PARTY ID Int
PARTY NAME VARCHAR (50)
–> Next save the table with a specified Name i.e, PARTY
–> Click OK.
Adding data to the tables of the database
–> Right click on TABLE –> Select the option “edit top 200 rows”.
PARTY ID PARTY NAME
1 x
2 VINAY
Firing Queries on database
-
Go to database(i.e DBNEW)
-
Right click à select new query
-
SELECT* FROM PAETY;
-
Click Execute (or) press “f5”
-
Insert into party values(3,’Mathu’, ‘Hyd’, 5000)
-
Update party set party ID=20 where party ID=222.
Frequently Asked SSIS Interview Questions & Answers
Connecting to the other database
Two ways:
i) By Specifying –> ..
List of Related Microsoft Certification Courses:
SSRS | Power BI |
SSAS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |