Search Results

Search found 35019 results on 1401 pages for 'sql documentation'.

Page 552/1401 | < Previous Page | 548 549 550 551 552 553 554 555 556 557 558 559  | Next Page >

• Best Embedded SQL DB for write performance?

  - by max.minimus

  Has anybody done any benchmarking/evaluation of the popular open-source embedded SQL DBs for performance, particularly write performance? I've some 1:1 comparisons for sqlite, Firebird Embedded, Derby and HSQLDB (others I am missing?) but no across the board comparisons... Also, I'd be interested in the overall developer experience for any of these (for a Java app).

  Read the article

• How to speed up saving data to database over internet?

  - by robert_d

  I am using C#, Entity Framework and SQL Server 2008 Express. I am connected to the database over internet. What is the best method to speed up saving/updating data to database? It takes 60 seconds to save 140 records to database.

  Read the article

• How to generate script/stored procedure to copy data from one database to another

  - by aein

  I had to restore may database to 1 day erlier, so My database is missing data from a day before, and this databse has been used by users since the restoration. How do I generate script/stored procedure to copy just the missing data from the backup database into my current database. There are PK and FK relationships that need to be considering. I'm using SQL server 2005 Thanks for your help. Aein

  Read the article

• How to connect to a database from VC++/CLI .NET 4.0

  - by abatishchev

  How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)

  Read the article

• is it possible to add line from Database to text file in the server ?

  - by Gold

  hi i have sql-server 2008 database that in the main server. i have 10 terminals that connect to this server and work against the database. i need that every new inserting to database through any terminal - in the server this line will inserting to text file (every line) can i do it ? thank's in advance

  Read the article

• Inserting a null value into the database.

  - by J Harley

  Good Morning, Say I have an insert statement: Insert INTO tblTest (fieldOne,FieldTwo,fieldThree) VALUES ('valueOne','valueTwo','null') This statement doesn't seem to want to insert a null value into the database... I have also tried to insert the word "nothing". Has anyone any ideas how to make this work? I am using SQL server 2005.

  Read the article

• How to user IN operator in Linq?

  - by Umapathy

  Query: Select * from pu_Products where Part_Number in ('031832','027861', '028020', '033378') and User_Id = 50 and Is_Deleted = 0 The above mentioned query is in SQL and i need the query might be converted into Linq. Is there any option using the "IN" operator in Linq?. can you convert above mentioned query into Linq?

  Read the article

• how to write a bat file to execute the .sql fiel

  - by ganuke

  I want to execute query in side the db.sql file using MySQL 5.1 in windows environment. Can any one help me to this. I want to do this by runing a bat file.

  Read the article

• In mysql or postgres, is there a limit to the size of an IN (1,2,n) statement?

  - by Kyle

  I've got quite a few SQL statements like such: SELECT foo FROM things WHERE user_id IN (1,2,3..n) Is there a known limit to the number of elements that will safely fit in an IN clause like that?

  Read the article

• Which is better: Ad hoc queries, or stored procedures?

  - by Will

  Assuming you can't use Linq for whatever reason, is it a better practice to place your queries in stored procedures, or is it just as good a practice to execute ad hoc queries against the database (say, Sql Server for argument's sake)?

  Read the article

• What is this query means?

  - by zihado

  I'm reading a book about SQL. In that book, I saw strange query below: "SELECT * into mycustomer from customer WHERE 1=2" In this query, what is "WHERE 1=2" ? Thanks in advance.

  Read the article

• How to remove digits from the end of the string using SQL

  - by user307880

  Please, could you answer my question. How to remove digits from the end of the string using SQL? For example, the string '2Ga4la2009' must be converted to 2Ga4la. The problem is that we can't trim them because we don't know how many digits are in the end of the string. Best regards, Galina.

  Read the article

• Linking database column to dropdown control in ASP.Net

  - by kunal

  I am using c# with asp.net and SQL Server 2005 as backend. I want to use dropdown list control in a form to populate a textbox. The dropdown control is linked to a column in the database. How can I code this in c#?

  Read the article

• Option To AutoFormat Query Syntax in SSMS 2005 or 2008?

  - by dragon77

  In TOAD (for SQL or Oracle), there is a simple AUTOFORMAT button that will nicely format your query - I couldn't find that option in SSMS 2005, but was advised by a co-worker that it was available in SSMS 2008. I am unable to locate the option there either. This is VERY helpful when pasting a query from another source. Thanks for any assistance.

  Read the article

• What's the best method for sanitizing user input with PHP?

  - by UltimateBrent

  Is there a catchall function somewhere that works well for sanitizing user input for sql injection and XSS attacks, while still allowing certain types of html tags?

  Read the article

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• Refreshing data in a java.sql.ResultSet

  - by llm

  I have a java.sql.ResultSet object containg data from a query that was run. How do I refresh the data in the ResultSet to reflect the current data in the database? Thanks!

  Read the article

• How to take a backup of database of sql server 2005 in VB.net Using Code

  - by Darshan Dodiya

  Hi I want to know how to take a backup of database using programatically in VB.net of SQL Server 2005. if you are having and idea about it then pls send me the code for that.

  Read the article

• Anything like GROUP BY that gives you the max value'd field instead of the min?

  - by William

  I'm trying to get the results from this question (SO 2429348 - Help with a SQL query) except I need it to return values 1 and 3.

  Read the article

• Rails activerecord to_sql_string?

  - by pepernik

  I've seen somewhere but can not remember. How to get an SQL from ActiveRecord object? Client.find(1).to_sql_string

  Read the article

• On Update: Auto Update Date/Time Field

  - by Abs

  Hello all, Is there an equivalent of MySQLs on update field for SQL server? With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated. What I am looking for is to have a date/time field and every time I update a record it updates the field with the date/time it was updated automatically? If it doesn't exist, I guess I'll have to go manual. Thanks all

  Read the article

• best encryption method sql server asp.net c#

  - by mazhar kaunain baig

  What is the most standard encryption technique used in sql server for asp.net c# enterprise level application? . i am talking with respect to standards like md5 or sh1 etc, hashing

  Read the article

• Software loading error problem

  - by Gopal

  VB6 & SQL Server 2005 When i run the Windows based Software exe file, it is showing the login page, after login page - no screen is displaying, I checked the task manager, in task manager it is showing as software as running, But there is no page is appearing. Is any firewall blocking or some other issue. But software is running with out displaying anythings. How to solve this issue?

  Read the article

• How to manipulate sql connection string in C#

  - by Liveonthree

  Hi i'm trying to manipulate the sql connection string so instead of running the original copy of our database it runs from the copy one folder up in our C# project.

  Read the article

• ms-access: difference between .value and .text

  - by every_answer_gets_a_point

  i am passing values from a textbox into a sql statement in ACCESS i do not understand the difference in the usage of these two properties when i set the the .text property to something, how does the .value property get affected? when i do want something to be displayed in the textbox should i be using the value or text property?

  Read the article

< Previous Page | 548 549 550 551 552 553 554 555 556 557 558 559  | Next Page >