I am looking for a publicly available SQL database with free access, where one can run some SELECT queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if …
Tag: sql
(Oracle) How get total number of results when using a pagination query?
I am using Oracle 10g and the following paradigm to get a page of 15 results as a time (so that when the user is looking at page 2 of a search result, they see records 16-30). select * from ( …
SQL Server Native Client API examples
I am writing a C++ application that needs to execute SQL queries in a SQL Server DB and I want to do it using SQL Server Native Client. The MSDN documentation has no a full reference on it and has a few examples so I am looking for some site having more information on how to connect, execute queries and
Join one row to multiple rows in another table
I have a table to entities (lets call them people) and properties (one person can have an arbitrary number of properties). Ex: People Properties I would like to write an efficient select that would select people based on age and return all or some of their properties. It’s also acceptable to return one …
Simple check for SELECT query empty result
Can anyone point out how to check if a select query returns non empty result set? For example I have next query: Should I do something like next: to test if result set is not empty? Answer Use @@ROWCOUNT: According to SQL Server Books Online: Returns the number of rows affected by the last statement. If the n…
When should I use primary key or index?
When should I use a primary key or an index? What are their differences and which is the best?
What is Service Broker in SQL Server?
What is Service Broker in SQL Server and is it meaningful to enable it in a simple database, not in a distributed database? Answer SQL Service Broker is an extension mechanism that allows you to queue events for asynchronous processing. There is no intrinsic harm in enabling the broker. If it’s not used…
set sql server connection to readonly?
How do I set a SQL server connection to readonly? I tried Googling and all I found was File Mode=Read Only, but it didn’t work (File Mode keyword not supported). The reference looked SQL CE specific. No luck with SQLite Read Only=True either. -edit- My connection string is below. I have no clue when it …
Passing combobox value into SQL query in MS Access
I have a combobox in a form, and I want the text of the combobox to be passed into a query. My query is: The form’s name is Enter Data and the combobox’s name is comboCup. Should i do this: or this? Answer You should use [Forms]![Enter Data]![comboCup]. As @Remou has said, the .Text property of an…
How do I reference sqlite db column to use in update statement
I am trying to update a datetime column in an android sqlite db to use international date format (yyyy-mm-dd) instead of the current format (mm/dd/yyyy). I want to use the sqlite date() function to reformat the current value of the column. I thought it would be as simple as the following: but the above does n…