Search Results

Search found 6988 results on 280 pages for 'if statement'.

Page 118/280 | < Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >

• Is it possible to run an alter on all my database objects to test them

  - by Khanzor

  I'm in the course of doing some schema migrations, and would like to know if it's possible or advisable to run every stored procedure, view and function in my database as an alter statement to "compile" them all to make sure nothing is completely broken.

  Read the article

• How to order by column with non-null values first in sql

  - by devlife

  I need to write a sql statement to select all users ordered by lastname, firstname. This is the part I know how to do :) What I don't know how to do is to order by non-null values first. Right now I get this: null, null null, null p1Last, p1First p2Last, p2First etc I need to get: p1Last, p1First p2Last, p2First null, null null, null Any thoughts?

  Read the article

• How can I delay one feed in wordpress but not the others?

  - by mattloak

  Is there anyway to create a special feed in Wordpress that is on a delay that I can distribute to some of our content partners? I have found some tutorials on how to delay your feed (http://wpengineer.com/publish-the-feed-later/) but it uses the conditional statement is_feed and I don't want to apply this to all feeds, just one particular feed. Any advice?

  Read the article

• fetch value of ipaddress

  - by neha soni

  i want to get ipaddress of mycomputer in a variable this statement prints ipaddress of my computer but i want to assign it in a varible how can i fetch the value of ipaddress from inet_ntoa(inaddrr(ifr_addr.sa_data)) into an variable ip of char* type . printf("IP Address: %s\n", inet_ntoa(inaddrr(ifr_addr.sa_data)));

  Read the article

• switch case in where clause

  - by Nimesh

  hi, i need to check three conditions: if @filter = 1 { **select * from employeestable where rating is not null** } else if @filter = 2 { **select * from employeestable where rating is null** } else { **select * from employeestable** } This i need to do using a case statement. now i have more than 30 lines of query, if i use case i can reduce my code upto 70% Please let mek now how can i do this.

  Read the article

• How do i compare 2 strings in shell?

  - by Thomas

  I want the user to input something at the command line either -l or -e. so e.g. $./report.sh -e I want an if statement to split up whatever decision they make so i have tried... if [$1=="-e"]; echo "-e"; else; echo "-l"; fi obviously doesn't work though Thanks

  Read the article

• Output a NULL cell value in Excel

  - by Peter

  I have an IF statement. If a cell = n, then do something, else output NULL =IF(A1=5, "Success", NULL) // #NAME? =IF(A1=5, "Success", "NULL") // NULL (as in text, not actually NULL!) =IF(A1=5, "Success", "") // blank but not NULL =IF(A1=5, "Success", 0) // zero value but not NULL

  Read the article

• Truncate all tables in postgres database

  - by Aaron

  I regularly need to delete all the data from my postgresql database before a rebuild. How would I do this directly in SQL? At the moment I've managed to come up with a SQL statement that returns all the commands I need to execute: SELECT 'TRUNCATE TABLE ' || tablename || ';' FROM pg_tables WHERE tableowner='MYUSER'; but I cant see a way to execute them programatically once I have them... Thanks in advance

  Read the article

• How to change pop view controller animation on back button ?

  - by Aryabhatt

  Hi all , I am pushing my view controller with the following statement : [[self navigationController] pushViewController:self.customViewController animatedWithTransition:UIViewAnimationTransitionFlipFromLeft]; Now when I am pressing the back button I want to animate it with the uiviewanimationtransitionflipfromright . like [self.navigationController popViewControllerAnimatedWithTransition:UIViewAnimationTransitionFlipFromLeft]; How Can I do so ? Thanks

  Read the article

• How do I write this GROUP BY query in MYSQL?

  - by alex

  Suppose I have a column called "fruits" I want to select all of the top fruits, ranked by fruits (and group by + count). Fruits: orange orange apple banana apple apple In this case, the select statement would return: apple, 3 orange, 2 banana, 1

  Read the article

• Can you make Asp.net MVC View wireup compile time safe?

  - by Maslow

  Take the standard return statement for a controller: return View("Index"); is there a way to make this thing compile time safe? using static reflection or some other trick?

  Read the article

• How to return empty cells for repeated values and keep only the cells which are different ?

  - by Ashraf Bashir

  I have a query that selects some fields to display from a table SELECT Field1, Field2, Field3, Field4 FROM table1 I want instead of returning : To return: How could I modify my SQL statement to return the second figure ? Or at least how to change the gridview properties of .Net to do so (if this is possible) ?

  Read the article

• count total records after groupBy select

  - by solomongaby

  Hello, I have a mysql select query that has a groupBy. I want to count all the records after the group by statement. Is there a way for this directly from mysql ? thanks.

  Read the article

• how to break outer loop from switch case

  - by Ravisha

  I have below code , enter code here for(int i=0;i<15;i++) { switch(i) { case 6: break; case 7: //Want to break the outer loop } } enter code here Is there a way to break the loop inside case statement? I know of one way is to use labels and goto .

  Read the article

• set difference in SQL query

  - by TheObserver

  I'm trying to select records with a statement SELECT * FROM A WHERE LEFT(B, 5) IN (SELECT * FROM (SELECT LEFT(A.B,5), COUNT(DISTINCT A.C) c_count FROM A GROUP BY LEFT(B,5) ) p1 WHERE p1.c_count = 1 ) AND C IN (SELECT * FROM (SELECT A.C , COUNT(DISTINCT LEFT(A.B,5)) b_count FROM A GROUP BY C ) p2 WHERE p2.b_count = 1) which takes a long time to run ~15 sec. Is there a better way of writing this SQL?

  Read the article

• Is there any free tool for profiler of MYSQL database?

  - by Paresh

  Is there any free tool for profiler of MYSQL database? I want to capture the SQL statement from application. and want to tune it for performenencae. Can any one suggest? Thanks, Paresh

  Read the article

• Modify xml element name in SQL Server

  - by sesame

  I want to change element name with following statement: SET @myDoc.modify('replace value of (/CustomerInfo)[1] with "Customer"') from <CustomerInfo>     <ID1</ID> </CustomerInfo> to <Customer>     <ID1</ID> </Customer> But failed. So how can i change it just in sql ?

  Read the article

• Logical operator AND having higher order of precedence than IN

  - by AspOnMyNet

  I’ve read that logical operator AND has higher order of precedence than logical operator IN, but that doesn’t make sense since if that was true, then wouldn’t in the following statement the AND condition got evaluated before the IN condition ( thus before IN operator would be able to check whether Released field equals to any of the values specified within parentheses ? SELECT Song, Released, Rating FROM Songs WHERE Released IN (1967, 1977, 1987) AND SongName = ’WTTJ’ thanx

  Read the article

• Loading Hybrid Dimension Table with SCD1 and SCD2 attributes + SSIS

  - by Nev_Rahd

  Hello I am just in a process of starting a new task, wherein in i need to load Hybrid Dimension Table with SCD1 and SCD2. This need to be achieved as a SSIS Package. Can someone guide what would be the best way dealing this in SSIS, should i used SCD component or there is other way? What are the best practices for this. For SCD2 type, am using Merge statement. Thanks

  Read the article

• What information should I log if I detect that my site is under attack?

  - by Abe Miessler

  In the code below if I get into the if statement I can safely say my site is under attack. What information is it a good idea to log? Any recommendations on actions that can be taken to minimize the damage at this point? protected void btn_Search_Click(object sender, EventArgs e) { if(tb_SearchBox.Text.Length > tb_SearchBox.MaxLength) { //What should i log? //What actions should I take? } //Otherwise search }

  Read the article

• Is it allowed to load Swing classes in non-EDT thread?

  - by ddimitrov

  After the introduction of Java Memory Model, the Swing guidelines were changed to state that any Swing components need to be instantiated on the EDT in order to avoid non-published instance state. What I could not find anywhere is whether the classloading is also mandated to be on the EDT or can we pre-load key Swing classes in a background thread? Is there any official statement from Sun/Oracle on this? Are there any classes that are known to hold non-threadsafe static state, hence need to be loaded on EDT?

  Read the article

• How can I execute an Oracle procedure using UnixODBC?

  - by eriks

  I am trying to execute the procedure using execute <procedure_name>('A,'B'), but received an error that the SQL statement cannot be executed. What am I doing wrong?

  Read the article

• How do I do batch upserts in SQL Server?

  - by Dmitri Nesteruk

  I'm using the MERGE statement to upsert rows in an sql server 2008 database. However, my sproc is a single-row operation, whereas in fact I'd prefer to batch these. Is this even possible and, if so, how do I do it?

  Read the article

• Segregate top element out of a list using XSL

  - by Chris

  I currently have a <xsl:foreach> statement in my XSL processing all elements in this XML file. What I want to do though is process the first one separately to the rest. How can I achieve this?

  Read the article

• SQLCE qand C#; Populate a DataSet with ALL the Tables from a SQLCE DB

  - by Zion

  How would I Populate a DataSet with ALL the Tables from a SQLCE DB. Is this possible in ONE SQL select statement? I know that I can call seperate select statements with the names of the table I need data from but I need a generic solution that just dumps all the tables from the SQLCE DB into a Dataset. Thanks

  Read the article

< Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >