Search Results

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

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

• Lose the last 3 chars from string variable

  - by Phil

  if the last 4 chars in my string(result) are " AND" or the last three chars are " OR" I would like to remove these from the string. So far I have am trying result.trimend and a few other methods but am unsure how to get it working. Thanks

  Read the article

• How to switch from VARCHAR to TEXT in SQL 2000?

  - by MatthewMartin

  What do I need to consider before I switch a bunch of fields from VARCHAR(bignumber) to TEXT? Aside from performance, and sometime in the far future TEXT will be deprecated, and aside from the fact that it looks like I need to drop and recreate the table to alter the column's data type? This is for SQL 2000-- I can't do VARCHAR(max) and VARCHAR(8000) isn't large enough.

  Read the article

• Simple question, c#.NET enter string value in textbox

  - by ilkdrl

  if user enter string value in the textbox and press button, i should see error message in label about entered string value.. How can i do that? and what is the code?

  Read the article

• String literals C++?

  - by Bad Man

  I need to do the following C# code in C++ (if possible). I have to const a long string with lots of freaking quotes and other stuff in it. const String _literal = @"I can use "quotes" inside here";

  Read the article

• Python matching some characters into a string

  - by roaksoax

  Hi All I'm trying to extract/match data from a string using regular expression but I don't seem to get it. I wan't to extract the highlighted characters from the following string: /xubuntu/daily/current/lucid-alternate-**i386**.iso This should also work in case of: /xubuntu/daily/current/lucid-alternate-**amd64**.iso Thanks a lot for your help.

  Read the article

• How do I change this query to linq to sql?

  - by Piyush

  Query: select emp.empname as Name, dep.depname as Department from Employee as emp inner join Department as dep on emp.depid=dep.depid where emp.id='2' How can I change this to linq to sql?

  Read the article

• Passing a string parameter in a JavaScript function on MVC

  - by PlayKid

  Hi there, I tried to pass a string value into a JavaScript function like below: <%= "'" + prop.property_description + "'") %>) But it does not seems to be the best option, is there a better way to do the above without concatenate the string values with "'"? Thanks

  Read the article

• Limit String Length

  - by Belgin Fish

  Hi, I'm looking for a way to limit a string in php and add on ... at the end if the string was too long. Thanks :)

  Read the article

• Is there anething like @-quoted string in Actionscript?

  - by Ole Jak

  For example in C# @-quoted string literals start with @ and are enclosed in double quotation marks... So Is there anething like @-quoted string in Actionscript?

  Read the article

• How to ignore noiseXXX.txt files for a specific column in SQL Server 2005?

  - by John MacIntyre

  I have a product table where the description column is fulltext indexed. The problem is, users frequently search a single word, which happens to be in the noiseXXX.txt files. We'd like to keep the noise word functionality enabled, but is there anyway to turn it off just for this one column? I think you can do this in 2008 with the SET STOPLIST=OFF, but I can't seem to find similar functionality in SQL Server 2005.

  Read the article

• String replace for personalize code generator

  - by Xurxof

  I must do a automatic codes generator with user-configurable string with predefined keys and can not find a good way to do it. For example, a string OT-{CustomCode}-{Date}-{##} could generate codes OT-C0001-20100420-01 OT-C0001-20100420-02 I thought of using RegExpr.Replace(), but I would have problems if the code of a customer was {##} Any help is welcome! (and sorry for my english)

  Read the article

• In Java how does one turn a String into a char or a char into a String?

  - by David

  Is there a way to turn a char into a String or a String with one letter into a char (like how you can turn an int into a double and a double into an int)? (please link to the relevant documentation if you can). How do I go about finding something like this that I'm only vaguely aware of in the documentation?

  Read the article

• Hyper-V snapshot backup strategy appropriate for production SQL server?

  - by Chuck

  So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups?

  Read the article

• C++ conversion from string to object identifier

  - by 104250004363501275012

  I'm writing a program in C++ that reads in some data from an external file in order to set the values of static variables. Is it possible to convert a string to an object identifier? (e.g. convert the string "CheckBox::Unchecked" into and identifier for the object CheckBox::unchecked)

  Read the article

• pass string or data of local file between viewcontrollers

  - by Jonathan

  In my last question i asked how to best send a string from one view controller to another, both which were on a navigation stack: http://stackoverflow.com/questions/2898860/pass-string-from-tableviewcontroller-to-viewcontroller-in-navigation-stack However I just realised I can either pass the path to the file in the app's document's folder as the first (the table view) has already accessed the data in the file should I pass viewcontroller the data to the pushed VC?

  Read the article

• How to convert SQL Statement with TOP, COUNT and GROUP BY to return an object list with LINQ

  - by Junior Mayhé

  Hello guys does anyone know how to convert this SQL statement to a LINQ to a List? SELECT TOP(5) COUNT(CategoryId), CategoryName FROM Tickets GROUP BY CategoryName The result would be something like public static List<Categories> List() { MyEntities db = new MyEntities(); /* here it should return a list o Category type */; return db.Category.GroupBy(...).OrderBy(...); }

  Read the article

• Is there a better way to format this date string

  - by Mark Breen

  Hello is there are better way to structure this line of code, as you can see, I am changing the format of a string that contains a date. lblCourseStartDate.Text = String.Format("{0:D}", DateTime.Parse(CourseStartDate)); I just found it untidy that I am converting twice or three times to get the format I want. Thanks

  Read the article

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

• Java: how to initialize String[]?

  - by Heoa

  Error % javac StringTest.java StringTest.java:4: variable errorSoon might not have been initialized errorSoon[0] = "Error, why?"; Code public class StringTest { public static void main(String[] args) { String[] errorSoon; errorSoon[0] = "Error, why?"; } }

  Read the article

• Get all characters from a string with their number

  - by terence6

  How in Java can I get list of all characters appearing in string, with number of their appearances ? Let's say we have a string "I am really busy right now" so I should get : i-2, a-2, r-2, m-1 and so on.

  Read the article

• PHP Speed - Many Echos vs Building a String

  - by Chris

  Wondering if anyone knows if either of these methods would produce an output faster: Method 1 for ($i=1;$i<99999;$i++) { echo $i, '<br>'; } or Method 2 for ($i=1;$i<99999;$i++) { $string .= $i . '<br>'; } echo $string; Thanks for any input you have.

  Read the article

• Easiest way to make copy SQL Server DB to test DB?

  - by Curtis White

  What is the easiest way to take a SQL Server database and make a test copy of it? I have looked through some existing topics but not sure if there is an easier way. I have database publisher. I want to be able to keep both database on the same server, potentially.

  Read the article

• JQuery removing '-' character from string

  - by Zaps

  Hi, I hope this question isn't too basic. I have a string "-123445". Is it possible to remove the '-' character from the string? I have tried the following but to no avail: $mylabel.text("-123456"); $mylabel.text().replace('-', ''); Any help would be greatly appreciated. Thanks, Zaps

  Read the article

• SQL: how to predicate over stored procedure's result sets?

  - by Ariel

  Simple question I couldn't figure out (not a SQL expert... sorry): I want to do a select on the result set of sp_who2. How can I? for ex. select SPID from [result set from sp_who2]

  Read the article

• In String.replace("\c","") what ASCII value is ""?

  - by Tom

  Hi, im just writing my own replace method for any weird characters and i used the ASCI value 0, null to replace unwanted characters, i was hoping for them to be 'deleted', but this doesnt work. A gap just appears in the string. What exactly does String.Replace() do when removing a character for ""? Does it shift them all down and then 'delete' the final character or something?

  Read the article

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