Category: SQL Server

SQL Server Error Code – 5177 an unexpected error occurred while check

In this blog post, you’ll learn more about the SQL Server Error Code 5177 and the error message description that is shown SQL Server Error Code 5177 SQL Server Error Description for the Code :5177 An unexpected error occurred while checking the sector size for file ‘%.*ls’. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL…

Using Where clause in T-SQL Query

If you want to restrict the results of the query to only the records that you need instead of returning all the records from the table , you can use the WHERE clause to filter the records. You can simply specify the WHERE clause and also specify the conditions that the rows must meet. How to Filter records using WHERE clause in SQL Server ?…