Search Results

Search found 34461 results on 1379 pages for 'generated sql'.

Page 425/1379 | < Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >

• SQL: ... WHERE X IN (SELECT Y FROM ...) ...

  - by Craig Johnston

  Is the following the most efficient in SQL to achieve its result: SELECT * FROM Customers WHERE Customer_ID NOT IN (SELECT Cust_ID FROM SUBSCRIBERS) Could some use of joins be better and achieve the same result?

  Read the article

• SQL SERVER Query result in CSV format is possible?

  - by gopal

  Hi, Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions? If so can we use this feature from an asp.net application to get the result in CSV format? If so how can we do this?

  Read the article

• LINQ to SQL .Count takes way to much process time and decreases performances.

  - by soldieraman

  LINQ to SQL .Count takes way to much process time and decreases performances. I am doing a recursive loop and for one child (lets call it parent) I have to check the number of children under it to make a decision if it should be included or not. The Count is too slow 8 ms :( for 120 parent records. Any ideas to make it quicker.

  Read the article

• How can this SQL be wrong? What am I not seeing?

  - by ropstah

  Can anybody please spot my error, this should be a legal query in SQL shouldn't it?? Unknown column u.usr_auto_key in the ON clause This is the database schema: User: (usr_auto_key, name, etc...) Setting: (set_auto_key, name etc..) User_Setting: (usr_auto_key, set_auto_key, value) And this is the query... SELECT `u`.`usr_auto_key` AS `u__usr_auto_key`, `s`.`set_auto_key` AS `s__set_auto_key`, `u2`.`usr_auto_key` AS `u2__usr_auto_key`, `u2`.`set_auto_key` AS `u2__set_auto_key`, `u2`.`value` AS `u2__value` FROM `User` `u`, `Setting` `s` LEFT JOIN `User_Setting` `u2` ON `u`.`usr_auto_key` = `u2`.`usr_auto_key` WHERE (`s`.`sct_auto_key` = 1 AND `u`.`usr_auto_key` = 1 AND admin_property is null)

  Read the article

• How to distinguish between the first and rest for duplicate records using sql ?

  - by Biswanath

  Hi, These are the input table and required output table. Input table ID Name ------------- 1 aaa 1 ababaa 2 bbbbbb 2 bcbcbccbc 2 bcdbcdbbbbb 3 ccccc Output table ID Name Ord ----------------------------- 1 aaa first 1 ababaa rest 2 bbbbbb first 2 bcbcbccbc rest 2 bcdbcdbbbbb rest 3 ccccc first First and Rest is based on the occurrence of an ID field. Is there a way to write a SQL query to achieve this ? P.S. - This question is somewhat similar to what I am looking for.

  Read the article

• How do I insert records into 2 SQL tables sharing a dependency when I don't commit until the end?

  - by Cunning Lingus

  I keep finding myself in this situtation: I have an ASP.NEt 2.0 app. I have to insert into 2 tables in SQL. There is a dependency between the tables. I insert a record the first using a transaction. Then I move onto the 2nd table. But, because the first isn't committed yet the second one throws a error.

  Read the article

• PHP: How do I find (Oracle) parameters in a SQL query?

  - by Bartb

  Suppose you have a string: "SELECT * FROM TABLE WHERE column1 = :var1 AND column2 = :var2" Now, how do I get an array with all the variables like so: Array ( [0] => :var1 [1] => :var2 ) I've tried it with PHP's preg_match_all, but I struggle with the regex. $varcount = preg_match_all("/ :.+ /", $sql, $out);

  Read the article

• how to get time (hh:mm:ss) from sql query ?

  - by Gold

  hi i have Database with date field. i see the time like: 1900-01-01 13:38:00.000 how i can see it like: 13:38 ? (i work on sql server 2008) thank's in advance

  Read the article

• In SQL Server, how can I separate a large number of tsql statement into batches?

  - by Yousui

  Hi guys, In SQL Server, how can I separate a large number of tsql statement into batches? Should I use the GO statement in stored procedures or functions? Should I use the GO statement in explicit transaction management situation(between BEGIN TRANSACTION and ROLLBACK TRANSACTION or COMMIT TRANSACTION)? Are there some best practice about this topic? Great thanks in advance.

  Read the article

• How to write or append to text file using sql?

  - by aron

  Hello, in short i need to convert following C# code into SQL stored procedure foreach (var e in Entity) { if (File.Exists(e.Filename)) File.AppendAllText(e.Filename,e.Content); else File.WriteAllText(e.Filename, e.Content); }

  Read the article

• What SQL query should I perform to get the result set expected?

  - by texai

  What SQL query should I perform to get the result set expected, giving the first element of the chain (2) as input data, or any of them ? table name: changes +----+---------------+---------------+ | id | new_record_id | old_record_id | +----+---------------+---------------+ | 1| 4| 2| | -- non relevant data -- | | 6| 7| 4| | -- non relevant data -- | | 11| 13| 7| | 12| 14| 13| | -- non relevant data -- | | 31| 20| 14| +----+---------------+---------------+ Result set expected: +--+ | 2| | 4| | 7| |13| |14| |20| +--+ I know I should consider change my data model, but: What if I couldn't? Thank you in advance!

  Read the article

• I have a problem saving foriegn text to a SQL Server database table with a nvarchar field.

  - by user307840

  I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database. Any/all information you can provide me with is much appreciated :D

  Read the article

• Any DAL generators that will work on .NET 1.1 with SQL CE 3.1?

  - by Schneider

  Are there any DAL generators or ORMs that will work on .NET 1.1 with SQL CE 3.1? This is only for a short lived project, so cost would be an issue

  Read the article

• sql server: looking for table usage through out database...

  - by dotnet-practitioner

  How would I figure out what type of sql code such as procs, functions, views etc. are interacting with my table called TABLE1 through out a given database. Sample code would be very helpful for me. thanks

  Read the article

• SQL Exception: A truncation error was encountered trying to shrink VARCHAR '...' to length x

  - by Tom Brito

  I know really little about sql, can anyone give me a deeper explanation (or references) of what do this exception means? Possible related question: http://stackoverflow.com/questions/1016901/truncate-a-varchar-to-specific-length-in-derby-automatically

  Read the article

• How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  - by sabbour

  Say I have a LINESTRING defined as LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690, -122.310 47.670, -122.300 47.630) And I want to get a substring from POINT(-122.360 47.656) to POINT(-122.310 47.690) How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• Do I need to translate (local) in a sql server connection string?

  - by DanDan

  When connecting to sql server, I have the hardcoded string "(local)". Is this a string I need to make available for localisation? ie, does (local) always work no matter the current language settings?

  Read the article

• How can upload image URL in SQL server and retrieve in grid view using ASP.NET?

  - by kalaiselvi

  How to upload image URL in SQL server and retrieve in grid view using ASP.NET? Can you point me to any tutorials and/or sample code?

  Read the article

• How can I create dates/times and compare them in SQL?

  - by William

  I'm trying to create a BBS using PHP and SQL, and I want to make it so the topic with the most current post is on top of the topic list. what is a easy way to check if one date and time is more current than another?

  Read the article

• In SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes

  - by Matt

  IN SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• What is the easiest way to add a bunch of content to a SQL database?

  - by Trip

  Nothing technical here. Suppose I have a lot of different categorized data, and I would like to create a database out of it. Would someone literally hand plug in all that info with SQL code itself? Or do some people make a mock website just to input data? What are some of your strategies?

  Read the article

• Is there a way to have SQL server validate object references in Stored Procs?

  - by Scott Weinstein

  The following code executes fine in SQL Server create proc IamBrokenAndDontKnowIt as select * from tablewhichdoesnotexist Of course if I try to run it, it fails with Invalid object name 'tablewhichdoesnotexist'. Is there any way to compile or verify that Stored Proc are valid?

  Read the article

• How to check if a Constraint exists in Sql server?

  - by Lieven Cardoen

  I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different name. How do I check if there's a constraint with the name FK_ChannelPlayerSkins_Channels.

  Read the article

• How to check results of LINQ to SQL query?

  - by rem

  In a WPF app I'd like to check if a return of a LINQ to SQL query contains some records, but my approach doesn't work: TdbDataContext context = new TdbDataContext(); var sh = from p in context.Items where p.Selected == true select p; if (sh == null) { MessageBox.Show("There are no Selected Items"); } Where am I wrong?

  Read the article

< Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >