Search Results

Search found 10424 results on 417 pages for 'persisted column'.

Page 259/417 | < Previous Page | 255 256 257 258 259 260 261 262 263 264 265 266  | Next Page >

• How do I search for the comma character within data stored in SQL Server?

  - by Fred

  I have some data that I needs to be searched for the comma character. example entry I need to locate in the field Citation in the Citations table: This is sometimes true, Textual Reference In the end, I'm looking to extract Textual Reference Selecting the column with the data: select Citation from Citations;

  Read the article

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• Sql server like for Integer

  - by Prashant

  I have a column which is integer and I want to search all numbers starting with 1500. I know I could use something like left(accountid,4)= 1500. But is that an optimum solution or is there a better approach? I am using Sql Server 2005.

  Read the article

• Can I set ignore_dup_key on for a primary key?

  - by Mr. Flibble

  I have a two-column primary key on a table. I have attempted to alter it to set the ignore_dup_key to on with this command: ALTER INDEX PK_mypk on MyTable SET (IGNORE_DUP_KEY = ON); But I get this error: Cannot use index option ignore_dup_key to alter index 'PK_mypk' as it enforces a primary or unique constraint. How else should I set IGNORE_DUP_KEY to on?

  Read the article

• Help with simple query - why isn't an index being used?

  - by Randy Minder

  I have the following query: SELECT MAX([LastModifiedTime]) FROM Workflow There are approximately 400M rows in the Workflow table. There is an index on the LastModifiedTime column as follows: CREATE NONCLUSTERED INDEX [IX_Workflow_LastModifiedTime] ON [dbo].[Workflow] ( [LastModifiedTime] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) The above query takes 1.5 minutes to execute. Why wouldn't SQL Server use the above index and simply retrieve the last row in the index to get the maximum value? Thanks.

  Read the article

• Passing parameter from one user control to another user control in an aspx page.

  - by AJ

  Hi I have two user controls on one aspx page. UC1 has a grid which contains a link button column which user clicks. Based on the value of clicked cell, I need to show some data into UC2. How do I pass data from UC1 to UC2? How do I invoke a function of UC2 from UC1? Please advise. Thanks AJ

  Read the article

• What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

  - by trenton

  I tried this in mysql: mysql> alter table region drop column country_id; And got this: ERROR 1025 (HY000): Error on rename of './product/#sql-14ae_81' to './product/region' (errno: 150) Any ideas? Foreign key stuff?

  Read the article

• Table is realigned after setting the display property to 'block'

  - by Holicreature

  I'm having a table and i have a row which is initially set to the display property of 'none' and i changing it to 'block' at some selection of value from my select box , at that point of time the row is not aligned properly. My two columns are set inside a single column of the above row? but when i change it again to 'none' all the other rows are aligned correctly..

  Read the article

• How to deal with the test data in Junit?

  - by user351637

  In TDD(Test Driven Development) development process, how to deal with the test data? Assumption that a scenario, parse a log file to get the needed column. For a strong test, How do I prepare the test data? And is it properly for me locate such files to the test class files?

  Read the article

• mysql update enums

  - by FFish

  I have a field with enums: 'preview','active','closed' When I query like this: $query = "UPDATE albums SET album_active = preview WHERE album_id = 3"; $result = mysql_query($query); if (!$result) die('Invalid query: ' . mysql_error()); I get : Invalid query: Unknown column 'preview' in 'field list

  Read the article

• WPF DataGridComboBoxColumn`s ComboBox is only visible when DataGrid has IsReadOnly=FALSE

  - by msfanboy

  Hello, Why is the ComboBox in that column only visible via double-click in the empty cell when the DataGrid is set to IsReadOnly = FALSE ??? <DataGridComboBoxColumn Width="*" IsReadOnly="False" Header="test" />

  Read the article

• gridview, order number + 1/- 1

  - by MyHeadHurts

  So I am working on a gridview that uses the order number to order the table. However, my users are able to ad a row. What i want is something similar to pages that have the arrows next to each row and the user can click up if they want that row to go up. I also want it to change the actual number in the row column. for the one being moved and for the other one being affected. I hope i am being clear enough

  Read the article

• XIR3 API Rebean Webi Object SQL return

  - by tathamr

  All, Has anyone figured out how to return the sql for an object that is in Webi using the rebean api? I have got the ReportExpression of the column but, from there I am having a difficult time retrieving the SQL of the object. Thanks

  Read the article

• How to represent "ALL" in Primary Key -foreign Key relationship.

  - by Rohit

  I have to create a db design to store blacklisted fax numbers. I have created a table and one column of this table is customerID which is a foreign key to table Customer. Now i want to have a faxnumber which is blacklisted for all customers. How should i proceed with this. Should i use Null in this case. Please provide options

  Read the article

• Usability of an endless/infinite scroll

  - by Anton Gogolev

  What are pros and cons of this technique (see Softfolio for an example). Two things I personally thought of are as follows: Impossible to tell someone where an item of interest is located (like, you probably won't say "324-th row, second column") Broken navigation when you return back to an infinitely scrolled page. What else can you think of? And what do you personally think of this approach in general. Would you use this in you projects?

  Read the article

• Money vs. Decimal vs. Float Performance issues (SQL data types for Currency value)?

  - by urz shah

  What data type should be selected in case of Currency value column in SQL server. I have read some where on web Working on customer implementations, we found some interesting performance numbers concerning the money data type. For example, when Analysis Services was set to the currency data type (from double) to match the SQL Server money data type, there was a 13% improvement in processing speed (rows/sec). Is it true??

  Read the article

• How to run a service at a specific time using JSP/Servlets app?

  - by BugKiller

  Hi, I'm developing JSP/Servlets App,and I want to execute a service at a specific time , for example : For each day at 10:00 AM , delete any attachment from the "attachment" table in the database where column X== NULL. How can I do this in JSP/Servlets application ? I use Glassfish as a server .

  Read the article

• Add common prefix to all cells in Excel

  - by LIX

  I have a column with some text in each cell. I want to add some text, for example "X", at the start of all cells. For example: A B ----- >>>> ---- 1 X1 2 X2 3 X3 What is the easiest way to do this?

  Read the article

• How to match 2 columns in excel?

  - by abhijithln

  Hi, I have an excel sheet, sheet1 which has 2 cols, A and B. Col A has some values and has corresponding mapping in col B(not all values in A have a mapping in B, some are empty). The sorting is done from Z-A and w.r.to Col A. I have another excel sheet, sheet2 which has similar Col A and Col B. Now, i want to find out whether any match is there between Col A of sheet1 and Col A of sheet2. If matches are found, those values should be copied onto a new column.

  Read the article

• replace function in dml statements in oracle 8i

  - by maheshasoni

  Can we use Replace function in a update statement ? If yes then How? I have a column 'enrollno' having values like '800-00001' to '800-01800'. I want to replace inital '800-' to '800' in all 1800 records. (Output should be '8000001' to '80001800') Is it possible through replace function or any other option is there in ORACLE8i ? MaheshA...

  Read the article

• How do I update my primary key in MySQL?

  - by Wesley

  Ok, this is probably really simple, but I just can't figure it out. I have a primary key in a table that goes from 1-5,000. I need to manually update that id (for other table update purposes) so that it says 5,000-10,000. Can't I manually update this column? Please help!!! Thank you

  Read the article

• query multiple tables and combine results into one return table for stored procedure?

  - by Shawn

  I have several different tables, but they all have 2 columns that are the same name. I want to write a stored procedure that searches one column in all of the tables and returns the result. Ideas? I'm fairly nub when it comes to SQL.

  Read the article

• How to sort Current Page Rows of Gridview only in asp.net?

  - by Vamshi

  Hi! I have a requirement that, I have a GridView with paging, which has 5 pages. If i click on any column then rows present in current Pages have to Sort. If i navigate to other row i need to display as it is. This should developed in ASP.NET using C# Please help me. Thank You..............

  Read the article

• How best to organize projects folders for unit tests in .NET?

  - by Dan Bailiff

  So I'm trying to introduce unit testing to my group. I've successfully upgraded a VS'05 web site project to a VS'08 web application, and now have a solution with the web app project and a unit test project. The issue now is how to fit this back into the source repository such that we don't break the build system and the unit test projects are persisted as well. Right now we have something like this: c:\root c:\root\projectA c:\root\projectB c:\root\projectC where projectA contains the sln file and all other related files/folders for the project. Now I have this new solution that looks like this: c:\root\projectA (parent folder) c:\root\projectA\projectA (the production code project) c:\root\projectA\projectA_Test (the unit test project) c:\root\projectA\TestResults c:\root\projecta\projectA.sln How do I integrate this new structure back into the code repository? I'd really prefer to keep the production code folder where it was in the source repository for the sake of the build, but is this necessary? If I keep the production code project in its usual place then where do I keep my unit test projects and how do I connect them with a sln file? Is it better to use this new structure and adjust the build process? I'd love to hear how other people are dealing with this issue of upgrading legacy projects to unit testing.

  Read the article

• how to generate an N level tree using datatable?

  - by Kishore Kumar

  I have a DataTable with column ID, Name, RootID. The tree stucture is implmented using the RootId field. If the RootId is null it is considered as Root Node. How to create an Nlevel tree using the DataTale. eg. 1 Manager null, 2 Project Lead 1, 3 Test Lead 1, 4 Sr Soft Eng 2, 5 Soft eng 2, 6 HR Manager Null, 7 HR exec 6, ......

  Read the article

< Previous Page | 255 256 257 258 259 260 261 262 263 264 265 266  | Next Page >