Search Results

Search found 31546 results on 1262 pages for 'sql white papers'.

Page 538/1262 | < Previous Page | 534 535 536 537 538 539 540 541 542 543 544 545  | Next Page >

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• How do I combine two rows of same part, but add quantities?

  - by Tom

  I have table "PICKITEM" PARTID QTY A 1 A 3 B 11 C 8 D 5 D 3 I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is PARTID QTY A 4 B 11 C 8 D 8 Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!

  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

• SQL Join only returning 1 row.

  - by kevin

  Not quite sure what I'm missing, but my SQL statement is only returning one row. SELECT tl.*, (tl.topic_total_rating/tl.topic_rates) as topic_rating, COUNT(pl.post_id) - 1 as reply_count, MIN(pl.post_time) AS topic_time, MAX(pl.post_time) AS topic_bump FROM topic_list tl JOIN post_list pl ON tl.topic_id=pl.post_parent WHERE tl.topic_board_link = %i AND topic_hidden != 1 ORDER BY %s I have two tables (post_list and topic_list), and post_list's post_parent links to a topic_list's topic_id. Instead of returning all the topics (where their board's topic_board_link is n), it only returns one topic.

  Read the article

• Setting MySQL column names

  - by Richard Mar.

  Say I have these tables: people(id, name), cars(person_id, car) and this query: SELECT c.car FROM people as p, cars as c WHERE c.person_id = p.id AND p.id = 3 I want the c.car column to take its name from the name field in the people table, like this (invalid SQL, just to illustrate): SELECT c.car AS(SELECT name FROM people WHERE id = 3) How do I do that?

  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

• Convert bit to boolean string in HyperLinkField.DataNavigateUrlFormatString

  - by abatishchev

  I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1} Select command of appropriate SqlDataSource returns columns of type INT and BIT (from SQL Server 2008). So displayed string becomes something like View.aspx?id=1&isTechnical=1. But I want to display isTechnical=true|False, i.e. Convert.ToBoolean(row["isTechnical"]).ToString().ToLowerInvariant(). How to implement such conversion in page markup?

  Read the article

• MYSQL Select Statment with Modification to tuple values

  - by mouthpiec

  Hi, I have the following table: bar_id, bar_name, subscription_id_fk, sub_name eg: 1, Hard Rock, 2, Gold 2, TGIF, 1, Free Now I need and SQL to extract this table, but where sub_name = Gold, I need to double the subscription_id_fk. Can you please help ?

  Read the article

• VS2010 - Font colors for numbers in SQL scripts

  - by Brandon Montgomery

  OK, see the numbers? I can barely see them because my Visual Studio 2010 theme has the backround as almost-black, and the numbers show up in the default color, which is black. I can't figure out which setting changes the color for a number in a .sql file. Does anyone know?

  Read the article

• Coping Indexes from old database to new one?

  - by AmRoSH

  Hi, I converted an old sql server database from 2000 to 2005 and forgetten to add old indexes to the new db. is there any way to copy the old indexes to the new db? any help?

  Read the article

• last queries mysql v$sql

  - by soField

  i have oracle background, i am looking for oracle v$sql view in mysql in order to see last queries has been run on all sessions in database how can i see this in mysql ?

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

• 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

• Shrinking database

  - by user301751

  I have been tasked to shrink a SQL server 2005 database. This ia a live database and is runing at about 35gb. How do I shrink a database? Can this be done while that database is live? How big will that database bw when it has been shrunk? Thanks in advance.

  Read the article

• How can I query all rows that are currently before data specified in one column in table?

  - by newbie

  I need to get all rows tha are valid, ValidDate is column that shows how long these database items are valid. I need to get only valid items from the database. How can I do that? I use SQL Server.

  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

• What does ON [PRIMARY] mean?

  - by Icono123

  I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of the script: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[be_Categories]( [CategoryID] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_be_Categories_CategoryID] DEFAULT (newid()), [CategoryName] [nvarchar](50) NULL, [Description] [nvarchar](200) NULL, [ParentID] [uniqueidentifier] NULL, CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED ( [CategoryID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO Does anyone know what the ON [PRIMARY] command does? Regards.

  Read the article

• access: getting create table string

  - by every_answer_gets_a_point

  i have a table in access and i would like to get the SQL string from it that will generate the table like: CREATE TABLE example ( id INT, data VARCHAR(100) ); is there any way to do this?

  Read the article

• Find units with zero categories

  - by Kevin Sedgley

  Hello, I am after an SQL command to find units with no categories. Here are the tables: Unit id name UnitCategory id name UnitCategoryIndex id categoryid unitid Thanks!

  Read the article

• how to retrieve images from database and display in div using java script

  - by mehul9595

  Hii, I want to retrieve data from sql database and display dynamically in div using javascript can anyone please help me on this... Thanks...

  Read the article

• Can anybody help me for the syntax of select query?

  - by Azka

  i`m doing string sql = "select * from publisher where title like "'"+tbproperty.text+"; but it`s not working! regards..

  Read the article

• i have a date (eg: 2010-04-17 ) i need the date of after 20 days from this date

  - by Ranjana

  i have a date (eg: 2010-04-17 ) i need the date of after 20 days from this date How to get the date after 20 days i.e next month some date. either in sql or in c#

  Read the article

• extarct characters using delimiters

  - by susanthosh

  I am having string called '200_CFL_2010'. I wish to get the characters between _'s. I want the output as 'CFL'. I have to achieve it through SQL. Any idea please?

  Read the article

• The table '#sql-5f8_9c' is full

  - by gansodesoya

  hello, im trying to delete a foreign key with the following syntax (5.0.45-community-nt): alter table [table] drop foreign key [fk_name] but I'm getting the folling error: The table '#sql-5f8_9c' is full – 99543 ms any ideas? thanks!

  Read the article

< Previous Page | 534 535 536 537 538 539 540 541 542 543 544 545  | Next Page >