Search Results

Search found 27658 results on 1107 pages for 'sql dba'.

Page 515/1107 | < Previous Page | 511 512 513 514 515 516 517 518 519 520 521 522  | Next Page >

• Online validators, syntax checkers, testing tools

  - by Max Gontar

  I often need to verify some simple code before posting, and it's great if I have installed IDE, but what if not? It would be nice to have online free tools for SQL, VB.NET, C# code validation, or maybe even testing. EDIT What I actually mean are online live web tools, like JSLint for javascript. Have you seen any?

  Read the article

• FirstOrDefault In F#

  - by build_your_web

  How to write FirstOrDefault Linq Query in F#? Can I use linq to sql in F# in totally?

  Read the article

• What does it mean: SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": co

  - by Z77

  I tried to create exactly the same but new table from old table in another database using dblink. This procedure used to worked last two times, but this time I got message: "SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query." Anyone knows where is the problem or how to solve it? Please!

  Read the article

• Image insertion from SQL info

  - by user528057

  What does 'howard.jpg' do in the sql statement below & how do I insert the image into my android app? CREATE TABLE IF NOT EXISTS employee ( _id INTEGER PRIMARY KEY AUTOINCREMENT, firstName VARCHAR(50), lastName VARCHAR(50), title VARCHAR(50), department VARCHAR(50), managerId INTEGER, city VARCHAR(50), officePhone VARCHAR(30), cellPhone VARCHAR(30), email VARCHAR(30), picture VARCHAR(200)) INSERT INTO employee VALUES(1,'Ryan','Howard','Vice President, North East', 'Management', NULL, 'Scranton','570-999-8888','570-999-8887','[email protected]','howard.jpg')

  Read the article

• Strip OLE header information (MS Access / SQL Server)

  - by crimson13

  I have a C++ application that needs to support binary database content (images, etc). When using MS Access or MS SQL Server this data is wrapped inside an OLE object. How do I strip this OLE header information? Note that I can't just look for the beginning of a specific tag as the content can be png, jpg and a whole heap of other formats. Should I use something like COleDataObject?

  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

• SQL Query to truncate table in IBM DB2

  - by Cshah

  Hi, Can any one give me the syntax to truncate a table in IBM DB2. I m running the following command: truncate table tableName immediate; The eror is DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=table;truncate ;JOIN , DRIVER=3.50.152 Message: An unexpected token "table" was found following "truncate ". Expected tokens may include: "JOIN ".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152 The syntax matches the one specified in the reference docs of IBM : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_truncate.htm

  Read the article

• System.Data.Common.DbDataReader

  - by Craig Johnston

  If I use this class to do a SELECT * FROM ... statement against a database, what method or variable of this class should I use just to give me a dump of the output from the SQL statement?

  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

• Where can I find an introduction to using PDO?

  - by aslum

  I know my SQL safety isn't up to par. I've read on this site that PHP PDO would be a good first step, and while I did take a look at the PDO Manual it's a bit daunting. Is there somewhere I can find a tutorial on the basics of using PDO rather then straight MySQL calls?

  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 there any better search method instead of string.Contains("keyword") using asp.net?

  - by Mike108

  For example, the users of our app want to search products by entering a keyword of productName. The Products table of the sql server database contains about 10 million records. Is there any better and higher-performance search method implement instead of productName.Contains("keyword") using asp.net C# ?

  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 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

• 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 force username and password entry in C# / VS web app?

  - by salvationishere

  I am trying to force user to enter username and password when they run my C#/SQL web application. This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is: But it still doesn't prompt for a username and password. What am I missing?

  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 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

• How to create sql insert query dynamically in mysql

  - by nectar

  I am creating an application where I am generating pins dynamically based on user's input and storing them into mySql database. $sql = "INSERT INTO tblpin ('pinId', 'ownerId', 'usedby', 'status') VALUES for($i=0;$i<$npin;$i++) { ('$pin[$i]','$ownerid', 'Free', '1'); } ;"; how can I do that?

  Read the article

• Refresh tables in Visual Studio?

  - by Curtis White

  How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express. The clear results does not seem to refresh.

  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

• 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

• 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

• 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

< Previous Page | 511 512 513 514 515 516 517 518 519 520 521 522  | Next Page >