Search Results

Search found 11576 results on 464 pages for 'column alias'.

Page 94/464 | < Previous Page | 90 91 92 93 94 95 96 97 98 99 100 101  | Next Page >

• What's difference between primitive and wrapper class in JPA (Hibernate) column mappings?

  - by Michael Lu

  For instance, there’s a integer column in a database table. Then in java model, it can be mapped both as primitive int and Integer. My question is what's difference between the int and Integer in this case? And performance concern? Thanks!

  Read the article

• how to find index of a row in sql server?

  - by NoviceToDotNet

  How can i fetch column names from a tale on index basis, like i want to make a tables whose column name should be the name of last column fields of a result set of a query, but those result sets last columns value may be different at different execution time, so i want to know how can i fetch those index value of that last column to make a temp table with column name of those last columns value of a result set. Is there any way/function in sql server to dynamically form that?

  Read the article

• How to Get a Specific Column Value from a DataTable? - C#.NET Winforms

  - 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. Thanks

  Read the article

• [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 to concatenate all the records in a column returned by a query into one varchar string in T-SQL?

  - by Ivan

  A query (SELECT/FUNCTION/VIEW/PROCEDURE) returns a column of varchar records. I need to concatenate them all into one single varchar line. How do I best do it in T-SQL?

  Read the article

• How can I determine the maximum row size just from the column datatype sizes?

  - by thecoop

  How can I work out the maximum row size in a table, if I'm only given the datatype lengths (from all_tab_cols.data_length column) of the columns in the table (ie no statistics or ANALYZE)? There's extra complications in that this is an IOT, so there's index tree size to consider as well.

  Read the article

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

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

• 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

< Previous Page | 90 91 92 93 94 95 96 97 98 99 100 101  | Next Page >