Answer / Sandeep Kumar Khare

To download the scaled-down AdventureWorksLT database, follow these steps:
1. Go to https://github.com/MicrosoftDocs/sql-docs/blob/master/samples/databases/adventureworks-install-scripts/README.md.
2. Download the appropriate version for your SQL Server instance (SQL Server 2019, SQL Server 2017, or earlier versions).
3. Extract the downloaded zip file.
4. Run the installation script in SQL Server Management Studio (SSMS). To install, right-click on the script file and select 'Execute SQL'.nTo install AdventureWorksLT using PowerShell, you can use the following command:n`.<path_to_your_script>InstallAdventureWorksDB.ps1 -SqlServerInstance <SQL_Server_Instance_Name> -Action Install -DatabaseName AdventureWorks2012LT`

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

How do clustered indexes store data?

1 Answers  

---

How to sort query output in descending order in ms sql server?

1 Answers  

---

What is the use of keyword with encryption.

1 Answers  

---

Tell me what is sql profiler?

1 Answers  

---

Mention the different authentication modes in sql server.

1 Answers  

---

How to disable stored procedure sql server?

1 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

1 Answers  

---

How can you list all the columns in a database?

1 Answers  

---

What is 3nf normalization?

1 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

1 Answers  

---

What is normalization according to you and explain its different levels?

1 Answers  

---