Search Results

Search found 79317 results on 3173 pages for 'sql error messages'.

Page 220/3173 | < Previous Page | 216 217 218 219 220 221 222 223 224 225 226 227  | Next Page >

• LINQ to SQL or Entities, at this point?

  - by orlon

  I'm a bit late to the game and have decided to spend some spare time learning LINQ. As an exercise, I'm going to rewrite a WebForms app in MVC 2 (which is also new to me). I managed to find a few topics regarding LINQ here (http://stackoverflow.com/questions/16322/learning-about-linq, http://stackoverflow.com/questions/8050/beginners-guide-to-linq,…

  Read the article

• SQL Server Express 2008 using (local) in connection string

  - by Jeff

  Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works,…

  Read the article

• SQL: convert backup file from copy format to insert format

  - by takeshin

  I have a PostgreSQL backup made with PHPPgadmin using Export Copy (instead Copy SQL which is actually what I need). File contains entries like this: COPY tablename(id, field) FROM stdin; ... How to convert this file to SQL format? INSERT INTO tablename... I want to use Pgadmin to to import this file using execute SQL command.

  Read the article

• What the linq query for SQL like and Soudex for sql server 2008?

  - by KentZhou

  In sql server, we can issue sql to get data like select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann') what's the linq query to match above sql?

  Read the article

• How to test my Firebird SQL queries

  - by Bob

  I'm in the process of learning SQL, and I need a way of verifying that my SQL queries are valid (i.e. no syntax errors). I also would like to check what results they yield on a test database of my choosing and structure. I'm using embedded firebird in my C# .NET application, so I don't really have any tools to work with. Anyone have any tips?…

  Read the article

• SQL-Server: Is there an equivalent of a trigger for general stored procedure execution

  - by Arj

  Hi All, Hope you can help. Is there a way to reliably detect when a stored proc is being run on SQL Server without altering the SP itself? Here's the requirement. We need to track users running reports from our enterprise data warehouse as the core product we use doesn't allow for this. Both core product reports and a slew of in-house ones…

  Read the article

• SQL: Recursive Path

  - by Chris

  Is it possible to create a "tree resolver" in SQL? I have a table: ID Name Parent 1 a 2 b 1 3 c 1 4 d 3 Now I want a SQL query that returns: ID PATH 1 /a 2 /a/b 3 /a/c 4 /a/c/d Is this possible with SQL? It would make many things easier for me. Any help would really be appreciated!

  Read the article

• Table transformation / field parsing in PL/SQL

  - by IMHO

  I have de-normalized table, something like CODES ID | VALUE 10 | A,B,C 11 | A,B 12 | A,B,C,D,E,F 13 | R,T,D,W,W,W,W,W,S,S The job is to convert is where each token from VALUE will generate new record. Example: CODES_TRANS ID | VALUE_TRANS 10 | A 10 | B 10 | C 11 | A 11 | B What is the best way to do it in PL/SQL without…

  Read the article

• SQL Server Native Client API examples

  - by ebasconp

  Hi everybody: I am writing a C++ application that needs to execute SQL queries in a SQL Server DB and I want to do it using SQL Server Native Client. The MSDN documentation has no a full reference on it and has a few examples so I am looking for some site having more information on how to connect, execute queries and retrieve results…

  Read the article

• Local and Global temporary table in SQL SERVER

  - by jammkie same

  What is the difference between Local and Global temporary table in sql server

  Read the article

• Conversion failed when converting the varchar value xxx to data type int error

  - by zurna

  I need to take data between certain dates. But I get the following error. AdsDateStarted : 03/18/2010 01:51:38.000 AM AdsDateENded : 09/13/2010 05:00:00.000 PM formatdate function converts today's date to 3/22/2010 format. SQL = "SELECT * FROM Ads" SQL = SQL & " WHERE AdsActive = 1 AND AdsAreasID = "& rtt &" AND…

  Read the article

• how to pass arguement in sql query

  - by Anil

  how to pass arguement in sql query

  Read the article

• Finding rank of the student -Sql Compact

  - by Jankhana

  I have a table like this : Name Mar1 Mar2 Mar3 Total xxx 80 80 80 240 yyy 60 70 50 180 aaa 85 65 75 225 I wanted to find the rank of the student based on total. I using SQL Compact 3.5 . As we have rank() function in sql server do we have something with which we can find the students rank??? When I…

  Read the article

• Spring's JdbcDaoSupport (using MySQL Connector/J) fails after executing sql that adds FK

  - by John

  I am using Spring's JdbcDaoSupport class with a DriverManagerDataSource using the MySQL Connector/J 5.0 driver (driverClassName=com.mysql.jdbc.driver). allowMultiQueries is set to true in the url. My application is an in-house tool we recently developed that executes sql scripts in a directory one-by-one (allows us to…

  Read the article

• ASP can't connect to SQL Server database

  - by birdus

  I'm trying to get a classic ASP application to connect to a local SQL Server 2008 database. The app and database were built by someone else. I'm just trying to get them installed and running on my machine (Windows 7). I'm getting the following error when when the ASP app tries to connect to the database: Could not…

  Read the article

• What are some "mental steps" a developer must take to begin moving from SQL to NO-SQL (CouchDB, Fath

  - by Byron Sommardahl

  I have my mind firmly wrapped around relational databases and how to code efficiently against them. Most of my experience is with MySQL and SQL. I like many of the things I'm hearing about document-based databases, especially when someone in a recent podcast mentioned huge performance benefits. So, if I'm going to…

  Read the article

• Multitenant NHibernate application with with separate SQL Server schema for each tenant

  - by Branko

  I am writing a new multi-tenant WCF RIA application. I plan to have a shared database with separate SQL Server schema for each tenant. I would like to use NHibernate for object-ralational mapping. Configuration of SQL Server schema in mapping classes doesn't help because it is static and would need one set of…

  Read the article

• how to find top three highest salary in emp table in oracle(sql)

  - by SunilRai86

  how to find top three highest salary in emp table in oracle(sql)

  Read the article

• Trouble creating a SQL query

  - by JoBu1324

  I've been thinking about how to compose this SQL query for a while now, but after thinking about it for a few hours I thought I'd ask the SO community to see if they have any ideas. Here is a mock up of the relevant portion of the tables: contracts id date ar (yes/no) term payments contract_id…

  Read the article

• SQL Server error handling: exceptions and the database-client contract

  - by gbn

  We’re a team of SQL Servers database developers. Our clients are a mixed bag of C#/ASP.NET, C# and Java web services, Java/Unix services and some Excel. Our client developers only use stored procedures that we provide and we expect that (where sensible, of course) they treat them like web service…

  Read the article

• sql server mdf file database attachment

  - by jnsohnumr

  hello all i'm having a bear of a time getting visual studio 2010 (ultimate i think) to properly attach to my database. it was moved from original spot to #MYAPP#/#MYAPP#.Web/App_Data/#MDF_FILE#.mdf. I have three instances of sql server running on this machine. i have tried to replace the old…

  Read the article

• how to design the query for non-sql database

  - by Benny

  can anyone give some reference for non-sql database query interface design pattern? For sql-based database, the query can be achieved by combining the query token. but for non-sql, how to design the query, given that the query could be very complex.

  Read the article

• SQL Replication (subsciber) can't connect to publication

  - by a3code

  I have 2 Virtual Machines, One with MS SQL server 2008 R2, other with MS SQL Server 2012 Express.... On 1 I have configuration for replication (publication), and I would like to setup Express version like subscriber. but I can't to connect to publisher SQL Server replication requires the…

  Read the article

• relating data stored in NoSQL DB to data stored in SQL DB

  - by seanbrant

  Whats the best way to use a SQL DB along side a NoSQL DB? I want to keep my users and other data in postgres but have some data that would be better suited for a NoSQL DB like redis. I see a lot of talk about switching to NoSQL but little talk on integrating it with existing systems. I…

  Read the article

• Future of Linq to Sql and Entity Framework

  - by ENES TAYLAN

  I work on a project and want to use an ORM. What should I use: Linq to Sql or Entity Framework? Linq to Sql provides more opportunities, as I see, for example support for enumeration types. However, also it is said that, Linq to Sql was for playing and learning for Linq and future strategy…

  Read the article

< Previous Page | 216 217 218 219 220 221 222 223 224 225 226 227  | Next Page >