Here is the create statement: create table dbmonitor.DBMON_DATABASE_TYPE ( DATABASE_TYPE_ID BIGINT IDENTITY NOT NULL, DispName NVARCHAR(255) null, primary key (DATABASE_TYPE_ID) ) and this is the error I get: 13:40:57,685 ERROR [TestRunnerThread] SchemaExport [(null)]- The table name is not valid. [ Token li...
Hi, I have a table with three columns and I have fetch a column whose value matches with value 'aaaa' and 'bbbb' columnA ColumnB ColumnC data1 yyyy aaaa data2 zzzz mmmm data1 hhhh nnnn data3 aaaa bbbb So, if I query with "Select * from ...
I asked a question on SO a few hours back. How to insert an Array of field names from a form into SQL database in Codeigniter. <tr> <td><input type="text" name="user[0][name]" value=""></td> <td><input type="text" name="user[0][address]" value=""><br></td> <td><input type="text" name="user[0][age]" value=""></td> <td><input type="text"...
Just to give you an example: I have a PHP script that manages users votes. When a user votes, the script makes a query to check if someone has already voted for the same ID/product. If nobody has voted, then it makes another query and insert the ID into a general ID votes table and another one to insert the data into a per user ID vote...
I'm trying to count how many created vs published posts there are per user in my database. POST ID | USER ID | STATUS ...and an example would be User ID 1 has 5 posts (5 distinct post IDs) with 3 STATUS = CREATED and 2 STATUS = PUBLISHED. I want the output to show the following columns USER CREATED PUBLISHED ---------------...
This is a follow-up question to this question. Sphinx mentions on the downloads page: Note that 'beta' only applies to new features (RT indexes etc), everything else is stable. What is the "etc" in the new features? ...
I have this procedure: PROCEDURE P_LOAD_EXPIRED_ACCOUNT ( pDayDiff IN NUMBER, ExpiredCur OUT MEGAGREEN_CUR ) IS BEGIN OPEN ExpiredCur FOR SELECT ACCOUNT_NAME, SERVICE_TYPE, CASE WHEN SERVICE_TYPE = 1 THEN ADD_MONTHS(ACTIVATED_DATE,3) WHEN SERVICE_TYPE = 2 THEN ADD_MONTHS(ACTIVATED_DATE,6) WH...
Is there a way to see all generated queries from rails in production environment like you can in development? ...
Hello. Working with Drupal 6, my goal is to order a set of threaded comments similar to how Facebook outputs comments: with the 'anchor' or first comment in each thread sorted DESC, and any 'internal' thread replies sorted ASC so the newest comments are at the bottom. Here's the SQL query from comment_render, with ordering by COMMENT_OR...
Hi, I am using SQL server 2008. If I am working on the Management Studio's query analyser, and I go ahead and create a new table or view, then the SSMS does not see the newly created object for intellisense. What do I do to make SSMS see and autosuggest from the newly created tables/views too? ...
How can I insert a date into db2 in this format: yyyy-mm-dd, using a sql query? ...
Yes so im building an query from the advanced search form. I have this: $query = "SELECT * FROM users WHERE 1 "; $query .= "AND sex = '$sex' "; for now, next im going to have AND birthday.. but then i dont know how to do it, because users birthday is stored in users_profile So please correct me, how can i: $query .= "AND birthday...
Does anybody know when those __sync tables are created when performing synchronization between a SQL Server and a SQL Server CE?. I just set up the application that sets up the local and remote provider, and created all sync adapter commands (Insert, incremental Insert...) but when I call the Synchronize() method I get an exception. When...
In SQL 2008, I have a query like so: QUERY A UNION QUERY B UNION QUERY C Will it be slower/faster than putting the result of all 3 queries in say, a temporary table and then SELECTing them with DISTINCT? ...
Hi, First I try to explain the circumstances. I store the the filter expression in one column separated by line breaks. The base idea was this: SELECT 'SELECT ''' + REPLACE(topic_filter,CHAR(10),''' UNION ALL SELECT ''') + '''' FROM dbo.topic_filter T WHERE T.id = @id FOR XML PATH('') After this I simply execute this string to ...
In an Oracle stored procedure, how do I write a transaction? Do I need to do it explicitly or will Oracle automatically lock rows? ...
So I have a table that's basically a tree. Each row has a parent in the same table, and a lvl column that tells me the level in the tree, the root being lvl = 0. Now say I want to select all the rows that have a name starting with A, but only those that are on the highest level in this group. So the tree might have 9 levels, but the high...
I am using Quartz.NET for my scheduling system, and I want administrators to be able to logon to a web based form to update and delete jobs and triggers. I plan to use a gridview to achieve this, but I have a few issues I have run into. How do I select all data from 3 tables, but make sure each row in each table corresponds to the row i...
There are 4 fields: Name,Status,Activities Performed And Region.We have to make search tool so that if user enter any one or two or more values from these fields it will be searched with the help of SQL query i.e. a single query should be able to take all these fields into account and check which of them are null and accordingly make dyn...
Hi every one, I have the following SQL query: SELECT C.ID, C.Name FROM Category C JOIN Layout L ON C.ID = L.CategoryID JOIN Position P ON L.PositionID LIKE '%' + CAST(P.ID AS VARCHAR) + '%' WHERE P.Code = 'TopMenu' and following data Position: ID Code 1 TopMenu 2 BottomMenu Category ID Name 1 Home 2...