Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 309/1156 | < Previous Page | 305 306 307 308 309 310 311 312 313 314 315 316  | Next Page >

• How to configure reference to be deleted on parent table update?

  - by abatishchev

  I have two tables: info: ID, fee_id and fee: ID, amount and a reference between them (SQL Server 2008): ALTER TABLE info WITH CHECK ADD CONSTRAINT FK_info_fee FOREIGN KEY(fee_id) REFERENCES fee (ID) ALTER TABLE info CHECK CONSTRAINT FK_info_fee GO How to configure this reference that way so a record in fee will be deleted if info.fee_id becomes NULL

  Read the article

• is there any different in Connection string between SQL server Authentication and Windows Authentic

  - by Gold

  hi is there any different in Connection string between SQL server Authentication and Windows Authentication if yes, can i get a sample connection string for this ? thank's in advance

  Read the article

• node to traverse cannot be null (Hibernate SQL)

  - by tiswas

  I'm performing a SQL query through hibernate, which looks like: SELECT thi FROM track_history_items thi JOIN artists art ON thi.artist_id = art.id WHERE thi.type = "TrackBroadcast" GROUP BY art.name ORDER thi.createdAt DESC but I'm getting the message that 'Node to traverse cannot be null!'. Anyone know what could be causing this? --EDIT-- I'm pretty sure that this problem is being caused by the possibility of artist_id to be null. However, I can't prevent this, so can I just skip the rows track_history_item rows which have a null artist_id?

  Read the article

• How to write SQL query as named_scope?

  - by keruilin

  How can I translate the following SQL query into a named_scope? select users.*, sum(total_quantity * total_price) as points_spent from orders join users on users.id = orders.user_id where pay_type = 'points' group by user_id order by points_spent desc Thanks!

  Read the article

• Which is more flexible in regards to database changes, EF 4 or Linq to SQL

  - by JBeckton

  Reading about both Linq to SQL and Entity Framework I have developed the impression that EF is more suitable for apps that get data from multiple data sources. But as I am reading about MVC2 models I see an example where EF is more loosely coupled with your data model. If I have to add or remove some columns from a table then what is involved in updating my model or DAL with each of these implementations?

  Read the article

• MS SQL to PostgreSql

  - by Dezigo

  I need to create a trigger in MS SQL. Trigger works: If I found new line where T = 'A'; than.. add this line to PostgreSQL table. Is it possible to create it,without software? (I know how to create trigger,but how to create connection between two servers..?

  Read the article

• compiling a linq to sql query

  - by frenchie

  Hi, I have queries that are built like this: public static List<MyObjectModel> GetData (int MyParam) { using (DataModel MyModelDC = new DataModel()) { var MyQuery = from.... select MyObjectModel { ...} } return new List<MyObjectModel> (MyQuery) } } It seems that using compiled linq-to-sql queries are about as fast as stored procedures and so the goal is to convert these queries into compiled queries. What's the syntax for this? Thanks.

  Read the article

• SQL qn:- comparing data in rows

  - by rayhan

  hi, i would like to compare numeric data in rows. for eg, i have a table that has a column as such:- Number ====== 1.88 9.99 8.76 9.88 I want to compare 2nd value, 3rd value, 4th value to the 1st value. And then 3rd, 4th value to the 2nd. then 4th to 3rd. How can i construct an sql to do this?

  Read the article

• Store an image in a SQL Server CE database

  - by Vaccano

  Does any one know of an example on how to store an image in a SQL Server CE database? What data type should the column be? (I am guessing binary.) I use Linq-To-Datasets. Is it possible using that to put the image into the database and pull it out again later? Thanks for any advice.

  Read the article

• updolad a file to sql database with delphi and after download

  - by Rapunzo

  I am working to make a basic file database, but I couldnt find the true codes. Can anyone help me to save an exe file to sql database after read, download and use when I need it? With Delphi

  Read the article

• SQL Server Query Command

  - by Scott Jackson

  Hi, I have an SQL database table, I want to find everything in a table where the 'Room' says 'DISPOSED', Insert 'DISPOSED' into the 'Status' field and then delete the entry in 'Room'. Basically moving the entry from one field to another (if the 'Room' field has 'DISPOSED' in it) Hope this makes sense. Thanks for any help.

  Read the article

• .Net best approach SQL Server 2008 incremental update based on up to date version

  - by MicMit

  Assuming daily certain up to date database is produced via loading from various sources. Changes need to be applied to historical database based on uid, new records will added , non existing will be softly deleted , some will be updated. Is Ado.Net and Sql statements the most appropriate technology for the task like this ?

  Read the article

• change string in mssql to abbreviate

  - by jeff

  How do I return the everything in a string from a sql query before a certain character? My data looks like this: HD TV HM45VM - HDTV widescreen television set with 45" lcd I want to limit or truncate the string to include everything before the dash. So the final result would be "HD TV HM45VM"

  Read the article

• Setting a variable for a Z SQL method

  - by Nathan Friend

  In Plone I have a Z SQL methood: SELECT [aapp_qtitle] ,[aapp_mtitle] ,[aapp_sdate] ,[aapp_duration] FROM [AAPP].[dbo].[M_PageBodyElement] where [aapp_id]=<dtml-sqlvar aapp_id type=int> How can I set the value of aapp_id in my Plone page code?

  Read the article

• SQL clone record with a unique index

  - by Milhous

  Is there a clean way of cloning a record in SQL that has an index(auto increment). I want to clone all the fields except the index. I currently have to enumerate every field, and use that in an insert select, and I would rather not explicitly list all of the fields, as they may change over time.

  Read the article

• displaying sql exception in JSF

  - by user234194

  I was wondering how would I be able to show SQL errors generated during update, delete, select * etc in JSF. Any help would be appreciated.

  Read the article

• What is best tool to compare two MSSQL databases (schema and data)?

  - by tomaszs

  I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?

  Read the article

• Best naming for a column in a SQL Server table

  - by Lance Fisher

  Which of the following three options would you choose for a column name in a SQL Server table, and why? YearToDateWages YTDWages YtdWages Follow up: SSN Ssn SocialSecurityNumber

  Read the article

• xml serialization and for xml sql server

  - by Hadad

  Hello, I've a SQL statement that returns a xml result, for a serialized object.I want to add a attribute to an element, that reflects the type of the object "xsi:type=table" but i don't know how?

  Read the article

• Updating value in Linq to SQL IEnumerable

  - by Learner

  Using Linq to SQL: if(!parentlist.childlist.Contains(row1)) parentlist.childlist.Add(row1); else How do I update the required childlist row with row1? Each row of the child list has a unique id. parentlist implements IEnumerable and childlist is IList.

  Read the article

• How to perform a select using a WHERE NOT EXISTS

  - by Peter Bridger

  I'm using LINQ2SQL and I want to compare two tables and select all rows that are missing from one tables (based upon one of the column values). In standard SQL I would write this as: SELECT FirstName, LastName, RefId, Email FROM Users_ActiveDirectory AS ADU WHERE NOT EXISTS ( SELECT U.RefId FROM Users AS U WHERE U.RefID = ADU.RefId ) However I'm not sure how to achieve the same result using LINQ2SQL?

  Read the article

• sql server 2000: current_timestamp as function actual param

  - by zulyo

  how can i use the "current_timestamp" as actual param of a function, perhaps in a view that contains the function? the db is a sql serve 2000

  Read the article

• What causes MSSQL to return the message 'The statement has been terminated'?

  - by Wally Lawless

  I have a very simple INSERT statement being executed from a PHP script running on a Linux Apache web server. I can run the query fine from within SQL Management Studio and it normally runs fine from PHP as well. However, every once in awhile I get an error message from my PHP script that the query failed and the mssql_get_last_message() function returns 'The statement has been terminated'. What sources can cause this message to be returned from MSSQL?

  Read the article

• Recommended SQL Practice and Books

  - by John Hpa

  Hi, Please recommend me some books and practices for me. I am quite weak in SQL though not that bad in C# and VB.NET. Thanks.

  Read the article

• Swap values for two rows in the same table in SQL Server

  - by AmRoSH

  I have table and I want to swap the values from two rows. I have the rows IDs of the two rows. Is there any query to do that? Here is an example. Before the query I have this: row1 : 1,2,3 row2 : 5,6,7 After the swap I want this: row1 : 5,6,7 row2 : 1,2,3 I don't want write it in .NET code because I think an SQL query is easier than that.

  Read the article

< Previous Page | 305 306 307 308 309 310 311 312 313 314 315 316  | Next Page >