Category: SQL Server

Using Where clause in T-SQL Query

AbundantCode 2 months ago in SQL Server 0

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 ?…

SQL Server Error Code – 3422 database %ls was shutdown due to error %

AbundantCode 2 months ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 3422 and the error message description that is shown SQL Server Error Code 3422 SQL Server Error Description for the Code :3422 Database %ls was shutdown due to error %d in routine ?%hs?. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.

SQL Server Error Code – 9908 changing the status to %ls for full-text

AbundantCode 2 months ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 9908 and the error message description that is shown SQL Server Error Code 9908 SQL Server Error Description for the Code :9908 Changing the status to %ls for full-text catalog ‘%ls’ (%d) in database ‘%ls’ (%d). This is an informational message only. No user action is required.

Using FETCH and OFFSET to get N records in SQL Server

AbundantCode 2 months ago in SQL Server 0

In SQL Server , you can use the OFFSET and FETCH and apply paging and retreive N records at a time. OFFSET AND FETCH clause are part of the ORDER BY clause and hence you must include the ORDER BY clause. For example , you might want to skip the first 4 records and retrieve 5 records from the query , you could use the…

SQL Server Error Code – 7847 xml data was found in the parameter ‘%.*

AbundantCode 2 months ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 7847 and the error message description that is shown SQL Server Error Code 7847 SQL Server Error Description for the Code :7847 XML data was found in the parameter ‘%.*ls’ which is not an XML parameter.  Please entitize any invalid XML character data in this parameter, or pass the parameter in typed…

SQL Server Error Code – 8019 the incoming tabular data stream (tds) r

AbundantCode 2 months ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 8019 and the error message description that is shown SQL Server Error Code 8019 SQL Server Error Description for the Code :8019 The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d (“%.*ls”): Data type “0x%02X” (CLR type) has an invalid user type specified.