Search Results

Search found 443 results on 18 pages for 'concat'.

Page 1/18 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

  - by pinaldave

  Concatenating  string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL Server 2012 has introduced new function CONCAT…

  Read the article

• MySQL – Introduction to CONCAT and CONCAT_WS functions

  - by Pinal Dave

  MySQL supports two types of concatenation functions. They are CONCAT and CONCAT_WS CONCAT function just concats all the argument values as such SELECT CONCAT('Television','Mobile','Furniture'); The above code returns the following TelevisionMobileFurniture If you want to concatenate them with a comma, either you need to specify the comma at the…

  Read the article

• Javascript - Concat for IE or older browsers

  - by Emtucifor

  What's an elegant way to simulate the Array.concat() functionality in IE or older browsers?

  Read the article

• Use concat and maintain length of variable

  - by user1682055

  I'm trying to use concat on some variables. These variables have been declared as chars: declare v_order_date char(10); declare v_quantity char(11); declare v_plant char(100); I have a cursor where I am setting these as some outputs. To call the results, I am setting v_msg as set v_msg := concat( v_msg, '\n', v_order_date, v_quantity,…

  Read the article

• mysql concat all field table

  - by hafizan

  Is there a way we can concat all field in the table(1 sql statement)(automatic) ? The reason was before user updated or delete a record,the record will push to another table for future reference.

  Read the article

• why concat() is not working here? , java

  - by soma sekhar

  Consider the code below, String s = "TEST"; String s2 = s.trim(); s.concat("ING"); System.out.println("S = "+s); System.out.println("S2 = "+s2); Output obtained : S = TEST S2 = TEST BUILD SUCCESSFUL (total time: 0 seconds) Why "ING" is not concatenated?

  Read the article

• MySQL concat question

  - by Lucy Williard

  Hi guys! I am somewhat mystified by concat and joins in MySQL 4. Here's where I am having an issue. I have two tables... person id, fname, lname, city, state, zip capital state, city I am needing to generate all states and the number of persons (from the person table) from each. Something like .... AK | 5 AL | 7 etc etc Any advice…

  Read the article

• PHP/mySQL - using result from 'CONCAT' and 'AS' in 'LIKE' clause

  - by Phil Jackson

  Hi I have the following code; if( ! empty( $post['search-bar'] ) ) { $search_data = preg_replace("#\s\s#is", '', preg_replace("#[^\w\d\s+]#is", '', $post['search-bar'] ) ); $data_array = explode( " ", $search_data ); $data_array = "'%" . implode( "%' OR '%", $data_array ) . "%'"; $query = "SELECT CONCAT(…

  Read the article

• Concat LPSTR in C++

  - by Cat Man Do

  Trying to use as basic C++ as I can to build a list of numbers from 1-52 in a random order (deck of cards). Unfortauntely, all my attempts to concat the strings and get a result end in failure. Any suggestions? NOTE: This is not homework it's something I'm using to create a game. // Locals char result[200] = ""; …

  Read the article

• mysql - query group/concat question??

  - by tom smith

  I have a situation where I return results with mutiple rows. I'm looking for aw way to return a single row, with the multiple items in separate cols within the row. My initial query: SELECT a.name, a.city, a.address, a.abbrv, b.urltype, b.url FROM jos__universityTBL as a LEFT JOIN jos__university_urlTBL as b…

  Read the article

• Concat E4X expressions in ActionScript 3

  - by loto

  Is there any way to concatenate E4X expressions? If I store "half" a path in a variable, can I concatenate the way I do with Strings?

  Read the article

• SQL SERVER – Concat Function in SQL Server – SQL Concatenation

  - by pinaldave

  Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though, SQL Server is now in moving…

  Read the article

• What causes exception in string.concat

  - by Budda

  Here are few classes: public class MyItem : ParamOut { public string Code { get { return _quoteCode; } } public InnerItem[] Skus { get { return _skus; } } public PriceSummary Price { get { return _price; } } public override string ToString() { …

  Read the article

• Tool to detect use/abuse of String.Concat (where StringBuilder should be used)

  - by Mark Rushakoff

  It's common knowledge that you shouldn't use a StringBuilder in place of a small number of concatenations: string s = "Hello"; if (greetingWorld) { s += " World"; } s += "!"; However, in loops of a significant size, StringBuilder is the obvious choice: string s = ""; foreach (var i in Enumerable.Range(1,5000))…

  Read the article

• SQL Server Group Concat with Different characters

  - by Molloch

  I have looked through a number of solutions to emulating "Group concat" functionality in SQL Server. I wanted to make a more human readable solution though and I can't work out how to do it. I have a view: ParentID | ChildName Which contains the records, for example: 1 | Max 1 | Jessie 2 | Steven 2 | Lucy 2 | Jake…

  Read the article

• Public property List needs to Concat 2 types with inheritance

  - by Bernard

  I have 2 lists: one of type A and one of type Aa. type Aa is inherited from type A. So: List<A> listA = new List<A>(); List<Aa> listAa = new List<Aa>(); with class Aa : A I have: public property Lists<A> { get { List<A> newList = new List<A>(); //return…

  Read the article

• Concat wchar_t Unicode strings in C?

  - by Doori Bar

  I'm a beginner, I play with FindFirstFileW() of the winapi - C. The unicoded path is: " \\?\c:\Français\", and I would like to concat "*" to this path of type wchar_t (then I will use it as an arg for FindFirstFileW()). I made two test cases of mine, the first is ansi_string() which seem to work fine, the second…

  Read the article

• Optimize SELECT DISTINCT CONCAT query in MySQL

  - by L. Cosio

  Hello! I'm running this query: SELECT DISTINCT CONCAT(ALFA_CLAVE, FECHA_NACI) FROM listado GROUP BY ALFA_CLAVE HAVING count(CONCAT(ALFA_CLAVE, FECHA_NACI)) > 1 Is there any way to optimize it? Queries are taking 2-3 hours on a table with 850,000 rows. Adding an index to ALFA_CLAVE and FECHA_NACI would…

  Read the article

• Implementing __concat__

  - by Casebash

  I tried to implement __concat__, but it didn't work >>> class lHolder(): ... def __init__(self,l): ... self.l=l ... def __concat__(self, l2): ... return self.l+l2 ... def __iter__(self): ... return self.l.__iter__() ... >>> lHolder([1])+[2]…

  Read the article

• How to concat datatypes like integers(integer with integer) & varchar(varchar with varchar) in mysql

  - by Rachel

  How can we concat integers with integers varchar with varchar int with varchar in MySQL ?

  Read the article

• Erubis block helper throwing error with concat

  - by DEfusion

  I have a couple of block helpers, here's a simple example of what I'm doing: def wrap_foo foo, &block data = capture(&block) content = " <div class=\"foo\" id=\"#{foo}\"> #{data} </div>" concat( content ) end I'm just trying out erubis and it's giving…

  Read the article

• Concat not work phpmyadmin (mysql)

  - by Mercer

  hello, i want update my row and concat my string but i have an error with this query UPDATE FILE SET NOMFIC ='supp_'+D_NOMFIC WHERE IdFile = 2

  Read the article

• SSRS 2005 concat values in dropdown parameter

  - by Mac

  Hi All, I have a dataset which I want to use as a parameter for my chart in SSRS. The puzzle that I am trying to solve is as below. My DataSet has 4 columns and in the Dropdown parameter I can only specify label and value. I am not able to specify two columns as Label and two columns as value. Does…

  Read the article

• Linq To Sql Concat() dropping fields in created TSQL

  - by user191468

  This is strange. I am moving a stored proc to a service. The TSQL unions multiple selects. To replicate this I created multiple queries resulting in a common new concrete type. Then I issue a return result.ToString(); and the resulting SQL selects have varying numbers of columns specified thus…

  Read the article

• JavaScript Concat

  - by nobosh

  Via jquery / Javascript Given a number 1234567891234 How can I concat, or truncast By removing the 2 from the left to make that number a valid integer I can insert into MySQL:' 4567891234 Thanks

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >