Search Results

Search found 10318 results on 413 pages for 'computed column'.

Page 80/413 | < Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >

• [SQL-SERVER 2008]how to convert a column value to uppercase before inserting?

  - by krishna

  For example if there is a column named 'code' in which the data should only be in uppercase, how to ensure that in before insert trigger ?

  Read the article

• How do I select a column with the latest "datetime" data type?

  - by Greg McNulty

  How do I select a column with the latest "datetime" data type, in Visual Web Developer 2008, ASP.NET 3.5 ? In the config data source WHERE option my options are greater than cookie, control, etc... but I would like to select where the datetime is the latest in the table. (Select row from table where datetime is last updated....) Thank You.

  Read the article

• Specifying column names from a list in the data.frame command.

  - by MW Frost

  I have a list called cols with column names in it: cols <- c('Column1','Column2','Column3') I'd like to reproduce this command, but with a call to the list: data.frame(Column1=rnorm(10)) Here's what happens when I try it: > data.frame(cols[1]=rnorm(10)) Error: unexpected '=' in "data.frame(I(cols[1])=" The same thing happens if I wrap cols[1] in I() or eval(). How can I feed that item from the vector into the data.frame() command?

  Read the article

• I need to get the values of Sharepoint Field Choice Column in Sharepoint 2007 without accessing a li

  - by netadictos

  Hi, I want to do this but without accesing the list "items", that is to say, to access the column perhaps with the root site or a contenttype, not depending on a list that can be created or not inside the Sharepoint app. SPFieldChoice choice = (SPFieldChoice)items.Fields[namefield]; foreach (string choiceName in choice.Choices) { //etc... }

  Read the article

• WCF 3.0 Service Contract method will return 992 rows but not 993 rows. 50 column observable collecti

  - by Ferrell Carr

  Exact duplicate of: http://stackoverflow.com/questions/2845454/wcf-3-0-service-contract-method-will-return-992-rows-but-not-993-rows-50-column My VS.Net 2005 CF 3.0 WCF will has a limit on how much data it will return

  Read the article

• How to fill combobox column in datagrid view in vb.net?

  - by meenakshi

  My datagrid view contains three columns, column types are checkbox, textbox and combobox. If I check one row, it will load corresponding rows combobox only. How can I do it?

  Read the article

• How to Get a Specific Column Value from a DataTable?

  - by peace

  I have a datatable. I need to fetch a certain column value based on the user input. For example, lets say the datatable has two columns CountryID and CountryName. I need to find CountryID in the datatable based on the user input country name. I could just open a connection with DB and run the query select countryID from Country where countryName = @userinput. Is there anyway i could do this on the datatable.

  Read the article

• Parameterizing a SQL IN clause on an integer column?

  - by SkippyFire

  Jeff Atwood asked the original question about parameterizing a SQL IN clause, but I want to do this with an integer column. If I try the code from the original post I get the following exception, which makes sense: Conversion failed when converting the varchar value '%|' to data type int. Anyone try this before?

  Read the article

• Is there was way to get the leftmost column in a Google visualization table to stay fixed while side

  - by Ben

  I'd looking to emulate the standard google visualization table header row behavior, but have it apply to the first column. This doesn't seem to be a built-in feature, but I'm wondering if it can be accomplished with some custom CSS?

  Read the article

• FIND TIME DIFFERENCE

  - by RUBAN

  HI, I HAVE THREE COLUMNS. COLUMN A COLUMN B COLUMNC 2.43 2.45 00:02:00 WHAT I WANT IS COLUMN A HAVE START TIME, AND COLUMN B HAVE END TIME.I NEED THE TIME DIFFERENCE OF START AND END TIME IN COLUMN C FORMAT LIKE(HH:MM:SS) SOMEBODY CAN HELP ME PLEASE!!!!!!!!!!!!!

  Read the article

• SQL function to get count of how many times string appears in column?

  - by Kristopher Ives

  Is there a function for MySQL that will count the number of times a string occurs in another string or column? Basically I want: SELECT SUB_COUNT('my word', `my_column`) AS `match_count` FROM `table` Thanks!

  Read the article

• Which column type should I use for storing HTML of an unknown size?

  - by citronas

  What column type should I use for storing html content from a website with an unknown size? (I'm scanning certain html pages, and create an database entry if there are changes between the last stored entry and the current html code.)

  Read the article

• How to map a Entity Data Model conceptual model property to a storage model column using the "Serial

  - by codekaizen

  I have a conceptual model in EDM where one of the entities has a property which is essentially a big value object whose properties aren't really useful as columns in the datamodel. I'd like to apply the Serialized LOB pattern to it so that I can fit it into a 192 byte binary column. How do I map this in the EDM v4? Is it even possible at this time? Actually, is it possible in any ORM?

  Read the article

• Exporting each Excel column to individual text or csv files?

  - by powerofgrayskull

  I have an Excel worksheet with around 100 cols. Does anyone know of an easy way to write the contents of each column to a csv or txt file?

  Read the article

• DataGrid view inserting new row when filling column headers.

  - by fireBand

  DataGridView inserting an extra row every time I populate with data. The row appears even if I Only fill the column headers. This is causing problems when I try to get values of each cell. Is there a way to avoid this perhaps in properties? Thanks in advance for any suggestions.

  Read the article

• Can I create a datetime column with default value in sqlite3?

  - by NobodyMan

  Is there a way to create a table in sqlite3 that has a datetime column that defaults to 'now'? The following statement returns a syntax error: create table tbl1(id int primary key, dt datetime default datetime('now'));

  Read the article

• How to apply formula to cell based on IF condition in Excel

  - by Captain Comic

  Hi I have an Excel spreadsheed like the one shown below A B 10.02.2007 10 10.03.2007 12 Column A is date and B is price of share Now in another sreadsheet I need to create a new column called return In this column i need to place formula like = ln(B2/B1) but on condition that this formula is only applied date in column A is in range StartDate < currentDate < EndDate. So I want to apply my formula only to specific period say only to 2007 year have new column placed in another spreadsheet starting from given location say A1 Please suggest

  Read the article

• How to insert the column with data in between datatable ?

  - by Harikrishna

  I have datatable like : id name address --------------- 1 abc akjdk 2 bcd dkjkl Now I want to insert one column with data in between to that datatable like : id name phoneno address ----------------------- 1 abc 11231 akjdk 2 bcd 12313 dkjkl How can I do this ?

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• Show yes/no in bool column of gridview bound to datasource in Winforms?

  - by Carrie Nelson

  I have a gridview that is bound to a datasource (Windows Forms, VB.NET). One of columns is a property of type boolean, and I want to show "yes/no" in the column instead of 0/1 or "true/false". Is this possible? Can you edit displays of columns that are bound?

  Read the article

• Update column using rows of a table, without using cursor or any other iteration.

  - by Muhammad Kashif Nadeem

  Update Combined column using CategoryCode of every OrderId. In this example there are two OrderIds 990 and 986. Need to concatenate categories of these two individually. The desired result is like this. 990 Bus, Pub, Shoot, Club, Bus, Hos Thanks.

  Read the article

• is able to accommodate multiple data type in one column?

  - by Jothi

  hi, i have one problem that, i have to change type of data in column based on foreign key stored in that row. unit_id unit_name 1 String 2 Float 3 Date 4 Int Id spec value unit id 1 "A" 1 2 30.90 2 3 null 3 4 100 4 now i should achieve the above codition. how do i achieve it? please help me.

  Read the article

• Use Awk to Print every character as its own column?

  - by wizkid84

  Hi there, I am in need of reorganizing a large CSV file. The first column, which is currently a 6 digit number needs to be split up, using comma's as the field separator. For example, I need this: 022250,10:50 AM,274,22,50 022255,11:55 AM,275,22,55 turned into this: 0,2,2,2,5,0,10:50 AM,274,22,50 0,2,2,2,5,5,11:55 AM,275,22,55 Let me know what you think! Thanks!

  Read the article

• How do you set a default value for a MySQL Datetime column?

  - by Brian Boatright

  How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(), what is the equivalant for MySQL? I'm using 5.x if that is a factor.

  Read the article

• In Django, how do I set a unique on a columN?

  - by alex

  class Radio(models.Model): title = models.CharField(max_length=2000, blank=True, null=True) listeners = models.IntegerField(default = 0, blank=True, null=True) I don't want duplicate TITLE column. How do I set a unique key?

  Read the article

< Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >