Search Results

Search found 33585 results on 1344 pages for 'sql execution plan'.

Page 548/1344 | < Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >

• how to select * from tableA where columnA values don't start with letter 'F'

  - by subash

  Can I have a SQL query to get the data from columna in tableA whose values don't start with 'f' ? For example: select * from tableA where columnA where values don't start with letter 'F'.

  Read the article

• how to read the datas from text file stored in the database

  - by Ranjana

  i have a txt file stored in my sql DB, in that .txt file i have certain numbers like 99435 87889 33455 33555 34556 how to get the count of these numbers from the txtfile stored in the database and also to read the file and fetch the number one bye one in a string. using asp.net (C#)

  Read the article

• Autoincrement based on a set of other columns

  - by slack3r

  I have a table Course and every Course has many Resources. Course ========== course_id Resource ========== course_id number I want something like a seperate autoincrement for each course_id. Or, in other words, I want to auto-enumerate the resources for a given course. For example, the resource table could look something like: course_id | number ================== 1 | 1 1 | 2 2 | 1 1 | 3 1 | 4 2 | 2 2 | 3 and so on. I want to do this in SQL, using IBM DB2.

  Read the article

• An Alternative to Views?

  - by Abs

  Hello all, I am just reading this article and I came across this: Filter: Remove any functions in the WHERE clause, don't include views in your Transact-SQL code, may need additional indexes. If I do not use views, what are the alternatives? I mean, in my situation, I want to select some data from a table and then use a few other select queries to work on the subset of data from the first select query? How can I do this efficiently? Thanks all

  Read the article

• How to escape special characters when retrieving data from database?

  - by ziang

  I am going to generate XML file based on the data returned from SQL Server, but there are some special characters like &#x1F; and &#x1C; (there may be other characters like these), which will fail the XML. Is there any way to escape them? Thanks!

  Read the article

• How can I change column length using HQL query?

  - by gmugmu

  I tried session.createSQLQuery("ALTER TABLE People MODIFY address VARCHAR(1000);").executeUpdate(); but this throws org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query After a lot of googling, the recommendation is to use HQL instead of SQL query to do bulk updates. Not sure how to use HQL to accomplish this. There seems to be no decent HQL documentation for updating column length in a table. Thanks so much for the help.

  Read the article

• Encoding in SQL to CSV

  - by Z77

  When do I execute query COPY TO ... CSV, I create CSV file. BUt when open it column with names in excel that should be with national characters are not as it should be. So my question is, If it is possible within a sql query to change this encoding to utf8? Or something else? Because I want that new created CSV file to be as final product for user on web. I hope someone understood what I want:)

  Read the article

• How to use the IN operator in linq

  - by Hallaghan

  I'm querying a view and filtering the results with a column named status. I'd like to query it so I can search for rows with different status, by using the IN operator as I'd do in SQL. As so: SELECT * FROM VIEW WHERE Status in ('....', '.....') How can I achieve this?

  Read the article

• SSIS Permissions issue

  - by Dave

  Hi All, How can we set permissions for users to only allow them to download SSIS packages from the production server and but deny them permissions to run any package in the Server. http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx If i assign users to any of the DB roles db_dtsadmin, db_dtsltduser, and db_dtsoperator they will automatically have permission to run the package. Appreciate your inputs. Thanks!

  Read the article

• query multiple tables and combine results into one return table for stored procedure?

  - by Shawn

  I have several different tables, but they all have 2 columns that are the same name. I want to write a stored procedure that searches one column in all of the tables and returns the result. Ideas? I'm fairly nub when it comes to SQL.

  Read the article

• Doctrine: how to create a query using "LIKE REPLACE" ?

  - by user248959

  Hi, this SQL clause is working OK: SELECT * FROM `sf_guard_user` WHERE nombre_apellidos LIKE REPLACE('Mar Sanz',' ','%') Now I'm trying to write this query for Doctrine. I have tried this: $query->andWhere(sprintf('%s.%s LIKE REPLACE (?," ","%")', $query->getRootAlias(), $fieldName), 'Mar Sanz')); but I get this error: Warning: sprintf() [function.sprintf]: Too few arguments Any idea? Regards Javi

  Read the article

• Is it possible to capture data from a WHERE clause?

  - by Kristopher Ives

  I have a scenario where I'm calculating something in the WHERE clause of my SQL, but I also want to get that calculation - since it's expensive. Is it possible to get the results of something done in the WHERE clause, like this: SELECT `foo` FROM `table` WHERE (foo = LongCalculation()) Wishful thinking, or possible with MySQL?

  Read the article

• How do you find the current rowcount setting on Sybase?

  - by Eric Johnson

  Lets say there is some code that executes the following SQL query: set rowcount n But n is unknown. Is there any way to know what n was? I'm using Sybase.

  Read the article

• alternative to sql server 2005

  - by csetzkorn

  Hi, I got used to the xml support and recursive common table expressions of sql server 2005. I am just wondering whether any free dbs like mysql support these requirements nowadays? Thanks. Christian

  Read the article

• Hibernate Beans generator

  - by Julio Guerra

  Hi, Does anybody know if there is any program able to create beans classes from a SQL file ? Thank you.

  Read the article

• Knowing the type of the stored proc when invoking from C#

  - by dotnetdev

  I am making a windows service to be able to run operations on a sql server database (insert, edit, etc) and invoke Stored Procs. However, is there a way for me to know the type of the SP? When invoking from C#, I need to knof if it is returning 1 value, or more, or none (so I can use executereader, scalar, etc)? Thanks

  Read the article

• Rails 2.3: How to turn this SQL statement into a named_scope

  - by randombits

  Having a bit of difficulty figuring out how to create a named_scope from this SQL query: select * from foo where id NOT IN (select foo_id from bar) AND foo.category = ? ORDER BY RAND() LIMIT 1; Category should be variable to change. What's the most efficient way the named_scope can be written for the problem above?

  Read the article

• mysql query if else statemnet?

  - by user253530

  I have this sql query: SELECT S.SEARCH, S.STATUS, C.TITLE AS CategoryName, E.SEARCH_ENGINES AS Engine, S.RESULTS, S.DATE, S.TOTAL_RESULTS AS Total, S.ID FROM PLD_SEARCHES AS S Join PLD_CATEGORY AS C ON C.ID = S.CATEGORY_ID Join PLD_SEARCH_ENGINES AS E ON S.SEARCH_ENGINES_ID = E.ID ORDER BY S.DATE ASC I want to identify if S.STATUS is either 1 or 0 and according to those values to return COMPLETE or PENDING in the query results

  Read the article

• How to create window service to read the xml file

  - by angel ansari

  hi, i have to create window service which read the xml file and and take the node's value to connect the sql server and create the log file i have already created window application for that but i don't know how to create win services.

  Read the article

• How do I programmatically create a Sql Server Reporting Services DataSource

  - by WOPR

  I have an application that creates a Sql Server 2008 database. When I create the database, I would also like to create a datasource for SSRS. How can I do this?

  Read the article

• group by with value of another column

  - by phenevo

  Hi, I've got table Articles ID identity autoincement, IDArticle: nvarchar(100) ,IDCar nvarchar(100), createddate How to convert this: SELECT IDCar , MAX(createddate) FROM Articles GROUP BY IDCar to get IDArticle eg: 1 art1 BWM 5-21-2010 2 art2 BMW 5-24-2010 3 art3 BMW 5-31-2010 4 art4 Porshe 5-31-2010 5 art5 Porshe 6-1-2010 Expecting result is: art3 art5 It's not duplicated with: http://stackoverflow.com/questions/2736769/sql-query-number-of-occurance/2736809#2736809

  Read the article

• How do I TRUNCATE TABLE using Django orm?

  - by Silver Light

  Hello! To empty database table, I use this SQL Query: TRUNCATE TABLE `books` How to I Truncate table using Django models and orm? I've tried this, but it doesn't work: Book.objects.truncate()

  Read the article

• When is `x IS NOT NULL` not the same as `NOT(x IS NULL)`

  - by Mark Hurd

  For what x is The expression x IS NOT NULL is not equal to NOT(x IS NULL), as is the case in 2VL (quote from this answer, which is quoting Fabian Pascal Practical Issues in Database Management - A Reference for the Thinking Practitioner -- near the end of that answer) My guess is when x IS NULL is NULL, but I cannot guess when that would be (i.e. I haven't checked the SQL standard).

  Read the article

• Best Embedded SQL DB for write performance?

  - by max.minimus

  Has anybody done any benchmarking/evaluation of the popular open-source embedded SQL DBs for performance, particularly write performance? I've some 1:1 comparisons for sqlite, Firebird Embedded, Derby and HSQLDB (others I am missing?) but no across the board comparisons... Also, I'd be interested in the overall developer experience for any of these (for a Java app).

  Read the article

• How to do bulk update of views?

  - by Shaul

  My database has about 30 views, most of which have a reference to another database on this server (call it DB1). Now, without going into the reasons why, I need to update all those views to DB2, also on the local server. I would hate to have to do this manually on each view. Is there some SQL query I can run that will replace all occurrences of the string 'DB1' with 'DB2' in all my views?

  Read the article

< Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >