Search Results

Search found 27368 results on 1095 pages for 'msaccess to sql'.

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

• Creating an index on a view with OpenQuery

  - by Sung Meister

  SQL Server doesn't allow creating an view with schema binding where the view query uses OpenQuery as shown below. Is there a way or a walk-around to create an index on such a view?

  Read the article

• SQL GUI Programs

  - by jake

  Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.

  Read the article

• Is there a LINQ equivalent of string.Join(string, string[])

  - by mdresser

  Is there any way to convert a collection of objects into a single new object using LINQ? I want to use this within another LINQ to SQL expression.

  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

• 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

• ASP.NET Membership vs SQL Authentication

  - by Gern Blandston

  For ASP.NET MVC extranet applications, what are the pros and cons of using SQL Authentication instead of the ASP.NET Membership API to handle security?

  Read the article

• How to show the user one day behind messages in Vb.net webform?

  - by ahmed

  I am working on a Incoming and outgoing messages webform, I would like to show the users the only messages in their INBOX of one day behind. I have a dropdown where I'm giving the selection of All and Pending messages. But if the users have any pending messages in INBOX of just one day behind ,they have to choose All to retrieve the messages. So how do I retrieve messages from message table of just one day behind ? I am using SQL 2000 vb.net web application.

  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

• Check if a string contains a substring in SQL Server 2005 Stored Procedure

  - by NLV

  Hello I've a string @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word 'ME' inside @mainString. So how to check if a string has a substring in sql? Thank you Regards NLV

  Read the article

• SQL Bulkcopy using DATA Access block

  - by Sathish

  I am using the below piece of code for SQL Bulk copy using (SqlConnection con = new SqlConnection(strConString)) { con.Open(); SqlBulkCopy sqlBC = new SqlBulkCopy(con); sqlBC.DestinationTableName = "SomeTable"; sqlBC.WriteToServer(dtOppConSummary); } Can anyone provide me the equvalent code using Data access block Enterprise library

  Read the article

• The entity framework and database agnostic programming, possibilities?

  - by Theo

  We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too. It should be easy to switch the db vendor by some setting in a config file. Is this possible? I prefer real life examples! What kind of providers did you use?

  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

• 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

• Invoking a PL/SQL function from EclipseLink

  - by Mark Robinson

  I'm trying to execute a PL/SQL function in EclipseLink which uses Oracle Specific types(eg. Boolean). I've tried using PLSQLStoredProcedureCall which complains that I'm not executing a procedure and I have tried using StoredFunctionCall but that returns PLS-00382: expression is of wrong type Has anyone developed a solution to invoke functions in EclipseLink with Oracle Types? I have heard that it would be possible to extend StoredFunctionCall but I'd rather leverage existing functionality as much as possible.

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

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