Search Results

Search found 53054 results on 2123 pages for 'sql sample database'.

Page 669/2123 | < Previous Page | 665 666 667 668 669 670 671 672 673 674 675 676  | Next Page >

• Modelling database entites using text only

  - by Jaimal Chohan

  Back in the day, there was a standard that I was taught a standard for modelling database entities using text only, I can't remember the name of the standard but it looked somehing like TableName, Key, Column Anybody know what that form was called?

  Read the article

• Can netezza database handle procedures?

  - by san6086

  Hi I am having Netezza Database. I am querying the tables through DB visualiser. Since my table creation involves complex, I am interested to use procedures but I am unable to write it in DBvisualiser. I am confused whether the problem is with the tool that I use or in Netezza? Please advice

  Read the article

• How do I generate site map from MySQL database

  - by mathew

  Hi all I am new to Php and working on a project which needs to generate sitemaps from URLS which stored in MySQL database. how can I do this?? Is there any one have any idea?? site maps can be in php extension too and only requirement is list of sites display in each page

  Read the article

• javascript autocompletion for DSL. (e.g.: SQL)

  - by chacko

  I want to give the user a web-page where he can type some simple SQL. select * from myTable. What I would like is to have the autocompletion area to help typing: sel [selECT] select * f [select * fROM] select * from [select * fROM column1] [select * fROM column2] ... Anybody can suggest if there is a nice open source library for this ? I am not really interested in the SQL (I will have to parse a DSL) I am more interested on a powerful autocompletion text area widget.

  Read the article

• Can multiple wordpress's feed off one database?

  - by ThomasReggi

  I am a template designer and I want to create one wordpress with all generic posts, but I don't want to have to keep logging in and copy & pasteing the same wordpress posts everytime. Can I point multiple WP installs to one database? A harder way would be export a master db and importing it to each install. Before I go crazy and try to hack something together, does anyone have any advise? -Thanks in advance.

  Read the article

• How to count the advertisement hits and stores it in database

  - by Paul

  We put our website advertisement in 2 other websites. We need to count the hits we are getting form those advertisement and like to store it in my database. Please give me an idea to do that.

  Read the article

• Date Difference, Excluding certain Times and Dates

  - by Josefvz

  Hi Folks. I'm looking for a way to determine the difference between two dates. A normal SQL DATEDIFF statement won't cut it because I need to excluded non working Hours and days Namely Weekends and any time between 16:00 - 7:00. Something similar to the NETWORKDAYS function in excel. I'm codeing an excel spreadsheet. Using VBA connect to a SQL server to pull data.

  Read the article

• Linq to SQL in and not in

  - by pranay_stacker

  what is in and not in equals in Linq to sql ? fore example select * from table in ( ...) and select * from table not in (..) what is equal to above statement in Linq to sql ?

  Read the article

• java swing frame excellent for resultset from database

  - by merin

  sir, l want to display resultset in jframe.i get output last record in the database displayed. Lam intrested to place next button,back button in the frame.when i was click in the back button previosly viewed record is displayed and vice-versa.i don't know it will be possible.plz help me

  Read the article

• How do I use Perl to parse the output of the sqlplus command?

  - by benjamin button

  I have an SQL file which will give me an output like below: 10|1 10|2 10|3 11|2 11|4 . . . I am using this in a Perl script like below: my @tmp_cycledef = `sqlplus -s $connstr \@DLCycleState.sql`; after this above statement, since @tmp_cycledef has all the output of the SQL query, I want to show the output as: 10 1,2,3 11 2,4 How could I do this using Perl?

  Read the article

• NHibernate Empty Set Clauses in SQL Update Statements

  - by Brian Wilkinson

  I'm getting SQL update statements from NHibernate having a empty set clause ie UPDATE SET WHERE x == ? This propblem is occuring when a child entity is being updated for some reason the sql statement is being run against the Parent Entity, for some reason NHibenate is saying the parent has changed but when the set clause is being built no changes are found, can anyone help. The application I am constructing isn 3 tier. The domain entities are light weight data contract only entities.

  Read the article

• How to select a row with a missing entry in historization?

  - by Viper

  from the following data basis i need to select all IDQ's which do not have an entry for the 11.11.2011. IDQ | DATE ---------------- 1 | 08.11.2011 1 | 09.11.2011 1 | 10.11.2011 1 | 12.11.2011 1 | 13.11.2011 i can't figure out how to express the sql select IDQ from TBL_WITH_IDQ T where not exists ( DATE = '11.11.2011' ) // sql does not the job Database is a Oracle 11g. maybe someone can help me?

  Read the article

• SqlCommand to T-SQL

  - by Net Elemental

  Hello! Is there any way how to convert SqlCommand object to actual T-SQL command, which is sent to the SQL Server?

  Read the article

• Connect to web-service/API in MySQL?

  - by Jesse Figueroa

  I'm creating a sql based procedure which can Accept a table load the values one at a time send the variables to a remote API Record the response of the API Write the response to a table for viewing later I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!

  Read the article

• java beginner- in which folder should I place a "database.properties" file

  - by Arvind

  I read some tutorials on how to read data from a database.properties file- which basically stored key-value pairs. What i want to know is, in which folder should I place this file? Is it in the root (ie "src") or within a package... And how do I access this file, if it is placed in "src"- my code will be within a package (and the package's directory will be under src)- so how do I access the properties file, which is in "src", from a class within a package?

  Read the article

• DataContext to DB

  - by JD

  Hi all, I have designed my DB using the ORM in VS 2008. What is the best way to export this to an SQL server so it will create the tables and relations on SQL Server? Thanks, JD

  Read the article

• jQuery datepicker calendar - call to function updates database

  - by erbaker

  So I'm using the datepicker plugin to make an availability calendar. Here is my javascript: http://pastebin.com/H7D9PcAg When dpSetSelected() is called it is also calling dateSelected() which triggers the AJAX call to my PHP script. I need a way to only update the database if the date is clicked on and not pre-loaded. When I pre-load the dates they are sent to the PHP page and subsequently removed.

  Read the article

• Transmogrify into date from multiple columns

  - by Dave Jarvis

  What is a better way to program the following SQL: str_to_date( concat(convert(D.DAY, CHAR(2)), '-', convert(M.MONTH, CHAR(2)), '-', convert(M.YEAR, CHAR(4))), '%e-%m-%Y' ) as AMOUNT_DATE I want to convert the columns D.DAY, M.MONTH, and M.YEAR to a date field using MySQL. The above works, but seems much more complicated than it needs to be. (If there's an ANSI SQL way to do it, that would be even better.) Thank you!

  Read the article

• How to use DataPager with Database Paged

  - by Fujiy

  I am using ListView/DataPager. For performance reasons I page my results at database, using ROW_NUMBER(SQl2005). At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?

  Read the article

• Databases: Migrate data between MS Access DB and MYSQL

  - by Dean

  Hello, I have 2 databases, one is MS Access DB from an old website, and the other one is MYSQL from the new Joomla+VirtueMart based website. I need to migrate existing products from MS Access to MYSQL. I thought of putting both on server and writing SQL queries in MYSQL workbench, untill I have a good script for that, but I'm very new to SQL, so I'd rather avoid that. I there a better way and more efficient for that?

  Read the article

• Programmatically creating linked tables in access

  - by newtoaccess

  Hi all, We need to find a way to programatically *link all the tables* in a SQL Server database to an access db. We will be invoking this access database from a program that uses .net/SQL Server 2008. While invoking the application we would like to add the linked tables so that the users can just run the reports/modules from access without having to worry about linking the tables. Is there a way we can do this? Thanks!

  Read the article

• Compact and Repair Database programatically

  - by Smashery

  How can I call Access's Compact and Repair Database utility from within C++? I'm already using ADO and ADOX, so a solution using either of those would be handy.

  Read the article

• [RAILS] Howto to download a file from a http and save it into database

  - by Chris

  Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary (I am not trying to do an upload form) Any clue on the way to do that ? Thank you

  Read the article

• Eclipse Debug Mode disrupting MSSQL Server 2005 Stored Procedure access

  - by Sathish

  We have a strange problem in our team. When a developer is using Eclipse in Debug mode, MS SQL Server 2005 blocks other developers from accessing a stored procedure. Debug session typically involves opening Hibernate session to persist an entity which could be accessing a stored procedure used for Primary key generation. Debugging is done in business logic code and rarely in JDBC stored procedure call. Is there any way to configure MS SQL server or the stored procedure so that other developers are not blocked?

  Read the article

• How can seam-gen customized to support another database

  - by stacker

  I would like to create an application from a database schema using seam-gen, unfortunatly informix isn't supported out of the box. Where can I add another db?

  Read the article

< Previous Page | 665 666 667 668 669 670 671 672 673 674 675 676  | Next Page >