Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 478/1278 | < Previous Page | 474 475 476 477 478 479 480 481 482 483 484 485  | Next Page >

• How do I remove database name from SQL Server generated script?

  - by bucha

  Anytime I use 'script table as' - 'Insert To' (or other command), the script generated automatically places the database name in the script. Such as: INSERT INTO [DatabaseName].[dbo].[tblToBeInserted] ... While not a huge problem to just delete it, it has slipped by a few times and the script breaks if run on a different server with a different database name but has the same schema. (Such as running on [DatabaseName.Test]) Is there an option I can change, or can I modify the output in any way to remove this?

  Read the article

• Copy huge tables data from one database to another in SQL Server.

  - by Narasimhulu

  I have two database say DB_A and DB_B. In DB_A database, table having huge data (few tables are having 2 to 10 million data). I want to move the all table data from DB_A to DB_B database. Please help me on writing stored procedures to move efficiently (fast) the data from one database to another.

  Read the article

• Can this statement ever evaluate to FALSE?

  - by BojanG

  I stumbled upon this while doing a review and the author is not available: int n = Convert.ToInt32(text); if (((n > 0) || (n < 0)) || (n == 0)) { return 1; } The code in general looks solid and it's hard for me to believe that the only purpose of this snippet is to confuse reviewers, but I don't see a way for this condition to fail. Am I missing something?

  Read the article

• Subscript out of bounds on a which statement in R

  - by ahandler

  I have data that looks like this: > head(newdata) zero one real 601 0.01273885 0.9872611 1 602 0.01273885 0.3242234 1 I want to select records where one is greater than .5 When I try this, I get "subscript out of bounds." Why am I getting this error? How do I perform this select? newDataGoodPredict <- newdata[ which(one0.5),] Error in newdata[which(one 0.5), ] : subscript out of bounds

  Read the article

• Is there a way to convert a Non-Clustered Index on a Primary Key to a Clustered one? (sql-server 200

  - by Lieven Cardoen

  With Management Studio I can't alter the index. Dropping it doesn't work because it's being used as a foreign key in a lot of other tables. Can I somehow alter it? Or how would you do this?

  Read the article

• While using a switch case loop, can i use the for loop for iterating the cases?

  - by Parth

  In PHP, While using a switch case loop, can i use the for loop for iterating the cases? for example switch ..... foreach($xyz as $abc) { CASE:$abc } default; Is this possible?

  Read the article

• With (or similar) statement in JQuery

  - by Salman A

  Very simple question: I want to optimize the following jQuery code with maximum readability, optimal performance and minimum fuss (fuss = declaring new variables etc): $(".addthis_toolbox").append('<a class="addthis_button_delicious"></a>'); $(".addthis_toolbox").append('<a class="addthis_button_facebook"></a>'); $(".addthis_toolbox").append('<a class="addthis_button_google"></a>'); $(".addthis_toolbox").append('<a class="addthis_button_reddit"></a>'); . . .

  Read the article

• SQL Reporting Services 2005 - Date field based on a user entered date?

  - by Pierce

  Hi, I have a report in report services 2005 that has two date fields. The problem is that if users run this for a large section of time it uses too much resources on our server. It is possible to only allow the end user to enter the start date and then the end date be auto populated/derived from this field (for example they enter the 1st of a month and this automatically change the end date to the last of a month.)

  Read the article

• Run a JavaScript function from a php if statement

  - by user295189

  I am using php conditions and want to know if I can run a JavaScript funtion without some one have to click on it using JavaScript: if($value == 1) { javascript to run the function } How would I do that?

  Read the article

• [Linq to sql] query result what should i use Count() or Any()...

  - by Pandiya Chendur

  I am checking login of a user by this repository method, public bool getLoginStatus(string emailId, string password) { var query = from r in taxidb.Registrations where (r.EmailId == emailId && r.Password==password) select r; if (query.Count() != 0) { return true; } return false; } I saw in one of the previous questions !query.Any() would be faster... Which should i use? Any suggestion....

  Read the article

• converting if else statement to ternary

  - by EquinoX

  I have translated the following code using ternary. However, I knew there was something wrong with it. Can someone please point me into the right direction? ForwardA = 0; ForwardB = 0; //EX Hazard if (EXMEMRegWrite == 1) begin if (EXMEMrd != 0) if (EXMEMrd == IDEXrs) ForwardA = 2'b10; if (EXMEMrd == IDEXrt && IDEXTest == 0) ForwardB = 2'b10; end //MEM Hazard if (MEMWBRegWrite == 1) begin if (MEMWBrd != 0) begin if (!(EXMEMRegWrite == 1 && EXMEMrd != 0 && (EXMEMrd == IDEXrs))) if (MEMWBrd == IDEXrs) ForwardA = 2'b01; if (IDEXTest == 0) begin if (!(EXMEMRegWrite == 1 && EXMEMrd != 0 && (EXMEMrd == IDEXrt))) if (MEMWBrd == IDEXrt) ForwardB = 2'b01; end end end ForwardA = (MEMWBRegWrite && MEMWBrd != 0 && (!(EXMEMRegWrite == 1 && EXMEMrd != 0 && (EXMEMrd == IDEXrs))) && (MEMWBrd == IDEXrs)) ? 2'b01 : ((EXMEMRegWrite && EXMEMrd != 0 && EXMEMrd == IDEXrs) ? 2'b10 : 0); ForwardB = (IDEXTest == 0 && MEMWBRegWrite && MEMWBrd != 0 && (!(EXMEMRegWrite == 1 && EXMEMrd != 0 && (EXMEMrd == IDEXrt))) && (MEMWBrd == IDEXrs)) ? 2'b01 : ((EXMEMRegWrite && EXMEMrd != 0 && EXMEMrd == IDEXrt && IDEXTest == 0) ? 2'b10 : 0);

  Read the article

• foreach statement (get string values)

  - by nhoyti

  Can someone please help me out? My code for splitting the strings is working however, i still need to use the splitted string my page. How can i achieve this? Here's my current code private void SplitStrings() { List<string> listvalues = new List<string>(); listvalues = (List<string>)Session["mylist"]; string[] strvalues = listvalues.ToArray(); if (listvalues != null) { foreach (string strElement in listvalues) { string[] prods = strElement.ToString().Split("|".ToCharArray()); string prodName = prods[0].ToString(); Response.Write(prodName); } } } link text how can i replace the response.write with any label or literal? when i tried to use a literal on the code it displays one single string not all of the strings that's been splitted. any ideas?

  Read the article

• SQL Join Statement Issue

  - by coffeeaddict

  I'm tring to grab all fields from the latest Cash record, and then all fields from the related TransactionInfo record. I can't quite get this to work yet: select t.*, top 1 c.* from Cash c inner join TransactionInfo t on c.TransactionID = t.id order by createdOn desc

  Read the article

• Is the available disk space stored in the sql server (2000) master database?

  - by cindi

  I want to be able to monitor the space left on drives that various databases sit on.

  Read the article

• Google sheet dynamic WHERE clause for query() statement

  - by jason_cant_code

  I have a data table like so: a 1 a 2 b 3 b 4 c 5 c 6 c 7 I want to pull items out of this table by dynamically telling it what letters to pull. My current formula is: =query(A1:B7,"select * where A ='" & D1 & "'"). D1 being the cell I wish to modify to modify the query. I want to be able input into D1 -- a, a,b, a,b,c and have the query work. I know it would involve or statements in the query, but haven't figured out how to make the formula dynamic. I am looking for a general solution for this pattern: a -- A = 'a' a,b -- A = 'a' or A = 'b' a,b,c -- A = 'a' or A = 'b' or A='c' Or any other solution that solves the problem. Edit: So far I have =ArrayFormula(CONCATENATE("A='"&split(D3,",")&"' or ")) this gives A='a' or A='b' or A='c' or for a,b,c. can't figure out how to remove the last or.

  Read the article

• SQL query to get lowest 2 values of a counted query selection (using db2)?

  - by jNoob

  Hi, Imagine I already have a query that returns the following: Col1 | Col2 ------------ A | 2 B | 3 C | 3 D | 4 E | 8 ... Say I used something like this: select Col1, count ( * ) as Col2 \ from ... where ... order by Col2 \ group by Col1 \ So now, all I want to select are (Col1, Col2) such that it returns the selections (a, b) and (c, d) where (b >= all (Col2)) and (d >= ((all (Col2)) - a)). So for the above example, it would return {(A, 2), (B, 3), (C, 3)}. How do I go about doing this? Any help would be highly appreciated. Thanks.

  Read the article

• what could be wrong in this statement in jquery

  - by user297211

  var ajaxURL = "ajax/Login.aspx?txtEmail=" + $('#txtInitialEmail').val()+ "&txtPassword=" + $('#txtPassword').val()

  Read the article

• PHP SQL, SELECT corresponding data from 3 tables at once?

  - by user346325

  I have 3 tables, 'u' 'd' 's' 'u' has userid divid 'd' has divid divname 's' has sname primaryuserid secondaryuserid Now what I'd like to do is display a table with rows of the following format userid, divname, sname Plus figure out a way to decipher whether userid is a primary or secondary for this sname table. I'm able to show userid and divname using a left join, but I don't know how I would add a third table? To make it trickier, there can be more than 1 snames for each userid, up to ~20. Is there a way to display 0-20 snames depending on the userid, seperated with commas?

  Read the article

• sql 2008 query. I am trying to correct this error message

  - by getbruce

  What is wrong with this code? What would be the correct syntax? SELECT EmployeeID, SUM('More than 2 orders') FROM Orders WHERE EmployeeID 2 GROUP BY EmployeeID Msg 8117, Level 16, State 1, Line 1 Operand data type varchar is invalid for sum operator.

  Read the article

• what could be a suitable datatype for storing telephone numbers in sql server 2005?

  - by Mac

  There are various datatypes from which i can choose for example varchar or bigint or decimal or money but which one could be the best in all respect.

  Read the article

• "=null" and select statement!

  - by user329820

  Hi I have asked this question before in this forum and they told me that it will retun an empty result set,I want to know that if I set the column with null values it will retun an empty result set?also the ANSI_NULLS is OFF ,thanks SELECT 'A' FROM T WHERE A = NULL;

  Read the article

• function functionName(if clause here) possible?

  - by Rip

  function getTemplate($tpl if ($vars) echo ", $vars";)...function Is this possible somehow? The above wont work. Thanks

  Read the article

• Cannot we use break statement in a lambda(C#3.0)

  - by Newbie

  Consider this List<int> intList = new List<int> { 1, 2, 3, 4, 5, 6 }; int j = 0; intList.ForEach(i => { if (i.Equals(1)) { j = i; break; } } ); Throwing error: No enclosing loop out of which to break or continue But the below works foreach(int i in intList) { j = i; break; } Why so. Am I making any mistake. Thanks

  Read the article

• What is the best way to truncate a date in SQL Server?

  - by John Gietzen

  If I have a date value like 2010-03-01 17:34:12.018 What is the most efficient way to turn this into 2010-03-01 00:00:00.000?

  Read the article

• [Linq-To-Sql]How to return two values of different datatypes?

  - by Pandiya Chendur

  Here is my repository method which returns UserId , public IQueryable<int> getLoginStatus(string emailId, string password) { return (from r in taxidb.Registrations where (r.EmailId == emailId && r.Password == password) select r.UserId); } How to return UserName which is a string along with UserId... Any suggestion?

  Read the article

< Previous Page | 474 475 476 477 478 479 480 481 482 483 484 485  | Next Page >