Category: SQL Server

using IN clause to provide a list of values for Search Criteria

In SQL Server , you can use the IN clause to providing the list of values for a search criteria. For example , you want to display the employee records who’s job title is one of the following : ‘Design Engineer’,’Tool Designer’. The above query uses the IN clause to filter the employee records using the arbitrary list of values. Alternatively , you can also…

SQL Server Error Code – 1033 the order by clause is invalid in views,

In this blog post, you’ll learn more about the SQL Server Error Code 1033 and the error message description that is shown SQL Server Error Code 1033 SQL Server Error Description for the Code :1033 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

SQL Server Error Code – 11215 this message could not be delivered beca

In this blog post, you’ll learn more about the SQL Server Error Code 11215 and the error message description that is shown SQL Server Error Code 11215 SQL Server Error Description for the Code :11215 This message could not be delivered because the user with ID %i in database ID %i does not have permission to send to the service. Service name: ‘%.*ls’.