Search Results

Search found 26115 results on 1045 pages for 'table alias'.

Page 132/1045 | < Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >

• sql server: create table taking forever!

  - by every_answer_gets_a_point

  i am doing this: CREATE TABLE person ( num INT NOT NULL , firstname VARCHAR(20) NULL , lastname VARCHAR(30) NULL ); sql server is just saying "debbuging" and it's not doing anything is there a problem with the syntax or what?

  Read the article

• ado sql update table with result of group by query

  - by brett

  I am trying to update records in an .mdb table with the number of records containing the same value The sql below does not work but I think gives an indication of what I am trying to achieve. UPDATE table1 AS A INNER JOIN (SELECT PH_BSP , Count(PH_BSP) AS PHCOUNT FROM table1 GROUP BY PH_BSP) AS B ON A.PH_BSP=B.PH_BSP SET A.PH_SORT = B.PHCOUNT; any ideas?

  Read the article

• can oracle inline views be used across java statements instead of creating temporary table

  - by prabhackar

  i have a java program executing 3 separate sqls with a same inline view - it takes about 20 minutes each time to build the inline view when the sqls are executed - is there a way to cache or reuse it ? - trying to avoid temporary table solution because it needs to be delegated to a plsql since the java program does not have rights to create schema objects. ps: oracle 10g

  Read the article

• Animate cell within a table

  - by amok

  That's what I have: - A table with a few rows, one column only What I am trying to accomplish: Double tap on any row should produce an animation of the cell. The animation that I want is a flip vertically of the row. I am displaying some data in each row and what I want to do is displaying the source of the data "on the back" of the row, so to speak. Is it possible? If yes, how?

  Read the article

• Necessary rights to be able to add a column with ALTER TABLE ADD column_name

  - by Sorin Comanescu

  Hi, Could somebody point out the necessary rights to do something like ALTER TABLE myTable ADD myColumn int NOT NULL CONSTRAINT [Constraint_name] DEFAULT ((0)) ? I assumed grant alter on myTable to [user] was enough but I'm getting the error message The UPDATE permission was denied on the object 'myTable', database 'x', schema 'dbo'. Could UPDATE rights be needed because of the DEFAULT constraint? Thanks.

  Read the article

• MS-Access: TableAdapter UpdateCommand for table without primary key

  - by Steven

  What is the syntax for an Update query for a table without a primary key? Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software. Note: The database is Microsoft Access.

  Read the article

• batch update mysql table

  - by Yang

  I have a table with a column called time, "HH:MM:SS". How can I do a batch update so that the value increment by 1 hour? Is it something like: update <table_name> set <time_column> = <time_column> + 3600 where ...

  Read the article

• Displaying a table on the Android platform.

  - by Tarmon

  Any suggestions on the best way to display this table on an Android platform? The formatting is not necessary but I am looking for a flexible way to do this because there are numerous tables with different numbers of rows and columns.

  Read the article

• LaTeX table cells content vertical alignment problem.

  - by Jarek Waliszko

  Hello, I'd like to align text in right cell of table created below, to be vertically align to the top. How to do that ? \begin{tabular}{l|p{3cm}} \rule{2cm}{5cm} & Top align content ? \\ \end{tabular} Regards

  Read the article

• Create table on linked server?

  - by vatsalit

  Is it possible to create table on linked server? If yes then how? I really appreciate your help. Thank You.

  Read the article

• Copy row to another row in same table and vice versa Sql Server

  - by AmRoSH

  I have Table and i want to copy data from row to another and vice versa and i have the rows IDs. is there any query to do that because i don't want make it by .net code i think sql query is easier than that. thanks

  Read the article

• MSSQL - select date field in table

  - by thegunner

  Hi, In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370" How can just get the date value of this field in a select statement. e.g. select id from risks, where creation_date = getdate()

  Read the article

• VB>NET database connectivity with a table having checkboxes

  - by Muhammed Yoosuf

  Can any1 help me hw 2 insert d code to move 2 d next record of the database in a table that has one CHECKBOX? i tried using the regular method of checkbox1=.Item("BookingStatus").ToString bt it gives a runtime error

  Read the article

• How to update table with ON DELETE CASCADE without dropping and recreating

  - by pukipuki

  During development of a PostgreSQL database, I made foreign keys in every table. The problem is that I forgot to select ON DELETE CASCADE option. I need to set that options on all tables. It seems I can only drop and recreate every constraint manually. Does anybody know any shortcuts?

  Read the article

• How do I design this link table?

  - by Soo

  Ok SO, I have a user table and want to define groups of users together. The best solution I have for this is to create three database tables as follows: UserTable user_id user_name UserGroupLink group_id member_id GroupInfo group_id group_name This method keeps the member and group information separate. This is just my way of thinking. Is there a better way to do this? Also, what is a good naming convention for tables that link two other tables?

  Read the article

• Check if table exists

  - by Dmitry

  I have a desktop application with a database embedded in it. When I execute my program I need to check that specific table exists, or create it if not. Given a Connection object named conn for my database, how could I check this?

  Read the article

• Help making Fluent NHibernate create an oracle sequence for each table

  - by Rafael E. Belliard

  I am using Fluent NHibernate's (1.0 RTM) automapping feature to create my oracle database schema. My issue is that all the tables are using a single "hibernate-sequence", whereas I would prefer (and my boss would demand) a sequence generator for each table. Any ideas?

  Read the article

• Copy row to another row in same table and vise versa Sql Server

  - by AmRoSH

  I have Table and i want to copy data from row to another and vise versa and i have the rows IDs. is there any query to do that because i don't want make it by .net code i think sql query is easier than that. thanks

  Read the article

• Adding roles from a DB Table

  - by Sunil Ramu

  Can anyone expalin me how to dynamically ger the Role from a DB table instead of hard coding it in the code. ClaimsIdentity outputIdentity = new ClaimsIdentity(); outputIdentity.Claims.Add(new Claim(System.IdentityModel.Claims.ClaimTypes.Name, principal.Identity.Name)); outputIdentity.Claims.Add(new Claim(ClaimTypes.Role, "Manager")); outputIdentity.Claims.Add(new Claim(ClaimTypes.Country, HttpUtilities.GetProgramIdentifierFromUrl())); return outputIdentity;

  Read the article

• How to get php form data to pdf in table structure using WAMP

  - by Fero

  Hi I am displaying all the users in the form using php where the data are fetched from db. When i click on the icon all users data should be show in a pdf with a good table structure. i am hereby using fpdf to generate it. i created pdf but the records are not in formatted structure. How should this can be done. kindly advice. thanks in advance strong text

  Read the article

• Table transformation / field parsing in PL/SQL

  - by IMHO

  I have de-normalized table, something like CODES ID | VALUE 10 | A,B,C 11 | A,B 12 | A,B,C,D,E,F 13 | R,T,D,W,W,W,W,W,S,S The job is to convert is where each token from VALUE will generate new record. Example: CODES_TRANS ID | VALUE_TRANS 10 | A 10 | B 10 | C 11 | A 11 | B What is the best way to do it in PL/SQL without usage of custom pl/sql packages, ideally with pure SQL? Obvious solution is to implement it via cursors. Any ideas?

  Read the article

• Windows Azure Table Storage Error when in the cloud

  - by Dan Jones

  hey, I downloaded the simple table storage sample on Cloudy in Seattle blog It works perfect when aimed at local storage but when I change to point to azure storage i get the following error Screenshot (on skydrive) http://cid-00341536d0f91b53.skydrive.live.com/self.aspx/.Public/error.png anyone see this before? thanks guys

  Read the article

• Table format for Click stats

  - by Francesc

  Hello. I'm currently developing an URL shortening service. I want to allow users to see the stats for their URLs. How has to be the table. First, it has to be the url ID, but then, how I can sort the clicks per day?

  Read the article

• year as a Column Name in a MySQL Table

  - by Laxmidi

  Hi, I've got an easy question. Is it okay to name a column in a mysql table 'year'? Any reason not to? Thanks, -Laxmidi

  Read the article

• Accessing html table rows in python django

  - by apoorva

  Hi I am very new to both django and python... I have a html table with person information in each row...How do i get a particular row entry/id of the one i need to edit/delete to accordingly update/delete the row in database??

  Read the article

< Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >