Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 557/1278 | < Previous Page | 553 554 555 556 557 558 559 560 561 562 563 564  | Next Page >

• Which kinds of queries is better for querying against conceptual model in Entity Framework?

  - by masoud ramezani

  There are 3 way for querying against conceptual model in EF : LINQ to Entity Entity SQL Query Builder Methods Which one is better for which situation? Is there any performance issues for these 3 type of querying?

  Read the article

• How do I protect against cross-site scripting?

  - by shahinkian

  I am using php, mysql with smarty and I places where users can put comments and etc. I've already escaped characters before inserting into database for SQL Injection. What else do I need to do?

  Read the article

• set datasource crystal report 10 at runtime using vb 6.0 and SQL server 2005

  - by rah.deex

  Please help... I am so confused, how to set Crystal Report 10 data source at runtime using VB 6.0. I am using SQL SERVER 2005 for database and I create the reports using stored procedure.. do You have any idea to solve my problem ? thanks before..

  Read the article

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 553 554 555 556 557 558 559 560 561 562 563 564  | Next Page >