Search Results

Search found 28024 results on 1121 pages for 'sql 2014'.

Page 946/1121 | < Previous Page | 942 943 944 945 946 947 948 949 950 951 952 953  | Next Page >

• what is best way to store long term data in iphone Core Data or SQLLite?

  - by AmitSri

  Hi all, I am working on i-Phone app targeting 3.1.3 and later SDK. I want to know the best way to store user's long term data on i-phone without losing performance, consistency and security. I know, that i can use Core Data, PList and SQL-Lite for storing user specific data in custom formats.But, want to know which one is good to use without compromising app performance and scalability in near future. Thanks

  Read the article

• How to dump temporary MySQL table into a file?

  - by Alex N.

  Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?

  Read the article

• How did you get your first programming job?

  - by Gaz

  Hi All, I have some commercial programming experience although it was not my primary role (C# and Java), SCJP 6 cert, some SQL experience and have been doing a lot of Android programming (I have one app with 36,000 downloads). I have a degree in Chemistry and a Diploma in Programming (half a degree made up of 2nd/3rd year uni courses). I'm trying to get my first entry level programmer job but am finding it tough out there.......How did other people get there first jobs in programming?

  Read the article

• how do I call a function from TOAD for Oracle and bind the result to a data grid

  - by neesh

  I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle?

  Read the article

• Data retrieval and Join operations with cluster db server

  - by Goerge

  If any database spreads across multiple servers (ex. Microsoft Sql Server), how can we do join or filter operations. In my scenario, if suppose: A single table spreads across multiple servers how can we filter rows based on user input? If master table is there on one db server and transaction table is at another db server, how can we do join operations? Please let me know how can we achieve this and where can I get more details about this?

  Read the article

• The PROMOTE TRANSACTION request failed because there is no local transaction active.

  - by Mark J Miller

  Under what circumstances would I see the above message? I have a single call to SQL Server which is wrapped in a call to TransactionScope. In our development and QA environments MSDTC is turned off and the call succeeds fine. However, in our production environment with MSDTC turned on we are failing with this call. Is there something that would cause this when I am sure we are not looking at a distributed transaction call at all?

  Read the article

• ASP.Net 4.0 Database Created Pages

  - by Tyler

  I want to create asp.net 4.0 dynamic pages loaded from my MS SQL server. Basically, its a list of locations with informations. For example: Location1 would have the page www.site.com/location/location1.aspx Location44 would have the page www.site.com/location/location44.aspx I dont even know where to start with this, url writting maybe?

  Read the article

• How to delete specific record from Google Datastore (in Java) ?

  - by Srivigneshwar

  I have some records in datastore, I want to delete a specific record from the table. for example in SQL , we use delete * from table1 where name ="mike" what is the equivalent code in java (I m using Eclipse with Google appengine API plugin)? or any other method to do that?

  Read the article

• left outer join problem

  - by ognjenb

  I need to convert some SQL statement to LINQ. How convert LEFT OUTER JOIN to equivalent LINQ statement?

  Read the article

• How to store a scaleable sized extensible event log?

  - by firoso

  Hello everyone! I've been contemplating writing a simple "event log" that takes a paramater list and stores event messages in a log file, trouble is, I forsee this file growing to be rather large (assume 1M entries or more) the question is, how can I implement this system without pulling teeth, I know that SQL would be a possible way to go. XML would be ideal but not really practical for scaleability if i'm not going nuts. Example Log Entry -----Time Date-------- ---------Sender----------------------- ---------Tags---------- --Message---------- 12/24/2008 24:00:00 $DOMAIN\SYSTEM\Application$ :Trivial: :Notification: It's Christmas in 1s

  Read the article

• What is the cleanest way to sort "describe table" query results ?

  - by Youssef AZARI

  Hello everyone, I'm working on "describe table" output to show a list of fields and their types, i want my primary keys to be at top of the list.. I think there's no way to sort describe's results using SQL (something like 'order by') rather than sorting it in PHP. what do you think guys ? thanks

  Read the article

• Basic Steps for creating a Shoping Cart Website

  - by Subhen

  Hi, I want to create a shoping cart web site using .Net and C#. I am intermediate for C# and SQL Server. Have no idea as of on how to start with a Shoping cart website ,my sincere grattitude towards any usefull link or suggestions and help . Thanks, Subhen

  Read the article

• How can I get the name of all tables in a JavaDB database?

  - by Jonas

  How can i programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC? I will use it for exporting the tables to XML, and would like to do it this way so I don't miss any tables from the database when exporting.

  Read the article

• How to remove a certain row from DataTable ?

  - by eugeneK

  How do i achieve simple sql query like delete from Users where userCity='Munich' with DataTables ? p.s. without using Linq or something like that simply because i do not use it though project.

  Read the article

• python popen and mysql import

  - by khelll

  I'm doing the following: from subprocess import PIPE from subprocess import Popen file = 'dump.sql.gz' p1 = Popen(["gzip", "-cd" ,file], stdout=PIPE) print "Importing temporary file %s" % file p2 = Popen(["mysql","--default-character-set=utf8", "--user=root" , "--password=something", "--host=localhost", "--port=3306" , 'my_db'],stdin=p1.stdout, stdout=PIPE,stderr=PIPE) err = p1.communicate()[1] if err: print err err = p2.communicate()[1] if err: print err But the db is not being populated. No errors are shown, also I have checked p1.stdout and it has the file contents. Any ideas?

  Read the article

• HTML Encoding with ASP.NET

  - by Corin

  I am currently html encoding all user entered text before inserting/updating a db table record. The problem is that on any subsequent updates, the previously encoded string is reencoded. This endless loop is starting to eat up alot of column space in my tables. I am using parameterized queries for all sql statements but am wondering would it be safe to just let the .NET Framework handle this part without the HTML Encoding?

  Read the article

• How to access data from multiple tables

  - by Vinay Pandey

  Hi All, How to write linq query to access data from multiple table.How do you write Linq query for the following sql query:- "select * from user,employee where user.Name='smith' and employee.company='xyz'"

  Read the article

• Is there a better way to find the max count in a table

  - by nXqd

  select NV.PHG From Nhanvien NV Group by NV.phg Having count(nv.Manv) >= all (select count(NV.MANV from nhanvien nv group by nv.MANV)) I'm finding a better way to find the 'max count' NV of a PHG ( in this example ) . I think, we meet this case all the time when we do SQL, i should've a better way . Thanks for reading this :)

  Read the article

• Fluent NHibernate Column Mapping with Reserved Word

  - by Josh Close

  I've read that using a back tick ` should allow for using of reserved words. I'm using SQL Server and Fluent NHibernate and have a column name "File". If I map it with "`File" it tries using [Fil] so it's adding the brackets correctly, but dropping the "e" from the end. If I map it as "`Filee" it uses [File] correctly. Am I doing something wrong or is this a bug in NHibernate or Fluent Nhibernate?

  Read the article

• tsql db readonly status

  - by Giuseppe

  Dear All, I need to know how to interrogate my Microsoft SQL Server to know if a given database has been set to readonly or not. Is that possible? Thanks Giuseppe

  Read the article

• How to get named excel sheets while exporting from SSRS

  - by rao

  Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this after some googleing: Changing the Sheet names in SQL Server RS Excel: QnD XSLT Will try out and post an update if it works.

  Read the article

• MS Stack web host with HIPAA expertice?

  - by AndrewCr

  I'm a consultant, helping a provider of small medical practice management software move to the web. We're looking for a host that has experience with HIPAA-compliance, and supports the MS Web stack (IIS / .net / SQL Server) Can anyone here provide a recommendation of such a hosting company? Thanks, Andrew

  Read the article

• host an asp.net webite outside of IIS

  - by boraer

  Hi everybody, I need to write an asp.net application which have to handle very large amount of data per second. Probably max5000 user may transact in same time. I think I will use WCF in back to communicate SQL server. But in front ISS can handle 5000 user in same time effectively or is there any simple way to host my application outside of IIS

  Read the article

• Is it possible to simulate TMenuBreak functionality with Dev Express TdxBarSubItems?

  - by mcmar

  In my application I'm dynamically adding new TdxBarSubItems based off of a SQL query. In some cases the result set is rather large so the menu fills the entire screen and sometimes has a down arrow to scroll the list. In a previous version of the code before switching to Dev Express, I was able to add TMenuBreak objects to make the list divide into columns. Is there a way to do this with Dev Express components?

  Read the article

• Average time from database list in C# with ASP MVC?

  - by Jacob Huggart

  I have a list of times that I have acquired from a sql database and I need to find the average time. I tried just doing list.average() and list.sum(), but neither of those work with timespan lists. What do you all suggest? btw, time is returned in a hh:mm:ss format.

  Read the article

< Previous Page | 942 943 944 945 946 947 948 949 950 951 952 953  | Next Page >