Search Results

Search found 31328 results on 1254 pages for 'sql join'.

Page 732/1254 | < Previous Page | 728 729 730 731 732 733 734 735 736 737 738 739  | Next Page >

• Can compilation of several Oracle Pl/SQL package be an atomic operation?

  - by Alexey Kalmykov

  If I deploy N pl/sql packages to Oracle DB, can I make their compilation atomic i.e. the changes in these packages will be applied after the successful compilation of all packages?

  Read the article

• New to HBase. I need help as I'm new to HBase, but use to SQL.

  - by WackoMax

  Hi there I'm use to SQL, but I need to read data from a HBase table. Any help on this would be great. A book or maybe just some sample code to read from the table. Someone said using a scanner would do the trick, but I do not know how to use it.

  Read the article

• SqlLite from C# - Which is easier to LINQ-to-SQL or Entity Framework?

  - by Greg

  Hi, What would people recommend using as a persistence approach for Sqlite from a C# windows forms application - LINQ-to-SQL or Entity Framework? (I ask this on the basis that I've had some people say stay away from DataTables and move to one of the new approaches)

  Read the article

• how to execute Sql Raw Query in Microsoft Entity Model Framework.

  - by kamal

  Hi I'm using Microsoft Entity model framework to access my database. I get an issue while i use this execute query command for executing Sql raw query. Let me know how could i resolve it. svdc.CreateQuery("select * from videomastertable WHERE FREETEXT(*, '"+keyword+"')").ToList(); Thanks in Advance, Kanal

  Read the article

• I need a sql db that has all the stock symbols on the US market. ANYONE?

  - by mprototype

  That is pretty much it. I need a .sql file with all the stock symbols and company names matched up for an autocomplete function I'm writing. ANYONE?

  Read the article

• How To Work With SQL Database Added As Item In Visual Studio 2008?

  - by mdvaldosta

  If I'm letting Visual Studio take care of adding an SQL Server database to an existing project, it adds the connection string to app.config. How can I use use THAT connection string to make my own connections and datasets?

  Read the article

• How to combine these three sql queries into one?

  - by lam3r4370

  How to combine these two sql queries into one? SELECT DISTINCT * FROM rss WHERE MATCH(content,title) AGAINST ('$filter') SELECT COUNT(content) FROM rss WHERE MATCH(content,title) AGAINST ('$filters') And if the result is 0 from the above query - SELECT DISTINCT * FROM rss WHERE content LIKE '%$filters%' OR title LIKE '%$filters%'; $filter .= $row['filter']; $filters = $row['filter']; $filters may be more than one keyword

  Read the article

• Where can I find a definitive reference on HTML 5 database SQL syntax support?

  - by Newbie

  Does anyone know of a good online resource which gives a clear reference on the SQL syntax supported by HTML 5 client-side databases? I've looked about and cannot seem to locate one. Thanks

  Read the article

• why two date classes one in java.util.Date and java.sql.Date?

  - by giri

  HI I like to know why there are two Date classes in two different packages one in java.util.Date and one in java.sql.Date? Whats the use of having two Date classes?

  Read the article

• Report Designer for vb.net using Visual Studio 2008 and a SQL 2005 back end database other than Crys

  - by GaryBrown

  We are developing in vb.net using Visual Studio 2008 and a SQL 2005 back end database and are looking for a Report Designer that can be used to build reports and give the User the ability to modify and create reports once the software is sold and in use.

  Read the article

• Where can I get SQL for default Oracle's "HR" schema?

  - by Dmitry

  I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

  Read the article

• Is it possible to integrate user databases between Drupal and an ASP&SQL Server platform?

  - by hecatomber

  We have a game project designed on ASP&SQL Server, and we need to integrate it's user database with Drupal. This would be easier from Project to Drupal (since there is user_save and user_delete functions available globally by using drupal bootstrap) but I'm not sure if we can execute PHP functions on an ASP platform. Is there any documentation for this kind of problems? What do you suggest?

  Read the article

• how to increase or decrease the quantity in a field in my sql when we enter the new quantity

  - by madhu

  I'm doing a project I'm encountering a problem in my project......... the problem is i would like to increase or decrease the quantity in my sql quantity field when i pass the issued or delivered quantity i.e.... initially the quantity in the quantity filed is 1 when i intake the product of a quantity 10 then automatically it should update the quantity as 10+1=11 so it must update as 11, if i remove a 1 quantity it should update as 0........ how to write a code in jsp.......... pls do help

  Read the article

• Django database - how to add this column in raw SQL.

  - by alex

  Suppose I have my models set up already. class books(models.Model): title = models.CharField... ISBN = models.Integer... What if I want to add this column to my table? user = models.ForeignKey(User, unique=True) How would I write the raw SQL in my database so that this column works?

  Read the article

• Where is my T-SQL Editor toolbar in VS 2008 Professional?

  - by Vilasack Phothisan

  I cannot find the "T-SQL Editor" in vs 2008 professional. Is this not available in this version?

  Read the article

• Can I get name of all tables of SQL SERVER database in C# Application???

  - by Govind Lohar

  I want to get name of all table of SQL server database in my C# application. Is It possible??? Plz tell me Solution.

  Read the article

• Does Oracle have an equivalent of SQL Server's table variables?

  - by Margaret

  In SQL Server, you can declare a table variable (DECLARE @table TABLE), which is produced while the script is run and then removed from memory. Does Oracle have a similar function? Or am I stuck with CREATE/DROPs that segment my hard drive?

  Read the article

• i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and

  - by kunal

  i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and fetch a column in a textbox which is linked to that dropdown cntrl in the database, what coding should i use in c# for that?

  Read the article

• SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?

  - by daniel

  Well, the question is pretty much in the title. I've just installed Visual Studio SP1, and now when I want to import a Entity Model from a database, it doesn't display the SQL Anywhere provider anymore. Does anyone know if there is a patch or some way to make it work with SP1? Thanks.

  Read the article

• What is the Progress equivalent to SQL Management Studio?

  - by Chris Lively

  I have a progress database that I need to connect to. What is their equivalent to the SQL Server Management Studio?

  Read the article

• Database Trends & Applications column: Database Benchmarking from A to Z

  - by KKline

  Have you heard of the monthly print and web magazine Database Trends & Applications (DBTA)? Did you know I'm the regular columnist covering SQL Server ? For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database benchmarking tools: the free, open-source HammerDB, the native SQL Server Distributed Replay Utility, and the commercial Benchmark Factory from Dell / Quest Software. Wondering what...(read more)

  Read the article

• Why I don’t need to go on the SQLCruise

  - by Jonathan Kehayias

  Brent Ozar ( Blog | Twitter ) and Tim Mitchell ( Blog | Twitter ) are putting on a new type of event in the month of August after SQL Saturday #40 in South Florida July, 31st , properly named SQLCruise .  The concept is great, at least in my opinion, you pay for a cruise, get to have a break, and at the same time attend a mini-conference on SQL Server with training provided by two great speakers.  The cost is relatively affordable, so what could possibly make it better?  How about...(read more)

  Read the article

• Why I don’t need to go on the SQLCruise

  - by Jonathan Kehayias

  Brent Ozar ( Blog | Twitter ) and Tim Ford ( Blog | Twitter ) are putting on a new type of event in the month of August after SQL Saturday #40 in South Florida July, 31st , properly named SQLCruise . The concept is great, at least in my opinion, you pay for a cruise, get to have a break, and at the same time attend a mini-conference on SQL Server with training provided by two great speakers. The cost is relatively affordable, so what could possibly make it better? How about a sponsor offering up...(read more)

  Read the article

• When a restore isn’t really complete

  - by John Paul Cook

  This week I discovered that restoring from a full backup doesn’t always restore SQL Server to the same state it was in when the backup was made. There are three settings that, if enabled, are not restored after a database restore. Thanks to Greg Low for pointing out that the list of affected settings is found in the SQL Server 2008 Upgrade Technical Reference Guide from which I quote: · is_broker_enabled · is_honor_broker_priority_on · is_trustworthy_on Detaching and attaching a database will also...(read more)

  Read the article

• 24 Hours of PASS – Database Design Fundamentals

  - by drsql

  Well, I have to admit when I got the invite to speak during this event, I was honored (and still am for that matter). But I have to admit, I hope people don’t come in with any belief that I will be Celebrating SQL Server 2008 R2.  Most of what I will present could have been celebrated with SQL Server 6.5, as I will be doing my bread and butter Database Design Fundamentals session that I have done multiple times over the past few years. Ironically, had the people that you and I work with/for...(read more)

  Read the article

< Previous Page | 728 729 730 731 732 733 734 735 736 737 738 739  | Next Page >