Search Results

Search found 38138 results on 1526 pages for 'non sql'.

Page 568/1526 | < Previous Page | 564 565 566 567 568 569 570 571 572 573 574 575  | Next Page >

• How do I get 5 records before AND after a record with a specific ID?

  - by richleland

  I have a table named scores with the columns id and score. I want to access a specific record by its id as well as the 5 records before and after it. Is there a way in SQL to say "grab the score with the id of n and x items before and after it?"

  Read the article

• Why would SET ARITHABORT ON dramatically speed up a query?

  - by Jonathan Allen

  The query is a single select containing a lot of grouping levels and aggragate operations. With SET ARITHABORT ON is takes less than a second, otherwise it takes several minutes. We have seen this behavior on SQL Server 2000 and 2008.

  Read the article

• Sql query executing perfectly in phpmyadmin but giving warning while running on page

  - by saurav

  i don't know whats wrong with this sql query. SELECT * FROM main WHERE key LIKE '%$word%' its giving results in phpMyAdmin but giving warning while executing it in a php page. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

  Read the article

• See images in SSMS?

  - by Vaccano

  I was browsing around and found this blog post: http://erikej.blogspot.com/2010/04/version-3-of-exportsqlce-now-available.html (It is for a great add in if you user SQL Server CE.) On that post I saw an screen shot of SSMS with images in the results. How is this done? I have images in my database (PNG files that are serialized via memory stream), but I just see numbers when I select the image column.

  Read the article

• Primary Key Names in Fluent Nhibernate

  - by fregas

  Is there a way in fluent nhibernate (or possibly NHibernate in general) to tell it to generate the primary keys differently? It creates the column name for the key fine, but the index/constraint gets weird generated names like: PK_Address_3214EC2725332734 PK_CreditCa_3214EC2756CA82C8 etc... I can use straight sql to rename them but i'd rather not. thanks, all

  Read the article

• hex value in field/row terminator for bulk insert

  - by TheObserver

  I'm running SQL Server 2005 Express. And I'm trying to do a bulk insert/import of a data file with a field/row terminator that uses a hexadecimal value 0x001. How should I represent it in a bulk insert command? I have something like: bulk insert xxx.dbo.[yyy] from 'D:\zzz\zzz.dat' with ( CODEPAGE='RAW', FIELDTERMINATOR = '=|=', ROWTERMINATOR = '=|=\001\n', KEEPNULLS ); which results in Msg 4863, Level 16, State 1, Line 7 Bulk load data conversion error (truncation) for row 1, column 3 (code).

  Read the article

• Hibernate criteria DB2 composite keys in IN clause

  - by nkr1pt

  Hibernate criteria, using DB2 dialect, generates the following sql with composite keys in the IN clause, but DB2 answers that the query is incorrect: select * from tableA where (x, y) IN ( ( 'x1', y1) ) but, DB2 throws this: SQL0104N An unexpected token "," was found following ", y) in ( ('x1'". Expected tokens may include: "+". SQLSTATE=42601

  Read the article

• how do I update the date type column?

  - by Muhammad Hammad

  update answers a1 set a1.FilingDate=( select date_sub( a2.FilingDate ,Interval 1000 Year) as FilingDate from answers a2 where Year(a2.FilingDate)>=3000 ) where Year(a1.FilingDate)>=3000 but it gives me the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update answers a1 set a1.FilingDate=( select date_sub(a2.FilingDate,Interval 10' at line 1 Can anyone tell me about the issue and its solution?

  Read the article

• Product with Last Purchase Date

  - by mikewin86

  Hello , I would like to query from SQL Server 2000 Database.I have got two tables. They are Purchase and PurchaseDetails. I would like to get product records with Last Purchase ID but I can't query with the following statements.So please help me. SELECT TOP 100 PERCENT dbo.Purchase.PurchaseID AS LastOfPurchaseID, dbo.PurchaseDetails.ProductID, MAX(dbo.Purchase.PurchaseDate) AS LastOfPurchaseDate FROM dbo.Purchase INNER JOIN dbo.PurchaseDetails ON dbo.Purchase.PurchaseID = dbo.PurchaseDetails.PurchaseID GROUP BY dbo.PurchaseDetails.ProductID, dbo.Purchase.PurchaseDate,dbo.Purchase.PurchaseID ORDER BY MAX(dbo.Purchase.PurchaseDate) DESC

  Read the article

• TSQL Email Validation (without regex)

  - by Eric Z Beard

  Ok, there are a million regexes out there for validating an email address, but how about some basic email validation that can be integrated into a TSQL query for Sql Server 2005? I don't want to use a CLR procedure or function. Just straight TSQL. Has anybody tackled this already?

  Read the article

• How to convert int to nchar or nvarchar with leadind zeros ?

  - by Bitnius

  I need to convert int data table field to nchar or nvarchar leading zeros example: 1 convert to '001' 867 convert to '000867' thx. I tested this T-SQL Script and work fine for me ! DECLARE @number1 INT, @number2 INT SET @number1 = 1 SET @number2 = 867 SELECT RIGHT('000' + CAST(@number1 AS NVARCHAR(3)), 3 ) AS NUMBER_CONVERTED SELECT RIGHT('000000' + CAST(@number2 AS NVARCHAR(6)), 6 ) AS NUMBER_CONVERTED

  Read the article

• FirstOrDefault In F#

  - by build_your_web

  How to write FirstOrDefault Linq Query in F#? Can I use linq to sql in F# in totally?

  Read the article

• How to use Contains() in my join

  - by jrep...

  I am trying to get my linq query to replicate my t-sql but I am lost. SELECT * FROM BaiDetail INNER JOIN BaiDetailMap ON BaiDetail.DetailText LIKE '%' + BaiDetailMap.BaiDetailMapSearchText +'%' This is what I have so far... but no go from det in Source from map in Map where det.DetailText.Contains(map.SearchText) select new {det, map} Error Message: Only arguments that can be evaluated on the client are supported for the String.Contains method.

  Read the article

• Why does PostgreSQL have to be different (scheme does not exist)?

  - by Ben Dauphinee

  I'm not used to working with PostgreSQL, but am using Zend_Db_Select to create my queries. What does the error below mean? SQL error: ERROR: schema "il" does not exist In statement: SELECT il.count(*) AS "count" FROM "image_lite" AS "il" INNER JOIN "exif_parse" AS "ex" ON il.image_id = ex.image_id WHERE (ex.cam_make = 'apple')

  Read the article

• What does it mean: SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": co

  - by Z77

  I tried to create exactly the same but new table from old table in another database using dblink. This procedure used to worked last two times, but this time I got message: "SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query." Anyone knows where is the problem or how to solve it? Please!

  Read the article

• Best Practice : Import CSV to MYSQL Database using PHP 5.x

  - by ArneRie

  Howdy Folks, what is the best solution to import large amounts of records into an MySQL or Oracle Database. I Think there are two ways : Insert every record with an persistent connection Create on BIG SQL-Statement and query the Database Iam not sure wich is performing better ? Is there any Best Practice Solutions for this kind of operation ??

  Read the article

• Which kinds of queries is better for querying against conceptual model in Entity Framework?

  - by masoud ramezani

  There are 3 way for querying against conceptual model in EF : LINQ to Entity Entity SQL Query Builder Methods Which one is better for which situation? Is there any performance issues for these 3 type of querying?

  Read the article

• How may I create an horizontal view from a tree table

  - by Giuseppe Alfieri

  I want to create a view for each tree for each customer of this 3 table structured in this way: Fields: db_attrib.name, db_attrib.name, db_attrib.name until the last db_tree.id_child = 0 Values: db_attrib_values.value where db_attrib.id = db_attrib_value.id_attrib and so on for each child And so on for each db_tree.id This is the link to sql fiddle with the prepared structure: http://sqlfiddle.com/#!9/21516

  Read the article

• SQL Server 2005 Convert Ascii to Unicode

  - by Guazz

  I have data in an nvarchar field with data in ascii format: "Zard Frères Guesta" How do I convert it to a readable(unicode) format in t-sql?

  Read the article

• Rails3: how to use relational algebra to replace SQL-constructions like NOT and OUTER JOIN

  - by petRUShka

  There are two models Post and Comment. I should get all posts, which have no comments with specific tag. How can I do this using new Rails 3 features such relational algebra (arel). SQL-solution should be something like this: SELECT `posts`.* FROM `posts` LEFT OUTER JOIN `comments` ON `posts`.`id` = `comments`.`post_id` WHERE NOT (`comments`.`tag` = 'my_tag')

  Read the article

• Run SQL scripts on windows mobile installer

  - by Guillermo Vasconcelos

  Hi, We are working on a Windows Mobile 6.5 application. The application is already installed in some devices, and we need to distribute a new version with changes in the database schema (we added a few tables). Is there a way to make a "patch" windows mobile installer that will replace the application and update the embedded SQL database with some scripts? In a normal windows installer we would create a custom action in the installation process to apply the changes in the database, but I'm not sure how to do that for Windows Mobile Thanks.

  Read the article

• Rails 3 equivalent of complex SQL query

  - by Bryan

  Given the following models: class Recipe < ActiveRecord::Base has_many :recipe_ingredients has_many :ingredients, :through => :recipe_ingredients end class RecipeIngredient < ActiveRecord::Base belongs_to :recipe belongs_to :ingredient end class Ingredient < ActiveRecord::Base end How can I perform the following SQL query using Arel in Rails 3? SELECT * FROM recipes WHERE NOT EXISTS ( SELECT * FROM ingredients WHERE name IN ('chocolate', 'cream') AND NOT EXISTS ( SELECT * FROM recipe_ingredients WHERE recipe_ingredients.recipe_id = recipes.id AND recipe_ingredients.ingredient_id = ingredients.id))

  Read the article

• Where can I find an introduction to using PDO?

  - by aslum

  I know my SQL safety isn't up to par. I've read on this site that PHP PDO would be a good first step, and while I did take a look at the PDO Manual it's a bit daunting. Is there somewhere I can find a tutorial on the basics of using PDO rather then straight MySQL calls?

  Read the article

• How do I protect against cross-site scripting?

  - by shahinkian

  I am using php, mysql with smarty and I places where users can put comments and etc. I've already escaped characters before inserting into database for SQL Injection. What else do I need to do?

  Read the article

• MySQL column not found

  - by vian

  The SQL query without where statement runs great and outputs good results, but when I include WHERE condition it shows Unknown column 'date1' in 'where clause'. What's the problem? SELECT IF(e.weekly, DATE_ADD(DATE(e.time), INTERVAL CEIL(DATEDIFF('2010-04-08', e.time)/7) WEEK), DATE(e.time)) AS `e.date1`, `v`.`lat`, `v`.`lng` FROM `events` AS `e` INNER JOIN `venues` AS `v` ON e.venue_id = v.id WHERE e.date1 > '2010-09-01'

  Read the article

< Previous Page | 564 565 566 567 568 569 570 571 572 573 574 575  | Next Page >