SQL Server 2005 Computed Column Is Persisted
- by hilary
I have some computed columns in a table and need to know if I should set Is Persisted to true. What are the advantages? Are there any disadvantages? What does 'Is Persisted' mean?
Search Results
Search found 16978 results on 680 pages for '80 column'.
Page 70/680 | < Previous Page | 66 67 68 69 70 71 72 73 74 75 76 77 | Next Page >
-
-
SQL for sorting boolean column as true, null, false
- by petehern
My table has three boolean fields: f1, f2, f3. If I do SELECT * FROM table ORDER BY f1, f2, f3 the records will be sorted by these fields in the order false, true, null. I wish to order them with null in between true and false: the correct order should be true, null, false. I am using PostgreSQL.Read the article
-
EntityFramework: Access dabase-column using user defined Type
- by Nils
I "inherited" an old Database where dates are stored as Int32 values (times too, but dates shall suffice for this example) i.e. 20090101 for Jan. 1st 2009. I can not change the schema of this database because it is still accessed by the old programs. However I want to write a new program using EF as the O/R-M. Now I'd love to have DateTime-Values…Read the article
-
how to fetch & store any column from coredata to array
- by user440485
Hi All, I am working on page(Lesson) has button called "AddToFavorite". when i click on this button lessonID,lessonHeading is added in the Coredata. - (NSFetchedResultsController *)fetchedResultsController { // Set up the fetched results controller if needed. if (fetchedResultsController != nil) { return…Read the article
-
AWK -- How to do selective multiple column sorting?
- by nawesita
In awk, how can I do this: Input: 1 a f 1 12 v 2 b g 2 10 w 3 c h 3 19 x 4 d i 4 15 y 5 e j 5 11 z Desired output, by sorting numerical value at $5: 1 a f 2 10 w 2 b g 5 11 z 3 c h 1 12 v 4 d i 4 15 y 5 e j 3 19 x Note that the sorting should…Read the article
-
sql jdbc getgeneratedkeys with mysql returns column "id" not found
- by iamrohitbanga
I want to retrieve the most recently updated value in the table using an insert query. these are the datatypes in my sql table. int(11) // primary key auto increment, not being assigned by sqlQuery varchar(30) timestamp // has a default value. but i am explicit assigning it using CURRENT_TIMESTAMP varchar(300) …Read the article
-
How do I update a column in 3rd row the same as a column in 2nd row in MySQL?
- by user198729
I'm doing it this way,but get an error: mysql> update products set products_image=(select products_image from products where products_id=2) where products_id=3; ERROR 1093 (HY000): You can't specify target table 'products' for update in FROM clauseRead the article
-
Update a column based on a field from another table
- by Sergio
Hi: I'd like to update values in one table based on corresponding values from other tables. Say you want to update prices of pieces provided by one specific manufacturer whose name is in the table Manufacturers with the Pieces table containing only the id of the manufacturer. I've seen several solutions for MySQL…Read the article
-
T-SQL Query, combine columns from multiple rows into single column
- by Shayne
I have seeen some examples of what I am trying to do using COALESCE and FOR XML (seems like the better solution). I just can't quite get the syntax right. Here is what I have (I will shorten the fields to only the key ones): Table Fields ------ -------------------------------…Read the article
-
Rearrange a python list into n lists, by column
- by Ben R
Trying to solve this at this hour has gotten my mind into a tail-spin: I want to rearrange a list l into a list of n lists, where n is the number of columns. e.g., l = [1,2,3,4,5,6,7,8] n = 5 ==> [[1,6][2,7][3,8][4][5]] another example: l = [1,2,3,4,5,6,7,8,9,10] n = 4 ==>…Read the article
-
Get row where datetime column = today - SQL server noob
- by Chin
In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanksRead the article
-
SQLite SQLite column can't be updated to any value but zero (real type)
- by user1065320
Hi I'm trying to create a three fields table (date,text,real), I can insert and update the first two fields but can't set or update the last one. createSQL = @"CREATE TABLE IF NOT EXISTS ACTIVITIES (MYDATE DATETIME PRIMARY KEY, ACTIVITY TEXT , LENGTH REAL);"; try to insert char…Read the article
-
row number over text column sort
- by Marty Trenouth
I'm having problems with dynamic sorting using ROW Number in SQL Server. I have it working but it's throwing errors on non numeric fields. What do I need to change to get sorts with Alpha Working??? ID Description 5 Test 6 Desert 3 A evil Ive got a Sql Prodcedure…Read the article
-
Creating an Order Column for encrypted data
- by SetiSeeker
I am saving encrypted data to a database. Is there a way I can create a "hashcode" or fingerprint or checksum of the plain text data, that if I sort / order by on the "hashcode" the order would be the same as if I had saved the plain text data and perform the same sort / order by…Read the article
-
Get row where date column = today - SQL server noob
- by Chin
In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanksRead the article
-
Why MySQL multiple-column index is overpopulated?
- by actual
Consider following MySQL table: CREATE TABLE `log` ( `what` enum('add', 'edit', 'remove') CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `with` int(10) unsigned NOT NULL, KEY `with_what` (`with`,`what`) ) ENGINE=InnoDB; INSERT INTO `log` (`what`, `with`) VALUES …Read the article
-
MySQL: SELECT highest column value when WHERE finds similar entries
- by Ike
My question is comparable to this one, but not quite the same. I have a database with a huge amount of books, with different editions of some of the same book titles. I'm looking for an SQL statement giving me the highest edition number of each of the titles I'm selecting with a…Read the article
-
Unit Testing a CSV Parser and Column Mapping Tool
- by PieterG
I am really starting to enjoy unit testing and have the following question to the gurus of unit testing. Let's for example say I have the following class public class FileMapper { public Dictionary<string, string> ReadFile(string filename, string delimeter){} } How…Read the article
-
c# finding matching words in table column using Linq2Sql
- by David Liddle
I am trying to use Linq2Sql to return all rows that contain values from a list of strings. The linq2sql class object has a string property that contains words separated by spaces. public class MyObject { public string MyProperty { get; set; } } Example MyProperty values…Read the article
-
Hibernate, select by id or unique column
- by Nican
I am using hibernate for Java, and I want to be able to select users by id or by name from the database. Nice thing about Hibernate is that it caches the result by id, but I seem to be unable to make it cache by name. static Session openSession = Factory.openSession(); …Read the article
-
column data in tooltip overflows.
- by xrx215
I want to show the data in the tooltip when a columns has long sentences because of width constrints. for this i am using a renderer function as follows { header: xppo.st('SDE_INCIDENT_DESCRIPTION1'), width: 175, sortable: true, groupable: false, dataIndex:…Read the article
-
MySQL: Ignore a selected column when using DISTINCT
- by John Leonard
Let's say: I want to query colA, colB and colC in my table. I want to see DISTINCT values but I don't want colA to be a criteria for distinction. Omitting colA isn't an option. What's the best way to structure that query?Read the article
-
Multiple column subselect in mysql 5 (5.1.42)
- by rubber boots
This one seems to be a simple problem, but I can't make it work in a single select or nested select. Retrieve the authors and (if any) advisers of a paper (article) into one row. I order to explain the problem, here are the two data tables (pseudo) papers…Read the article
-
Selecting rows from DataTable by DateTime column (hours)
- by nCdy
DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy HH") + "'"); doesn't work, but DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy") + "'"); works. So how can I select the…Read the article
-
join 3 files by first Column with awk ?
- by noinflection
i have three similar files, they are all like this: File A ID1 Value1a ID2 Value2a . . . IDN Value2n and i want an output like this Output ID1 Value1a Value1b Value1c ID2 Value2a Value2b Value2c ..... IDN ValueNa ValueNb ValueNc Looking to…Read the article
