Search Results

Search found 24675 results on 987 pages for 'table'.

Page 656/987 | < Previous Page | 652 653 654 655 656 657 658 659 660 661 662 663  | Next Page >

• MS Sql Server Object Creation / Alter Script

  - by Chris Klepeis

  Hi, In Sql Server when you select to modify a SP or UDF it loads the objects alter query in a query window. Are these queries accessible in a system table so I can store the alter statements somewhere? It looks like syscomments has some objects but not all of them. Thanks

  Read the article

• How to 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

• Could anyone help me with the script for this

  - by Vinoj Nambiar

  have a table like this empid questionid options 1 1 A 2 1 A 3 1 B 4 1 C now i need result like this questionid responseA responseB responseC 1 50% 10% 10%

  Read the article

• sql query without subquery

  - by user1285737

  I need to rewrite this query and I'm not allowed to use a subquery. I need to select the name and color of the parts that are heavier than the wheel. SELECT name, color FROM parts WHERE weight > (SELECT weight FROM parts WHERE name="wheel"); This is the table: PARTS ID NAME COLOR WEIGHT 1 wheel black 100 2 tire black 50 3 gear red 20 Thanks in advance

  Read the article

• Migrate MySQL database to Sql Server

  - by RPK

  I recently encountered a problem in my production database due to MySQL bug. The bug is in the TimeStamp column. To avoid any inconvenience, I want to migrate the database to either Sql Server. Is there any FREE tool to easily and reliably migrate data and table structures?

  Read the article

• Is a clear and replace more efficient than a loop checking all records?

  - by Matt

  I have a C# List, that is filled from a database.. So far its only 1400 records, but I expect it to grow a LOT.. Routinely I do a check for new data on the entire list.. What I'm trying to figure out is this, is it faster to simply clear the List and reload all the data from the table, or would checking each record be faster.. Intuition tells me that the dump and load method would be faster, but I thought I should check first...

  Read the article

• How to search by categories using Drupal trip_search module

  - by user75472

  I am using trip_search module and when searched it displays all the results. I just want search result only from one table. What can I do for this? And I don't have any idea about function module_invoke used in trip_search module. Hope to get answer.

  Read the article

• UIWebView doesn't scroll to the bottom of the webpage loaded/created

  - by tom

  I have a UIWebView inside a normal UIViewController. The content of the UIWebView is programming/dynamically created in my program, and it could be very long (multiple table rows). Somehow, after loading, the page won't scroll more then one and half screen of content when swipe on the screen. Because of that I can only see the beginning few rows of data, but not the many others after them. Why is that?

  Read the article

• MySQL - Extracting Time in correct format

  - by mouthpiec

  Hi, I have a table with a coloumn of type "time", and the values in this coloumn are stored as follows: 20:45:00, 18:00:00, etc. Now when displaying the result, I am not getting the minutes, but just 00. I am using the following to get the time: SELECT TIME_FORMAT(time, '%h:%m') as time FROM ......... etc

  Read the article

• how to specify literal value in linq union

  - by lowlyintern

  I have the following SQL query, note I want the literal value '0' in the second field in the second SELECT statement from the ItemSale table. How do I express this in LINQ? I get the error message 'Invalid anonymous type member declarator'. SELECT BranchNumber,QuantitySold FROM Department UNION SELECT BranchNumber,0 FROM ItemSale How to express the '0' in LINQ? var unionQuery = (from dept in Department select new { dept.BranchNumber, dept.QuantitySold, }) .Concat(from item in ItemSale select new { item.BranchNumber, 0 });

  Read the article

• Make a final call to the Database when user leaves website (ASPX)?

  - by Jisaak

  I have a system set up to lock certain content in a database table so only one user can edit that content at a time. Easy enough and that part is working fine. But now I'm at a road block of how to send a request to "unlock" the content. I have the stored procedure to unlock the content, but how/where would I call it when the user just closes their browser?

  Read the article

• Is there a good IDE for SQLite ?

  - by Chris Conway

  Is there a tool out there that can interact with a SQLite database in a similar way that TOAD works with Oracle or Management Studio works with SQL Server? I'm looking for something that visually shows table structures, views, etc. Looking to target the Windows platform (preferably Vista). Thanks!

  Read the article

• mysql query for this problem

  - by Arun

  hi i have a table as follows id,school,address,city,phone,email,fax . There is almost 40 cities . I need to select 1 entry from each city. can any one guide me

  Read the article

• how to print background image on printer as watermark

  - by air

  i have one image background of table with following syntax style="background-image(URL)" the problem is when i print it on printer it did't print. can you please tell me how to get this image background also get it printed on paper as watermark. Thanks

  Read the article

• case in group by in a store procedure

  - by Luca Romagnoli

  is possible do a case in a group by? similar to this: select * from table GROUP BY CASE WHEN @Attivita=0 THEN (RANK() OVER (GROUP BY Nome,AccountID,Matricola DESC)) END thanks

  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

• RSS feed publish date-time(GMT) to unix timestamp format using php

  - by PHP-Prabhu

  can anyone reply me, How do convert RSS feed publish date-time(GMT) to UNIX time-stamp using php. I need to store the date into my table with the field'd data type as TIMESTAMP.

  Read the article

• Postgresql - Edit function signature

  - by drave

  POSTGRESQL 8.4.3 - i created a function with this signature CREATE OR REPLACE FUNCTION logcountforlasthour() RETURNS SETOF record AS realised i wanted to change it to this CREATE OR REPLACE FUNCTION logcountforlasthour() RETURNS TABLE(ip bigint, count bigint) record AS but when i apply that change in the query tool it isnt accepted or rather it is accepted, there is no syntax error, but the text of the function has not been changed. even if i run "DROP FUNCTION logcountforlasthour()" between edits the old syntax comes back if i edit the body of the function, thats fine, it changes but not the signature is there something i'm missing thanks

  Read the article

• TSQL Query - return all seconds between two dates

  - by BrokeMyLegBiking

  I need a TSQL query which returns all seconds since a given begin date. I am going to use this to left outer join against another table to see how many bytes were downloaded each second. I am using Sql Server 2008.

  Read the article

• Library to edit odt documents in php

  - by neo

  I try to edit ODT-documents programmaticly in PHP. In fact I just want to do some text replacement and adding new rows in a table. I know that a normal ODF document is an archive containing XML-files. But before I reinvent the wheel: is there any library which does most of the tasks? Or should I just parse the XML-file in a DOM-parser and modify it?

  Read the article

• need help to construct query

  - by Learner

  i have the following result and i would like to construct the select query from the following result in java, Please help me how to go about , tablename columnname size order employee name 25 1 employee sex 25 2 employee contactNumber 50 3 employee salary 25 4 address street 25 5 address country 25 6 from this i would like to construct query like select T1.name, T1.sex,T1.contactNumber, T1.salaryT2.street, T2.contry from tablename1[employee] T1, tablename2[address] T2 how to construt the above query in java, here table name can be N also the columname can be also N. Please help me to achieve the above. Thanks and Regards

  Read the article

• how to bind association in RoR

  - by ashok

  I have two tables, AppTemplate and AppTemplateMeta AppTemplate table has column id, MetaID, name etc. I have associated these two model like this class AppTemplate < ActiveRecord::Base set_table_name 'AppTemplate' belongs_to :app_template_meta, :class_name => "AppTemplateMeta", :foreign_key => 'MetaID' end If we fetch data using AppTemplate.all, I want associated meta details also. But currently it's not returning associated meta details. It just returns AppTemplate details. any guys can help me for this

  Read the article

• Double-click an NSImageCell subclass

  - by Michael Forrest

  I have a table of draggable rows. I'm subclassing NSImageCell to render an image, mapped via bindings. How do I get a double-click event from this cell?

  Read the article

• Replace first Letter in a field Oracle

  - by Stanley

  Hi Guys I have this Table I need to replace the First Letter in ACCT_NAME with the First Name of ACCT_SHORT_NAME. Records like the Higliighted(RAFFMAN) should not be changed. I have tried: select acct_name, ACCT_SHORT_NAME,replace(acct_name, substr(acct_name, 1, 1), ACCT_SHORT_NAME) from tbaadm.gam where schm_type = 'TDA' and rcre_user_id = 'SYSTEM' and substr(acct_name,2,1) = ' ' I am getting: This means that am Picking the whole value in ACCT_SHORT_NAME. WHat is the best way to do what am trying to do?

  Read the article

• Dll resources in resource editor: Where do they come from?

  - by rursw1

  Hi, I have a small C++ dll which was written in Visual Studio (of course). In the solution code, I have a resource file that includes only version information. The strange dact is, that when I frag the compiled dll to Visual Studio, it opens a resource viewer with bitmaps, dialogs and a string table - where do all of them come from?? Is there any way to remove them? Thanks in advance.

  Read the article

< Previous Page | 652 653 654 655 656 657 658 659 660 661 662 663  | Next Page >