How can i update bulk data in sql server 2005 by sending the data in XML form ?
i am able to insert bulk data into the table, but i am not getting idea to update the data.
I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great.
int numberOfChecks = -1;
numberOfChecks = numberOfChecks +1;
if ([objectsForTable count]-1 >= numberOfChecks) {
UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks];
NSString *cellTitle = cell.textLabel.text;
}
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?
I'm trying to build a sort of resource allocation form. I'd like to be able to print a table from a database, and then allow users to click on each cell that they would like to reserve. Also, being able to drag and select multiple cells. Then send all of this via $_POST to another php script.
Problem is, I have no idea where to start.
Any suggestions?
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...
I have an Entity Framework model using Table per Type Inheritance, but when I use a VS Data Generation Plan it produces duplicate keys in the child tables, which is a problem for EF. Does anyone know of a way to get this to work, so that the child tables do not have overlapping keys?
Hey,
Am new to LINQ, and am trying to retrieve the top 50 rows of a particular table.
In SQL Server using an actual query i coudl say "Select TOP 50 from Transactions" , but not sure how i need to do that with LinQ
Any pointers that could help ?
Thanks !
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?
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
I've a <table> which has 10 column and 10 row i want to give different background to 1st and and 3rd column and another different background color to 8th row . is it possible without css class/id
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?
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
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.
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.
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?
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?
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 ...
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()
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
Hello, I'd like to align text in right cell oftable 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
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.
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
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?
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