Search Results

Search found 47861 results on 1915 pages for 'sql update'.

Page 293/1915 | < Previous Page | 289 290 291 292 293 294 295 296 297 298 299 300  | Next Page >

• Is this SQL is valid?

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  Read the article

• SQL - sub count

  - by Andy Clarke

  Hi I've got some SQL ... SELECT AdviceNo, Registration FROM tblSalesDetail that produces something like ... ADV00001, ABC123 ADV00001, CDE564 ADV00002, FGE432 ADV00003, HUY789 ADV00003, MJS532 ADV00003, JFY428 Can anyone tell me how I'd adjust it to see the following please? ADV00001, ABC123, 1 ADV00001, CDE564, 2 ADV00002, FGE432, 1 ADV00003, HUY789, 1 ADV00003, MJS532, 2 ADV00003, JFY428, 3

  Read the article

• Select random line in SQL database

  - by Jensen

  Hi, I would like to select a random line in my database. I saw this solution on a website: SELECT column FROM table ORDER BY RAND() LIMIT 1 This SQL query run but someone said me that it was a non performant query. Is there another solution ? Thx

  Read the article

• Embedding SQL Server into a .NET application

  - by Leszek Laszka

  Hey, I've just finished writing a VB.NET application. Now I want to package the executable and the database ofcourse into a single installer file. I tried using QSetup, InstallShield to make SQL Server embedded into the setup file, and finally after hours of try&fail I have no idea. Anyone?

  Read the article

• Show Detailed Error in SQL Profiler

  - by AlwaysBeCoding

  Is there any way showing the detailed exception for String or binary data would be truncated. I use LINQ to SQL and i cant figure out which column is that!? Tried numerous things but i get the same meaningless error i got from within Visual Studio. Also I use .NET 3.5 SP1, but errors are still returned useless.

  Read the article

• what is index in sql server?

  - by Surya sasidhar

  Hi, what is index in sql can u explain or any reference to understand clearly. where should i use the index. I search in stackoverflow but it is not clear for me. thank you

  Read the article

• how to compare the values inside a table in sql

  - by Ranjana

  how to compare the values of same table(say for eg: Order table) each and every time the record get inserted , if the record with same values get inserted already in same table i should not insert the new record with same values. how to do that exactly in sql server 2008

  Read the article

• problem with IN clause in SQL

  - by user179056

  Hello, We have observed that there seems to be a maximum number of ids/variables which one can pass in the IN clause of SQL as comma seperated values. To avoid this we are storing all the ids in a table and doing a SELECT within the IN clause. This however means extra database operations to store and retrieve ids. Is there any other way to use IN without SELECT? regards Sameer

  Read the article

• convert to UDF from select statement

  - by jeff

  How would one go about converting this into a UDF? I'll pass the product_id to the UDF. Running SQL 2k5 SELECT sum(qty) as qty, product_id FROM vProductQuantity WHERE product_id = @product_id GROUP BY product_id

  Read the article

• Agregate rows in Oracle SQL statement

  - by kilikopela

  Hi, I have a table of items stored this way : A1 | B1 A1 | B2 A1 | B3 A2 | B1 A2 | B4 ... And I need to retrieve with a SQL Query : A1 | B1, B2, B3 A2 | B1, B4 ...

  Read the article

• SQL Select -> product -> comments -> user

  - by user1492716

  thanks for yout time helping on this ;) I'm new to SQL and wish to solve somethign in just one query and i dont know how to do it.- Basically I've a table of products, a table of users and a table of comments, linked by products.id - comments.pid and user.id - comments.uid , i wish to know what is the best practice to create just 1 query and get all products with child comments, including username.

  Read the article

• show data from sql server in blackberry using .Net

  - by Cuil

  Hi all, i want to ask about development in blackberry. I have background in .Net winform. If i want to develop an application to show data from Ms.SQL server 2008 database in blackberry. what should i learn and what should i do ? thank you for your advice.

  Read the article

• what are the uses of the different join operations in sql

  - by varunthacker

  what are the uses of the different join operations in sql? Like i want to know why do we need the different inner and outer joins?

  Read the article

• Help with random - sql server 2008 query

  - by Gold

  hi i have 4000 records, and i need to pick randomize 500 records. i need that 500 records will insert to GoodTable and the rest 3500 records will insert to BadTable how to do it using sql-server 2008 query ? thank's in advance

  Read the article

• mssql Is it possible to get procedure or table creation and last alter date?

  - by Woland

  mssql Is it possible to get procedure or table creation and last alter date? If it is then how do to it? Ms sql 2005 server

  Read the article

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  Read the article

• [SQL server] How to insert artificial data into a select statement

  - by user149578

  Hi guys: Suppose we got a original query as follows: SELECT A, B, C FROM tblA Now, I need to additional artificial rows like SELECT 'Kyala', B, C FROM tblA when, for example, C = 100 to be inserted into the resultset. How could I achieve it using a single SQL instead of relying on table variable or temp table?

  Read the article

• Adding A New Row Using SQL Server Management Studio

  - by Soo

  I'm learning how to use SQL Server Management Studio and can't figure out how to insert a new row into a table. Table Structure: ID, Field1, Field2 Query: INSERT INTO Table (Field1,Field2) VALUES(1,2) Error: Major Error 0x80040E14, Minor Error 25503 I'm probably missing something very noobie like. Any help would be appreciated.

  Read the article

• How to reverse a string (SQL Server 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL Server 2005

  Read the article

• Database schema last updated date.

  - by pencilslate

  How to find out the last date and timestamp of schema updation in SQL Server database. I could locate the database created and last back up date from properties. But, couldn't find the last schema updated date. Is there a way to find this out?

  Read the article

• How to reverse a string(SQL SERVER 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL SERVER 2005

  Read the article

• Convert tax like IRS function to SQL

  - by CrashRoX

  Trying to convert this tax-like IRS function http://stackoverflow.com/questions/1817920/calculating-revenue-share-at-different-tiers to SQL. The assumption is the table would be one column (price) and the tiers will be added dynamically. My first attempt has some case statements that didn't work out well. I have since scrapped it :) Thanks for the help!

  Read the article

• Problem with user logins after db Restore

  - by JJgates

  I have two SQL 2005 instances that reside on different networks. I need to backup a database from instance A and restore it to a database in instance B on a weekly basis so that both databases hold the same data. After the restore, logins SIDS on database B are changed and therefore users can't log into database B and connection strings for the web application it supports are broken. Is there a work around for this? Thanks.

  Read the article

• is it possible to select EXISTS directly as a bit?

  - by jcollum

  I was wondering if it's possible to do something like this (which doesn't work): select cast( (exists(select * from theTable where theColumn like 'theValue%') as bit) Seems like it should be doable, but lots of things that should work in SQL don't ;) I've seen workarounds for this (SELECT 1 where... Exists...) but it seems like I should be able to just cast the result of the exists function as a bit and be done with it.

  Read the article

• what is a candidate row in SQL?

  - by JuiceBerry123

  What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such: "The candidate row is fetched from the table specified in the outer query."

  Read the article

< Previous Page | 289 290 291 292 293 294 295 296 297 298 299 300  | Next Page >