Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 289/2509 | < Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >

• The right way to write "ID" in columns in SQL

  - by radbyx

  My first question in here. I like the site so much :) I've a SQL table called Product. In that table I want to make a column for the ID of the product, and I really like to now the right way of write ID because I make alot of ID columns in the long run. So is it: "ID" or "Id" ? And also a foreign key in another table, is that called ProductID or ProductId? Thx guys.

  Read the article

• Generating SQL for website

  - by Ethan

  I am working on a webapplication How can i create SQL for the following Database Information User information Username - String Password - String Admin or Client - boolean Last login – Date/Time LogItem typeLogItem – String (Page name?) hitCount – int View PageURL UserID Transaction User – String DateTimeStamp SKU – int Purchase-boolean TransactionID-int Inventory information Sku number - int Item description - String Price to customer - double Count - in

  Read the article

• Query for second maximum salary from employee table

  - by Dinesh

  how to find out second maximum salary from all employee in employee table ? please give me sql query.

  Read the article

• LINQ-to-SQL eagerly load entire object graph

  - by Paddy

  I have a need to load an entire LINQ-to-SQL object graph from a certain point downwards, loading all child collections and the objects within them etc. This is going to be used to dump out the object structure and data to XML. Is there a way to do this without generating a large hard coded set of DataLoadOptions to 'shape' my data?

  Read the article

• SQL SERVER 2005 Self Joins output

  - by user301751

  HI I am looking for some help I just can't seem to get my head how self joins work. I have this sql code select Persno'Name',convert(char(20), A_Date , 13)'Logins',acode from atrail as LOGIN where acode = 'LOGIN' OR acode = 'LOGOUT' order by a_date desc Which produces a list of User names and when the have logged in and out. What I am trying to acheive is to get anther column with the LOGOUT date next to the date they logged in date so that it is easyer to see when they logged in and out. Thanks Andy

  Read the article

• SQL Injection in a Non-Web Application.

  - by The Rook

  Does someone know of a good example of a SQL Injection vulnerability that isn't in a web application? I am looking for a real vulnerability, not speculation. The following picture is an example of a speculated attack.

  Read the article

• continue statement in pl/SQl?

  - by i2ijeya

  I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If not, please let me know the solution for this.

  Read the article

• Recursive SQL, have the last three values increased?

  - by Mike

  Hi, I have a table that looks like this: ---------------------- | DateTime | Value | ---------------------- | 2010-01-01 | 26 | | 2010-02-01 | 24 | | 2010-03-01 | 23 | | 2010-04-01 | 28 | | 2010-05-01 | 30 | I need to find if the last three consecutive months have increased in value. How can I get SQL to check whether the value for each has increased? If anyone can give me any pointers for solving this problem it would be greatly appreciated! Thanks

  Read the article

• Database persistence without an SQL server

  - by James P.

  I'm seeking a solution that would allow persistence without requiring an SQL server to be installed on the host and could be bundled along with a desktop application. Does such a thing exist?

  Read the article

• SQL Query to delete records older than two years

  - by Garrett Dumas

  I need to clean out a very bloated SQL database by deleting records that are older than two years from a number of tables. What is the most efficient way of doing this? Thanks in advance.

  Read the article

• What is the sql statement for searching in text using MS SQL Server 2008?

  - by SzamDev

  Hi If I have text sotred in my DB, for example: "There are 2 books on the table". Maybe the user wants to search for "books" or the user wants to search in this text for any thing. What is the best SQL Statement to do that?. Thanks in advance.

  Read the article

• Updating a sql server table with data from another table

  - by David G

  I have two basic SQL Server tables: Customer (ID [pk], AddressLine1, AddressLine2, AddressCity, AddressDistrict, AddressPostalCode) CustomerAddress(ID [pk], CustomerID [fk], Line1, Line2, City, District, PostalCode) CustomerAddress contains multiple addresses for the Customer record. For each Customer record I want to merge the most recent CustomerAddress record where most recent is determined by the highest CustomerAddress ID value. I've currently got the following: UPDATE Customer SET AddressLine1 = CustomerAddress.Line1, AddressPostalCode = CustomerAddress.PostalCode FROM Customer, CustomerAddress WHERE Customer.ID = CustomerAddress.CustomerID which works but how can I ensure that the most recent (highest ID) CustomerAddress record is selected to update the Customer table?

  Read the article

• looking for a good free online tutorial on sql

  - by Richard

  Looking for a good tutorial for the complete beginner on sql. I need to know how to start up a development server as well. thanks

  Read the article

• What is the result of this SQL query?

  - by Martin

  I'm working on a mock exam paper at the moment, however I have no set of correct answers and I'm not sure what the correct answer of this SQL query is. Given a table: foo, bar a , 1 b , 3 a , 2 c , 1 and the query: SELECT foo, sum(bar) FROM table GROUP BY foo The two ways I can see this going are either: a 3 a 3 b 3 c 1 or a 3 b 3 c 1 Thanks.

  Read the article

• SQL injection attempt on my server

  - by Jan Kuboschek

  I know a little about SQL injections and URL decode, but can someone who's more of an expert than me on this matter take a look at the following string and tell me what exactly it's trying to do? Some kid from Beijing a couple weeks ago tried a number of injections like the one below. %27%20and%20char(124)%2Buser%2Bchar(124)=0%20and%20%27%27=%27

  Read the article

• C# Sql Server 2005 Bulk XML Delete?

  - by Goober

  I know you can do bulk XML inserts into SQL Server 2005 tables from your C# code using datasets/datatables. Is it possible to do the same but as a delete?

  Read the article

• Sample Employe MS SQL Database with data (surname, name, age, address)

  - by Tom

  Hi I need some sample MS SQL Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample. Can any body help ?

  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

• Difference between SQL Server and Oracle 'User'

  - by BeginnerAmongBeginners

  Are there any differences between a user in SQL Server and one in Oracle? If so, what are they? Thanks in advance.

  Read the article

• How do I prevent sql injection with php and mysql

  - by herrturtur

  I have a form into which the visitor can enter data, and I want to store this data in a mysql database via the $_POST variable. What do I need to prevent sql injection?

  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

• what if system crashes when i type SQL command

  - by user323422

  I have some doubt as follows We are UPDATING a field in SQL and ALTER the row also.After giving the COMMIT command the system is crashed.Wat will happen to the commands given,whether it will UPDATE and ALTER the table r not?

  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

• SQL Server 2000 pivot without temporary tables?

  - by Apocatastasis

  Hi. I'm trying to pivot some data in SQL Server 2000, but the user that runs the application only have read/write permissions. I've looked the solutions posted here, but all involving create/destroy temporary tables.

  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

< Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >