Search Results

Search found 28469 results on 1139 pages for 'select statement'.

Page 141/1139 | < Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >

• can we have a stored procedure with output parameters and return statement?

  - by VenkatReddy.Ravu

  Hi,Can a stored procedure have output parameters and return statement? If so can anybody give me a simple example.thank you all.

  Read the article

• [jquery/javascript] How select all checkboxes with class "xxx" ?

  - by marc

  Welcome, It it possible to select all checkboxes / uncheck all checkboxes what have class "xxx" ? I can't use "name" and "ID" because there are generated dynamical via PHP and i don't know their name. So maybye i can add class "xxx" for these what i wan't control ? Is is possible ? Or, if not possible. Maybye i can select all / unselect what are inside table with id "selectall" ? Regards

  Read the article

• jQuery UI - Multiple Select behavior (ctrl+click) by default for 'selectable'?

  - by Yuvi

  Is there a way to make the jQuery UI's Selectable interaction go into 'multiple selects' (select via left click, click again to unselect) behavoir, rather than the click-to-exclusively-select-and-unselect-everything-else behavior?

  Read the article

• In Javascript, when is a new scope created? (with a new function and in a "with" statement) Are the

  - by Jian Lin

  In Javascript, when is a new scope created? The 2 situations I know of are: with a new function in a "with" statement as a note, any new block (in if-then-else, loops, or just beginning a block for no other reason) won't create a new scope. Is there a third situation where a new scope is created besides the two situations above? Thanks.

  Read the article

• What is the sql statement for searching in text using MS SQL Server 2008?

  - by SzamDev

  Hi If I have text sotred in my DB, for example: "There are 2 books on the table". Maybe the user wants to search for "books" or the user wants to search in this text for any thing. What is the best SQL Statement to do that?. Thanks in advance.

  Read the article

• How can one select specific sibling of a context node using jQuery?

  - by C.W.Holeman II

  How can one select a specific sibling of a context node using jQuery? Specifically, given context node myContextNode select the sibling span with class myClass. document.evaluate("../span[@class='myClass']", myContextNode, lu, XPathResult.FIRST_ORDERED_NODE_TYPE, null). singleNodeValue;

  Read the article

• ORACLE:- 'SELECT ORDER BY ASC' but 'USA' always first.

  - by Robert

  I have to write a drop down query for countries. But USA should always be first. The rest of the countries are in alphabetical order I tried the following query SELECT countries_id ,countries_name FROM get_countries WHERE countries_id = 138 UNION SELECT countries_id ,countries_name FROM get_countries WHERE countries_id != 138 ORDER BY 2 ASC

  Read the article

• Supplying my own Query Statement - Can it be done?

  - by Randy Minder

  I am creating a Crystal 2008 report, and I'd like to provide it a T-SQL statement for data generation, instead of selecting and joining together tables. Can this be done?

  Read the article

• Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

  - by Manoj Wadhwani

  Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'. when i m trying to execute sp then it through this error. Could you please help it out.

  Read the article

• Is foreach statement iterate in order or it might be random order?

  - by ablimit

  I was wondering if the foreach statement in perl iterates the items in an array in consistent order ? That is, do I get different results if I use foreach multiple times on the same array or list ? Thanks.

  Read the article

• "With" statement in Python with multiple files to handle.

  - by systempuntoout

  How do i use the with statement in this case? f_spam = open(spam,'r') f_bar = open(eggs,'r') ... do something with these files ... f_spam.close() f_bar.close()

  Read the article

• mysql select from one server insert to another mysql server ?

  - by Shvilam

  I wont to do insert to one mysqll server to and get the data or do the select part of the insert into select from anther mysql server not just copy entire tables is this possible in my sql I know that in MS Sql server you can do a linked server thanks

  Read the article

• Can "Distinct" key Word be used twice in a single Select Query?

  - by OM The Eternity

  Can "Distinct" key Word be used twice in a single Select Query? like wise: select DISTINCT(trackid), DISTINCT(table_name) from jos_audittrail where live = 0 AND operation = UPDATE Thanks

  Read the article

• How to select with Linq to Entity from one table with two different variables?

  - by George

  I have a table where I have items under two different types as you can see below: How can I select from this table with Linq to Entity to get the result with two variables? where ItemType = Type1 and ItemType == Type2 .... select new {typeOne == "", typeTwo == ""}; ID ItemName ItemType 1 ItemOne Type1 2 ItemTwo Type1 3 ItemThree Type1 4 ItemFour Type1 5 ItemTFive Type2 6 ItemSix Type2 7 ItemSeven Type2 8 ItemEight Type2

  Read the article

• How to select distinct in SQl Server 2008 but for only one field out of many?

  - by bakerjr

  I have a query: SELECT Content.content_name, Language2.Name, Language2.language_id, Content.id, Content.content_description, FROM Language AS Language2 LEFT JOIN contents AS Content ON (Language2.language_id = Content.language_id) How do I select only the distinct content_name?

  Read the article

• How can I add a tab in jquery-ui Tabs and then select it?

  - by Bob

  I understand how to add a jquery-ui tab, and I understand how to select a tab by index number, but how can I both add a tab and then select it? For example, in the following demo you can add a tab, but then you have to click on it for it to be displayed: http://jqueryui.com/demos/tabs/#manipulation I'm on jquery 1.4.2 and jquery-ui 1.8rc3.

  Read the article

• How do I mysql select with aliases from another table?

  - by Rob

  I'm working with a CMS system where I cannot control database column names. And I've got two related tables: Table: content +------------+----------+----------+----------+----------+ | content_id | column_1 | column_2 | column_3 | column_4 | +------------+----------+----------+----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+----------+----------+----------+----------+ Table: column_names +------------+-------------+ | column_id | column_name | +------------+-------------+ | 1 | good_text | | 2 | bad_text | | 3 | blue_text | | 4 | red_text | +------------+-------------+ What I'd like to do here is select from the first table, but select the columns AS the column_name from the second table. So my result would look like: +------------+-----------+----------+-----------+----------+ | content_id | good_text | bad_text | blue_text | red_text | +------------+-----------+----------+-----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+-----------+----------+-----------+----------+

  Read the article

• Which directories does include statement search in C/C++?

  - by user198729

  test.c: include "file.h"; In the above statement, which directories will be searched ? I suppose the directory where test.c locates will be searched, right? But is that all? BTW, what's the benifit to use a header file? Java doesn't require a header file...

  Read the article

• Generate Delete Statement From Foreign Key Relationships in SQL 2008 ?

  - by Element

  Is it possible via script/tool to generate a delete statement based on the tables fk relations. i.e. I have the table: DelMe(ID) and there are 30 tables with fk references to its ID that I need to delete first, is there some tool/script that I can run that will generate the 30 delete statements based on the FK relations for me ? (btw I know about cascade delete on the relations, I can't use it in this existing db) I'm using Microsoft SQL Server 2008

  Read the article

• How do I do this SELECT/OPTION in HTML? (javascript)

  - by alex

  Suppose I have this: <select id="myselect"> <option rel="a">1</option> <option rel="b">2</option> <select> How do I use JQuery so that onchange $("#myselect"), I alert the "rel" part of the option (not 1 or 2)

  Read the article

• [MYSQL Query] How to select all the entries from the last month?

  - by rasouza

  I have a table with entries which has a DATE field. Each entry has a distinct date. I'd like to select all the entries from the last month. How? I tried SELECT * FROM registries WHERE reg_date = DATE_FORMAT(MAX(reg_date), "%m") without success thx

  Read the article

• Some bold and some simple word within the same statement.

  - by Harikrishna

  I want to show some bold and some simple word within the same sentence.If I use the textbox then every word will be simple, not some bold and some simple so I want a control's text property in that I can write some bold and some simple word within the same statement

  Read the article

• How to select data in JSON based on other JSON data? Javascript

  - by user1699030

  Is it possible to select certain data in a JSON Object using other data in the same JSON Object. Similar to MySQL. For example: myObj = {"elements" : [ { "name" : "Hydrogen", "symbol" : "H" }, { "name" : "Silver", "symbol" : "Ag" }]}; I want to select "Hydrogen" where the symbol is "H". Instead of having to put in something like this: document.getElementByID("TEST").innerHTML = myObj.elements[0].name; Thank you in advance.

  Read the article

• ORACLE:- 'SELECT ODER BY ASC' but 'USA' always first.

  - by Robert

  I have to write a drop down query for countries. But USA hould always be first. The rest of the countries are in alphabetical order I tried the following query SELECT countries_id ,countries_name FROM get_countries WHERE countries_id = 138 UNION SELECT countries_id ,countries_name FROM get_countries WHERE countries_id != 138 ORDER BY 2 ASC

  Read the article

• methods of joining 2 tables without using JOIN or SELECT more than one distinct table in the query

  - by GB_J

  Is there a way of joining results from 2 tables without using JOIN or SELECT from more than one table? The reason being the database im working with requires queries that only contain SELECT, FROM, and WHERE clauses containing only one distinct table. I do, however, need information from other tables for the project i'm working on. More info: the querier returns the query results in a .csv format, is there something we can manipulate there?

  Read the article

< Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >