Search Results

Search found 27339 results on 1094 pages for 'sql dmv'.

Page 510/1094 | < Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >

• SQL to join to the best matching row

  - by williamjones

  I have a wiki system where there is a central table, Article, that has many Revisions in their own table. The Revisions each contain a created_at time and date column. I want to update the Articles to contain a denormalized field sort_name from the most recent Revision's name field. What SQL command can I issue to fill in each Article's sort_name field with its most recent Revision's name field? For what it's worth, I'm on PostgreSQL.

  Read the article

• Data Conversion

  - by cre-johnny07

  How do I convert 0.50 to 50 or 0.1429 to 14.29 in sql query? My data type is real.

  Read the article

• Need to combine common result of two select statements

  - by Anup

  i have to select the common coloumns c1 ,c2,c3 from result of two sql satements. 1) select c1, c2, c3,count(c3) from (select * from form_name where data_created >'1273446000' and data_creazione<'1274569200') group by c1,c2, c3 having count(c3)>1 2) select c1, c2, c3,count(c3) from (select * from form_name where data_created>'1272236400' and data_creazione<'1274569200') group by c1,c2, c3 having count(c3)>2 I need to select c1,c2,c3 all same and common found in both the result of query. how could this be done...could anyone help please?

  Read the article

• Removing Database References from an ASP.NET MVC Site

  - by Maxim Z.

  I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance. Can I completely remove this dependency? If so, how do I get rid of all this database stuff?

  Read the article

• Determine if an Index has been used as a hint

  - by Joe Bloggs

  In SQL Server, there is the option to use query hints. eg SELECT c.ContactID FROM Person.Contact c WITH (INDEX(AK_Contact_rowguid)) I am in the process of getting rid of unused indexes and was wondering how I could go about determining if an index was used as a query hint. Does anyone have suggestions on how I could do this? Cheers, Joe

  Read the article

• Spatial data types support in Linq2Sql or EF4

  - by Colin Desmond

  Does anyone know (ideally, with a reference), whether the VS2010 release of LinqToSQL or EntityFramework v4 will support queries over the SQL 2008 spatial data types?

  Read the article

• Check for Duplicates in a Database Before Entering Data

  - by gamerzfuse

  Before Entering data into a database, I just want to check that the database doesn't have the same username in the database already. I have the username in SQL set as a key, so it can't be duplicated on that end, but I am looking at finding a more user-friendly error message then "KEY already exists". Is there are simple way to check if the variable value already exists in a row? Thanks!

  Read the article

• How to Configure TreeView to display data from SQL Server

  - by Ani

  I have a Browser and I want to display history & favorites of user on webbrowser on button_Click event. Can I accomplish this by using treeview in my form? if not what other way i can use. Data about History and Favorites is stored in SQL server database. Thanks, Ani

  Read the article

• What are maintenance steps and performance steps for Mysql server/database ?

  - by Paresh

  Like index maintenance we have index reorganize/rebuild, update stats, shrink database log files , database backup/restore in MS SQL server, What are maintenance steps and performance steps for Mysql server/database ?

  Read the article

• Looking for a web server that include the following technologies ColdFusion, PHP, MS SQL Server, MyS

  - by Kevin

  Can anyone explain if it is possible to have a web server for all of these technologies: ColdFusion, PHP, MS SQL Server, MySQL I have a web developer insisting that they require all of the above however it doesn't quite make sense to me. Any help or clarification is appreciated.

  Read the article

• Capabilities and pricing of Amazon's cloud computing platform?

  - by ajl

  I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?

  Read the article

• Visual Representation Of Database Schema

  - by Richard Knop

  is there some standard about how to graphically represent database schemas? Is UML a defacto standard for this? Also, is there some free tool that can help me convert an sql file (basically bunch of CREATE TABLE queries) into some nice graph (UML or not UML)?

  Read the article

• How to prevent duplicate records being inserted with SqlBulkCopy?

  - by Pandiya Chendur

  I am inserting a datatable via sqlbulkcopy to a sql server Table.... Consider that if am inserting the same datatable next time the same set of rows are added... How to avoid duplicates in such scenario? Any suggestion....

  Read the article

• Easiest way to create drop down with database generated options

  - by aarontb

  I'm trying to build a multi-level "game". A randomly generated option (Option1) will trigger other options in a drop down (Option2)...the options in the new drop down will be directly related the to Option1. Option2 will then trigger another drop down with info directly related to Option2 and so forth until reaching OptionEnd...any suggestions, preferably SQL and PHP. Thanks...yeah, I'm a n00b.

  Read the article

• T-SQL UNION On 3 Tables!?

  - by Goober

  Is this possible? Using SQL Server 2005....... SELECT * FROM Data0304 UNION SELECT * FROM Data0506 UNION SELECT * FROM Data0708

  Read the article

• How do I dump the data of some SQLite3 tables?

  - by J. Pablo Fernández

  How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)? The dump should be in SQL format, as it should be easily re-entered into the database latter and should be done from the command line. Something like sqlite3 db .dump but without dumping the schema and selecting which tables to dump.

  Read the article

• SQLCE qand C#; Populate a DataSet with ALL the Tables from a SQLCE DB

  - by Zion

  How would I Populate a DataSet with ALL the Tables from a SQLCE DB. Is this possible in ONE SQL select statement? I know that I can call seperate select statements with the names of the table I need data from but I need a generic solution that just dumps all the tables from the SQLCE DB into a Dataset. Thanks

  Read the article

• Please tell me difference between running query directly and executing it using exec

  - by Rajesh Rolen- DotNet Developer

  Please tell me what is difference == if i write query directly in storedprocedure == and write query in string variable and than run it in exec in stored procedure. i am using ms sql server 2005

  Read the article

• Get list of elements and their values from an untyped xml fragment in T-SQL

  - by Kevin

  Similiar to question: http://stackoverflow.com/questions/2266132/how-can-i-get-a-list-of-element-names-from-an-xml-value-in-sql-server How would I also get the values for the list of elements. For example: a1 b1 c1 Would return Element | Value A | a1 B | b1 C | c1

  Read the article

• Visual Studio Setup Project Installer Prerequisite for SQL Server CE

  - by blu

  I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE. I have the following configurations set: Do I need to do anything else, like with a Custom Action or anything like that? Thanks.

  Read the article

• Is it possible to write a query which returns a date for every day between two specified days?

  - by ninesided

  Basically, the question says it all. I need a PL\SQL query that returns a list of dates between two dates such that for 01-JAN-2010 to 20-JAN-2010 I would get 20 rows returned: the_date -------- 01-JAN-2010 02-JAN-2010 03-JAN-2010 04-JAN-2010 ... 20-JAN-2010

  Read the article

• Firebird multiple statements

  - by Aldo

  Hello, is there any way to execute multiple statements (none of which will have to return anything) on Firebird? Like importing a SQL file and executing it. I've been looking for a while and couldn't find anything for this.

  Read the article

• Domain Model + LINQ to SQL sample

  - by lmsasu

  Hello all, I wonder if there is an enterprise application sample, designed with Domain Model in the Business Logic layer and LINQ for the Data Mapper? I'm not so sure of how to use the UnitOfWork ability of LINQ to SQL in conjunction with business objects from the Business Layer. Thanks, Lucian

  Read the article

• sqlsrv_query() for a linux system?

  - by Derek Adair

  This question is related to a previous post. Is there something comparable to sqlsrv_query() on a linux server? Or something extremely simple to parameterize queries for a LAMP(php)/SQL server?

  Read the article

• SQL is declarative, what about LINQ

  - by pokrate

  I can change SQL at runtime. Can I do the same with LINQ ? Can I have LINQ queries coming from an xml file, which I can edit at runtime ?

  Read the article

< Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >