Search results
Can anyone point out how to check if a select query returns non empty result set? For example I have next query: SELECT * FROM service s WHERE s.service_id = ?; Should I do something like next: ISNULL(SELECT * FROM service s WHERE s.service_id = ?) to test if result set is not empty?
25 cze 2014 · SQL Server started streaming and only then noticed the error because the error happened as part of executing the query plan. Insert the query results to a temp table and only if no error is caught select the contents of that temp table.
22 paź 2015 · Opening_Date and Date should be date or datetime, not varchar. But before you can fix that, you need to identify the rows that are causing the conversion problem: SELECT cod_store, [Date] FROM dbo.FactTransactions WHERE ISDATE([Date]) = 0; SELECT cod_storekey, Opening_Date FROM dbo.DimStore WHERE ISDATE(Opening_Date) = 0;
10 kwi 2024 · You do the insert, check the row count, and return a message if it’s zero: DECLARE @t table ( database_id integer, database_name sysname ); INSERT @t ( database_id, database_name ) SELECT d.database_id, d.name FROM sys.databases AS d WHERE d.database_id > 32767; IF @@ROWCOUNT > 0 BEGIN SELECT t.*
6 cze 2024 · Managing null or empty values in SQL is a frequent task for database developers and administrators, as these values represent missing or undefined data. It’s essential to identify them to maintain data integrity and ensure accurate query results. In this tutorial, we’ll discuss different ways to retrieve rows containing such values.
As Martin pointed out, it's a .Net error. You should check your code, it could be anything but I'll give an example of how this can happen in pseudo-code: Item[] myItems = new Item[sql.queryshot("select count(*) form myTable")]; int counter=0; Cursor MyCursor = GetData(); foreach(Data data in MyCursor){.
ERROR_MESSAGE returns a relevant error message regardless of how many times it runs, or where it runs within the scope of the CATCH block. This contrasts with a function like @@ERROR, which only returns an error number in the statement immediately following the one that causes an error.
