Search Results

Search found 59456 results on 2379 pages for 'sql string'.

Page 180/2379 | < Previous Page | 176 177 178 179 180 181 182 183 184 185 186 187  | Next Page >

• 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 do I tokenize a string in C++?

  - by Bill the Lizard

  Java has a convenient split method: String str = "The quick brown fox"; String[] results = str.split(" "); Is there an easy way to do this in C++?

  Read the article

• Finding partial substrings within a string

  - by Peter Chang

  I have two strings which must be compared for similarity. The algorithm must be designed to find the maximal similarity. In this instance, the ordering matters, but intervening (or missing) characters do not. Edit distance cannot be used in this case for various reasons. The situation is basically as follows: string 1: ABCDEFG string 2: AFENBCDGRDLFG the resulting algorithm would find the substrings A, BCD, FG I currently have a recursive solution, but because this must be run on massive amounts of data, any improvements would be greatly appreciated

  Read the article

• Why is "#{String}" a common idiom in Ruby

  - by Tetsujin no Oni

  A Ruby dev I know asked this; my answer is below... Are there other, better reasons? Why do so many Ruby programmers do "{string}" rather than string since the second form is simpler and more efficient?

  Read the article

• Byte from string/int in C++

  - by Tim van Elsloo

  Hi, I'm a beginning user in C++ and I want to know how to do this: How can I 'create' a byte from a string/int. So for example I've: string some_byte = "202"; When I would save that byte to a file, I want that the file is 1 byte instead of 3 bytes. How is that possible? Thanks in advance, Tim

  Read the article

• Find Nth occurrence of a character in a string

  - by jozi

  I need help with creating a C# method that returns the index of the Nth occurance of a character in a string. For instance, the 3rd occurance of the character 't' in the string "dtststx" is 5.

  Read the article

• Is there an SQL Server equivalent to Oracle's RETURNING statement?

  - by Thomas Bratt

  Is there an SQL Server equivalent to Oracle's RETURNING statement? I'm wondering if the OUTPUT clause would help.

  Read the article

• c# string.replace in foreach loop

  - by paradox

  Somehow I can't seem to get string replacement within a foreach loop in C# to work. My code is as follows : foreach (string s in names) { s.Replace("pdf", "txt"); } Am still quite new to LINQ so pardon me if this sounds amateurish ;)

  Read the article

• Simplest way to convert all html links in a string using PHP

  - by Gaz

  I am trying to convert a block of text that contains html text - i'd like to find all http links and convert them for link tracking purposes. So eg anything like this in a string would be converted to the latter <a href="http://www.google.com">Some Link</a> <a href="http://www.mysite.com/tracking.php?url=www.google.com">Some Link</a> Can anyone how to do this taking into account the original string will consists of all sorts of html, images etc..

  Read the article

• How do I select the first row per group in an SQL Query?

  - by mafutrct

  I've got this SQL query: SELECT Foo, Bar, SUM(Values) AS Sum FROM SomeTable GROUP BY Foo, Bar ORDER BY Foo DESC, Sum DESC This results in an output similar to this: 47 1 100 47 0 10 47 2 10 46 0 100 46 1 10 46 2 10 44 0 2 I'd like to have only the first row per Foo and ignore the rest. 47 1 100 46 0 100 44 0 2 How do I do that?

  Read the article

• string function workout in php

  - by Karthik

  I have the string like this, $inp1 = "3 doses at 0[0,0], 1-2 and 6 Month[6,1] [3,2])"; in this internally, going to take the values of square bracket. How can i take this values in the square bracket? any function is there to return the string like this [0,0] [6,1] [3,2] Thanks in advance for help.

  Read the article

• [bash] Escape a string for sed search pattern

  - by Alexander Gladysh

  In my bash script I have an external (received from user) string, which I should use in sed pattern. REPLACE="<funny characters here>" sed "s/KEYWORD/$REPLACE/g" How can I escape the $REPLACE string so it would be safely accepted by sed as a literal replacement? NOTE: The KEYWORD is a dumb substring with no matches etc. It is not supplied by user.

  Read the article

• Code to parse user agent string?

  - by Spot

  As strange as I find this, I have not been able to find a good PHP function anywhere which will do an intelligent parse of a user agent string? Googled it for about 20 minutes now. I have the string already, I just need something that will chop it up and give me at least browser/ver/os. Know of a good snippet anywhere?

  Read the article

• Ruby: How to get the first character of a string

  - by Shpigford

  How can I get the first character in a string using Ruby? Ultimately what I'm doing is taking someone's last name and just creating an initial out of it. So if the string was "Smith" I just want "S".

  Read the article

• How to split a string in combo block quota EX: [ text ] in Jquey

  - by Rueta

  Hi everyone! i'm a newbie in Jquey and i don't know how to do my homework, pls help me ! i have a String EX: this is my text, press here. Now i put in o block character : [here] how can a take slipt string and get text in [ ] into variable 'done'? thankyou !

  Read the article

• Insert character infront of each word in a string using C++

  - by insertable

  Hi all, I have a string, for example; "llama,goat,cow" and I just need to put a '@' in front of each word so my string will look like "@llama,@goat,@cow", but I need the values to be dynamic also, and always with a '@' at the beginning. Not knowing a great deal of C++ could someone please help me find the easiest solution to this problem? Many thanks in advance.

  Read the article

• Is there any function in SQL Server to convert a number into Time format?

  - by Shashi Bhushan

  I am getting a whole number for the duration of product. For example : 62, 103, 184, 4543. I want to convert it in time format. Let say , in case of 62, it would format like '00:01:02'. I am looking for a function which can resolve my problem. Is there any function in SQL Server which convert a number into time format?

  Read the article

• Uses for the capacity value of a string

  - by dreamlax

  In the C++ Standard Library, std::string has a public member function capacity() which returns the size of the internal allocated storage, a value greater than or equal to the number of characters in the string (according to here). What can this value be used for? Does it have something to do with custom allocators?

  Read the article

• Trying to reference a hash using a string value in Ruby

  - by Jim

  How would I refer to a hash using the value of a string - i.e. #!/usr/bin/env ruby foo = Hash.new bar = "foo" "#{bar}"["key"] = "value" results in foo:5:in `[]=': string not matched (IndexError) from foo:5 How do I use the value of bar (foo) to reference the hash named foo? Thanks!

  Read the article

• how to declare a public string with a textbox's text

  - by Ian Lundberg

  i am trying to do public string str = txtText.Text; but it wont let me use txtText.txt so how would I declare that so it can be used everywhere? I can't use it in the button1_click event because if I do it messes it up because I am having a string retrieve from the textbox and set to the textbox so it doesn't work right so I have to have it retrieve the textbox's text somewhere else then set to it.

  Read the article

• How to include the total number of returned rows in the resultset from SELECT T-SQL command?

  - by quarkX

  I would like to ask if there is a way to include the total number of rows, as an additional column, in the returned result sets from a TSQL query using also the Row_Number (SQL 2005) command. For example, getting the results set from a query against Book table in a form similar to this: RowNum BookId BookTitle TotalRows -------------------------------------------- 1 1056 Title1 5 2 1467 Title2 5 3 121 Title3 5 4 1789 Title4 5 5 789 Title5 5

  Read the article

• How can I query the database culture (SQL Server 2005) ?

  - by Quandary

  How can I query the database culture (SQL Server 2005) ? I have problems inserting and getting dates, because the client's servers don't run on the same culture as my developer server. I can adjust the date, but I need to know the server's culture...

  Read the article

• How to lock a table for inserting in sql?

  - by Nandini

  hi, i have a web application in which i have a page named 'Data'.Many people will try to insert data into the table at a given time.So the reference no other than the primary key will get duplicated which should not be permitted.For inserting the data into the DB table, i am using a stored procedure in SQL.In my vb.net web application, i am using Business layer with enterprise library for calling the stored procedure.Now i want to lock the table for inserting so that when multiple user inserts, there wont be any complication.How can i do this?Please advice Regards

  Read the article

• Delete System Files containing string

  - by Fuzz Evans

  I am trying to write a batch file that will examine a given directory, read each file for a given string "Example" and then delete any files that contain the string. The files are also System Files so I don't know what the exact extension is or if that matters (maybe you can just omit a file type filter and have it read all files?). Some of the files will be locked from reading as well so it needs to handle access denial errors if that occurs, not sure how batch files handle that.

  Read the article

• JSTL expression evaluation from a string

  - by Venkatesh

  Is it possible to evaluate a String as EL expression in JSP and get value from it? I need an expression like ${model.${fieldPath}} where fieldPath will contain the required object path from a nested object model. I can get the actual field path by using but I am not sure how to evaluate a string and get the value from it Any help regarding this would be highly appreciated.

  Read the article

< Previous Page | 176 177 178 179 180 181 182 183 184 185 186 187  | Next Page >