Skip to content

Latest commit

 

History

History
11 lines (10 loc) · 892 Bytes

README.md

File metadata and controls

11 lines (10 loc) · 892 Bytes

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