T-SQL-and-SQL-Server

Bu script sizga Mock DataBase yasab beradi. Bu orqali siz T-SQL buyuruqlarini test qilib o'rganishingiz va tushunishingiz oson bo'ldi.

1 - qadam : SQL Server ni express editon nini o'rnatasiz.
2 - qadam : SQL Server Management Studio (SSMS) ni o'rnatasiz .
3 - qadam : (SSMS) da Menu lar qatorinig 2-qatorida [New Query] tugmasini bosasiz va sizga yozish oynasi ochiladi.
4 - qadam : Ushbu Script ni yozasiz.
5 - qadam : [Execute] tugmasini oldida Databeselar tanlaydigan joy bor shu yerdan [master] database ni tanlaysiz va [Execute] tugmasini bosasiz.
6 - qadam : [Databases] ni Refresh qilasiz , sizda [Northwind] DB si yaratiladi.
7 - qadam : Endi siz Jadvallarga turli Querylar yozib natijalarni ko'rishingiz mumkun.

Credit by - https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd

Name		Name	Last commit message	Last commit date
Latest commit History 7 Commits
README.md		README.md
SQLQuery_AND_OR.sql		SQLQuery_AND_OR.sql
SQLQuery_SELECT.sql		SQLQuery_SELECT.sql
SQLQuery_WHERE.sql		SQLQuery_WHERE.sql
instnwnd.sql		instnwnd.sql