Search Results

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

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

• c++ address string -> long

  - by stefan

  I got an adress example: 0x003533 , its a string but to use it i need it to be a LONG but i dont know how to do it :S has anybody a solution? so string: "0x003533" to long 0x003533 ??

  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

• How to process this string via regular expression

  - by iiduce

  my string style like this: expression1/field1+expression2*expression3+expression4/field2*expression5*expression6/field3 a real style mybe like this: computer/(100)+web*mail+explorer/(200)*bbs*solution/(300) "+" and "*" represent operator "computer","web"...represent expression (100),(200) represent field num . field num may not exist. I want process the string to this: /(100)+web*+explorer/(200)bbs/(300) rules like this: if expression length is more than 3 and its field is not (200), then add brackets to it.

  Read the article

• I need to itereate a loop to every time find the string appearing after a particular string say "if(

  - by Parth

  I need to itereate a loop to every time find the string appearing after a particular string say "if(OLD.", then which PHP function will be helpfull for me?

  Read the article

• Have I to count transactions before rollback one in catch block in T-SQL?

  - by abatishchev

  I have next block in the end of each my stored procedure for SQL Server 2008 BEGIN TRY BEGIN TRAN -- my code COMMIT END TRY BEGIN CATCH IF (@@trancount > 0) BEGIN ROLLBACK DECLARE @message NVARCHAR(MAX) DECLARE @state INT SELECT @message = ERROR_MESSAGE(), @state = ERROR_STATE() RAISERROR (@message, 11, @state) END END CATCH Is it possible to switch CATCH-block to BEGIN CATCH ROLLBACK DECLARE @message NVARCHAR(MAX) DECLARE @state INT SELECT @message = ERROR_MESSAGE(), @state = ERROR_STATE() RAISERROR (@message, 11, @state) END CATCH or just BEGIN CATCH ROLLBACK END CATCH ?

  Read the article

• String parsing with regular expressions

  - by ed1t

  I have a following string that I would like to parse into either a List or a String[]. (Test)(Testing (Value)) End result should be Test and Testing (Value)

  Read the article

• Best way to create a C String

  - by Daniel

  Hello, I'm currently using char *thisvar = "stringcontenthere"; to declare a string in C.. Is this the best way to declare a string?

  Read the article

• SQL Server: How to get a subitem of sp_helplanguage ?

  - by Quandary

  Question: I can get the SQL Server database language by querying: SELECT @@language And I can get further info via EXEC sp_helplanguage How can I query for a column of sp_helplanguage where name= @@language I do SELECT * FROM sp_helplanguage WHERE name='DEUTSCH' but that obviously doesn't work. What's the correct way to query it ?

  Read the article

• Input string was not in a correct format. Converting String to double .

  - by rafael

  I'm quite a beginner in C# , empty string to double conversion can be carried out under the button1_click event ..but doing it under Public Form1() it gives me this error Input string was not in a correct format. how to solve this please ? thanks in advance .

  Read the article

• When do I need to use Begin / End Blocks and the Go keyword in SQL Server?

  - by Braveyard

  Can someone tell me when and where I need to use begin and end blocks in SQL Server? Also, what exactly does the Go keyword do? Thanks in advance...

  Read the article

• Which user account is running SQLCMD in T-SQL Script without -U and -P option?

  - by niteshg

  I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder. Could you please help me under which account sqlcmd will run if I do not specify -U and -P option in TSQL Script?

  Read the article

• Can a std::string contain embedded nulls?

  - by WilliamKF

  For regular C strings, a NULL signifies the end of data. What about std::string, can I have a string with embedded NULLS?

  Read the article

• Simple/Direct way of contructing a HTML string in Java

  - by das_weezul

  In python I can construct a HTML string without worrying about escaping special characters like < or " by simply enclosing the string in triple quotes like: html_string = """ <html> <body> <p>My text with "quotes" and whatnot!<p> </body> </html> """ Is there a similar way to do this in Java?

  Read the article

• SQL Server - how to set (nolock) hint as a default?

  - by opensas

  is there some way to tell sql server to use the (nolock) hint or every select in a stored procedure? is pretty tiresome to add it to each an every select....

  Read the article

• Way to partialy match a Ruby string using Regexp

  - by Fabiano PS

  I'm working on 2 cases: assume I have those var: a = "hello" b = "hello-SP" b = "not_hello" 1 - Any partial matches I want to accept any string that has the var a inside, so b and c would match. 2 - Patterned match I want to match a string that has a inside, followed by '-', so b would match, c does not. I am having problem, because I always used the syntax /expression/ to define Regexp, so how dinamicaly define an RegExp on Ruby??

  Read the article

• PHP string to object name.

  - by Smickie

  Ok I have a string... $a_string = "Product"; and I want to use this string in a call to a object like this: $this->$a_string->some_function(); How the dickens do I dynamically call that object? (don't think Im on php 5 mind)

  Read the article

• How to retrieve unicode data stored directly in non-unicode field as varchar format in sql server

  - by Samujjal

  I have to create a C# application which displays unicode data in a textbox. But the SQL server column storage has varchar data which contains unicode data. But since varchar is non-unicode based it displays character strings like "????????". Well the problem i am facing is i cant change the column type as there are other dependent application running on it.

  Read the article

• Odd SQL behavior, I'm wondering why this works the way it does.

  - by Matthew Vines

  Consider the following Transact sql. DECLARE @table TABLE(val VARCHAR(255) NULL) INSERT INTO @table (val) VALUES('a') INSERT INTO @table (val) VALUES('b') INSERT INTO @table (val) VALUES('c') INSERT INTO @table (val) VALUES('d') INSERT INTO @table (val) VALUES(NULL) select val from @table where val not in ('a') I would expect this to return b, c, d, NULL but instead it returns b, c, d Why is this the case? Is NULL not evaluated? Is NULL somehow in the set 'a'?

  Read the article

• How to Add a default value in SQL server compact?

  - by Suryakavitha

  Hi , I need to add default value column in SqlServer Compact....i am new to this SQL server compact so Plz anyone tell me the Solution of this.... Thanks In Advance

  Read the article

• ADO.NET connection string and password with "=" in it

  - by Philippe Leybaert

  How do I build a connection string which includes a passsword having a "=" in it? (I'm connecting to MySql 5.1) For example, let's say the password is "Ge5f8z=6", what would the connection string look like? I tried: Server=DBSERV;Database=mydb;UID=myuser;PWD="Ge5f8z=6"; and Server=DBSERV;Database=mydb;UID=myuser;PWD=Ge5f8z=6;" Both don't work.

  Read the article

• String literals in python

  - by kjakeb

  Hello, Is there a way to declare a string variable in python such that everything inside of it is automatically escaped, or has its literal character value? I'm NOT asking how to escape the quotes with slashes, that's obvious. What I'm asking for is a general purpose way for making EVERYTHING in a string literal so that I don't have to manually go through and escape everything for very large strings. Anyone know of a solution? Thanks!

  Read the article

• replace special characters in string in java

  - by zahir

  I want to know how to replace the string in Java. E.g. String a = "adf?sdf"; How can I replace and avoid special characters?

  Read the article

• Best way to create a C/C++ String

  - by Daniel

  Hello, I'm currently using char *thisvar = "stringcontenthere"; to declare a string in C.. Is this the best way to declare a string?

  Read the article

• how can a databse be created on sql server 2005 using c# vs08.

  - by user287745

  to create new a new databse file start sql server management studio express on db server and create it! i would like to create a database using c# in my web application visual studio 08 is it possible? as connection string has to have a name of database to connect, but i want to create one.

  Read the article

• how to convert a file to string directly using c# asp.net

  - by user287745

  i asked a question regarding how to display aspx and cs code on page, one answer was convert to string and display in textbox i would like to know if there is a function in c# asp.net which allows to convert file contents directly to string?

  Read the article

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