Search Results

Search found 25640 results on 1026 pages for 'alter table'.

Page 121/1026 | < Previous Page | 117 118 119 120 121 122 123 124 125 126 127 128  | Next Page >

• Convert the mysql table details to an Excel(.xls) or comma seperated file(csv) using python

  - by nimmyliji

  Hi, I want to convert the mysql database table contents to an Excel(.xls) or comma seperated file(csv) using python script... Is it possible? Any one can help me? Thanks in advance, Nimmy

  Read the article

• Removing a default value from a Sql Server 2005 table

  - by Nikola Stjelja

  Hi, I have a tabel in an Sql Server 2005 database. I have the following column IndPL INT DEFAULT 0 NULL I want to change the column to be of the type NVARCHAR but I receive a constraint violation due to the fact that the column has a default value constraint attached to it. I need to find out how to remove a default value constraint from a table column or how to change the column type without impeding the constraint.

  Read the article

• import csv file and save to sql database table using VB2008

  - by Cookster

  Hi all, Well I have read ALOT of posts and I can't quite find the perfect answer to my question, (or I have and havn't realised it!:-)) I have a large csv file that I want to read into my program and sve it to a SQL database table. I'm useing VB2008 and my dabase is SQL2008. Any help would be appreciated. Cheers Cookster

  Read the article

• nokogiri: wrap <tbody> around <table>'s child

  - by wefwgeweg

  how can i do this ? i need to place tbody after table tags, basically to emulate Firefox's behavior. Thanks.

  Read the article

• is there anyway to add a primary autonumber key to an already existing database table

  - by oo

  i have inherited a database application from someone else and there are a few tables that dont have any primary keys. I want to add a new column into an already existing table and have it autonumber (starting from 1). how would i go about doing this?

  Read the article

• TSQL: finding unique entries in a single table

  - by pcampbell

  Consider a table or CTE structured like this: Name Num ---- ---- Abc 12 Abc 12 XYZ 70 XYZ 80 Bar 50 Bar 55 Foo 44 Foo 44 Baz 88 The requirement is to determine the Name where multiple different Nums exist. The desired resultset is Name ---- XYZ Bar What TSQL statement would you use to derive this resultset?

  Read the article

• LINQ "table" variable

  - by Cat

  I'm trying to turn a method I have right now into a more "generic" method that returns a string. Right now, the method uses a statement like this: var app = (from d in testContext.DAPPs where d.sserID == (Guid)user.ProviderUserKey select d).ToList(); I process the results of "app", add extra text etc. The piece that changes (that I need to make more "generic") is the table name (DAPPs). Is there a way I can do that, or, a better way to go around this all together?

  Read the article

• JDBC Bind table in prepared statement

  - by AEIOU

  Can I bind a table name in a Java Prepared Statement? i.e. PreparedStatement pstmt = aConn.prepareStatement("SELECT column FROM ? "); pstmt.setString(1, "MY_TABLE"); Nope, no I can't. New question, anyone know how to delete a question?

  Read the article

• display:inline-table

  - by sasikumar

  hi, IE 7 not supporting display:inline-table ? Other browsers supports. What should i do for the alternate solution.

  Read the article

• Change the precision of all decimal columns in every table in the database

  - by Jon

  Hi all, I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p? The db is on sql 2005. Any help would be great.

  Read the article

• how to get index value of TextField define in table

  - by mukeshpawar

  I have a table view in that i am showing an text fields now my problem is i want to read the data from those text field i am able to get the value but i even want to know its from which text box i want the index of the text box

  Read the article

• Cocoa: How to make table view draw custom views in each cell

  - by Inso Reiges

  Hello, I am learning Cocoa and trying to create an application for Mac that displays a simple book list. Each book is an NSView with its cover image, title and author. I want to present this list as a NSTableView with a single column and a book view in each cell. However i can't yet figure out how to display a custom view inside a table cell in interface builder or programmatically. Any tips would be very appreciated :) Inso.

  Read the article

• PHP: ORM framework or library that I can use with my database table structure

  - by Thomas

  Hi, I was using KohanaPHP ORM but I can't use it with my database table structure. So, I need a framework or library ORM to use with it. With Kohana I need to follow a naming convention. I can't use a field name (foreign key) like 'idUnidadeMedida'. Are there any suggestions? Thank you.

  Read the article

• Change background color for rows of an HTML table on click

  - by Sarah

  Hi, I need that when i check a checkbox i apply different background color to HTML table rows according to and ID of a user in database using jquery, and then i uncheck the checkbox go to previous state. For the record i am not asking for code i am asking for concept.

  Read the article

• Getting an Variable to Display at the top of an HTML Table Row

  - by John

  Hello, For the HTML table column below, the $count++ displays in the middle of the row. How can I get it to display at the top of the row? Thanks in advance, John Code: echo '<td class="commentnamecount">'.$count++.'.</td>'; CSS: .commentnamecount { width: 20px; overflow:hidden !important; color: #000000; vertical-align: }

  Read the article

• Displaying a single rank in MySQL table

  - by MichaelInno

  I have a table called 'highscores' that looks like this. id udid name score 1 1111 Mike 200 2 3333 Joe 300 3 4444 Billy 50 4 0000 Loser 10 5 DDDD Face 400 Given a specific udid, I want to return the rank of that row by their score value. i.e. if udid given = 0000, I should return 5. Any idea how to write this query for a MySQL database?

  Read the article

• How to increase mysql table comments length?

  - by opensas

  Seems like max table comments length in mysql is only 60 characters. I'm developing an aplicacion in php symfony, which automatically generates sql ddl sentences, and in many cases those comments are far beyond 60 characters. Is there some way to increase that limit? thanks a lot

  Read the article

• show data from database in table format inside form

  - by klox

  i have an input form which connected to database... after that i want to make a form to show all data which have been input to database..and this data will show in table and also i can sort the data by name or by date... please help me...

  Read the article

• struts2 table tag

  - by Raam

  Hello, how to use the tag in struts2 ?...how can i create table with some rows/colums.how can i put values at runtime?.. thanks..

  Read the article

• Copying a field to another table in Access

  - by Jacques Tardie

  I'm a bit embarassed asking this here, but here goes: I've got two tables, which you can see here: http://img411.imageshack.us/img411/4562/query.jpg I need to copy the effortid from the one table into the other, making sure that the values still maintain the correction relationships. The primary key for each is a combination of loggerid & datetime. What's the best way to do this? Thanks in advance, and don't make fun :)

  Read the article

• generate script of content of one table as a .sql file(via code)

  - by Meysam Javadi

  is this possible that i create a stored procedure that generates content of defined table to a path that i passed as its(stored procedure) parameter?

  Read the article

• Export a data table in CSV format sql server 2008

  - by manivineet

  I need to create a stored procedure which queries a table and creates a CSV file for that data in a specified directory location. how do i do it?

  Read the article

• How can i store several iphone contacts in sqlite3 table

  - by ramyauk

  Hi to All, I developed an iPhone app which displays iPhone AddressBook contacts list. I want to add extra fields to the selected contact. Using AddressBook framework,it was not possible.So,i want to attach those values to the "contacts" table of my database. How can i store(insert) those existing contacts into contacts(using sqlite3 insert command). Please,help me with a sample code. Thanks in Advance, Ramya.

  Read the article

• Table names, and loop to describe

  - by Greg

  Working in Oracle 10g. Easy way to list all tables names (select table_name from dba_tables where owner = 'me') But now that I have the table names, is there an easy way to loop through them and do a 'describe' on each one in sequence?

  Read the article

• What is call out table in unix?

  - by Supereme

  Hi, Can anybody tell me the 'call out table' in unix? The explanation is given in 'Maurice J. Bach' book but I'm getting difficulty in understanding the example especially, the one explaining the reason of negative time out fields. For what purpose the software interrupts are used there? Thanks!

  Read the article

< Previous Page | 117 118 119 120 121 122 123 124 125 126 127 128  | Next Page >