Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 279/1278 | < Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >

• SQL Server identity counterpart problem

  - by Guru

  Hi there, I'm using SQL Server and I want to use identity constraint in it I know how to use it in following manner create table mytable ( c1 int primary key identity(1,1); ) the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2.... Thanks in advance, Guru

  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

• Which Tool can generate UML by SQL?

  - by Haiperlink

  I'm searching a tool for generating UML-Diagrams by the import of SQL-Syntax-Files. I need it for personal usage. Best if it's free or if there is a free trial license available.

  Read the article

• How should I access to SQL Server DB?

  - by worlds-apart89

  I have been reading that direct access to a SQL Server database over the Internet is insecure, so I am wondering what intermediary I can and should use between the client and the server. What are the best practices in terms of security and performance?

  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

• What IS NDF Files

  - by Nasser Hajloo

  Every SQL Server databases have lots of files MDF Data LDF Log file ... NDF ? I want to know that what is NDF and whats the benefits of it

  Read the article

• 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

• 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

• 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

• Forward DB requests after a DB move in SQL Server

  - by Nissan Fan

  I've moved database from one SQL Server instance on a machine to another machine completely. Is there any way to forward requests to the new server automatically so it doesn't require client config changes? Keep in mind it's only one DB out of many on the original server so I can't just forward all requests.

  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

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

• what is deadlock in sql server?

  - by VenkatReddy.Ravu

  What is deadlock in sql server and when it arises? What are the issues with deadlock and how to resolve it?

  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

• 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

• 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

• Problem with SQL query

  - by William

  Here's the query INSERT INTO test_bans( ip, Expiration ) VALUES ( "0.0.0.0", DateAdd( "d", 1, Date( ) ) ) Here's the table creation query CREATE TABLE test_bans ( ID smallint(6) NOT NULL AUTO_INCREMENT, IP text NOT NULL, Expiration DATETIME NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM; And here's the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))' at line 1 Please help.

  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

• 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

• SQL Server 2005 + JavaEE application on one computer in production

  - by Max

  We have project with a server witch have about 3000 requests at day from client. 30-40 on-line users. And smth about 30-40Gb data increase per year. And system should be on-line 24x7. Where can we locate the SQL server better? On one computer with JavaEE container or on standalone computer? What pros and cons on this ways?

  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

• 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

• 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

< Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >