Hi,
I have a database with only one table as below:
userurltag(id,userID(string),Url(String),tag(String))
I want to delete users that have less than 3 urls associated with them.
How can I do that?
MS SQL Server has a TABLE data type which can be used in stored procedures,
Does anybody know if MySQL has an equivalent data type?
I've had a look over the docs but can't seem to find anything, so I presume it doesn't exist, but perhaps somebody has created a workaround
hey all,
i have a table which contains a bunch of dynamically created radio button lists, im trying to write code which will loop through each one of the radio button list and get the text value of the selected item. i have the following code
foreach ( Control ctrl in Table1.Controls)
{
if (ctrl is RadioButtonList)
{
//get the text value of the selected radio button
}
}
but i am stuck on how i can get the value of the selected item for that given control.
Which of the following three options would you choose for a column name in a SQL Server table, and why?
YearToDateWages
YTDWages
YtdWages
Follow up:
SSN
Ssn
SocialSecurityNumber
I want to confirm if the statement below is indeed true:
There is no way to specify a storage engine for a certain database, only for single tables, You can, however, specify a storage engine to be used during one session with:
SET storage_engine=InnoDB;
so you don't have to specify it for each table.
How do i confirm, if indeed all the tables are using InnoDB
All the tables were using myISAM.
[Participant Table [1994]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "I:\My Documents\Flamm Consulting\Migrations.accdb" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Frankly, I'm confused about how SSIS should connect to Access 2007 - the UI just isn't very friendly - there's no file browser, for example. I'm wondering if there's something wrong with my install - missing drivers, etc.
Hellow all, I am using navigation controller and have table views inside views.
when i select any cell it it will navigate to another view. so,from there if i click back button it come sto previous view.But,it showing the cell which is selected previously. I dnt want this .it should not show which cell we selected previously.
Could any one help me how to get this.
Thanks.
hi,
I need to extract data from my SQL Server database into multiple text files.
I have a table with 4 columns: UserID, UserName, Tag, Score.
I need to create a text file for each Tag (so basically I need to group by Tag and order by score).
Before to start I would like to know what's the fastest way to create several text files:
File titles = TAG field
each line = userID
I have this code [tableView deselectRowAtIndexPath:indexPath animated:YES];
Why doesn't the table view deselect the row, What am i doing wrong.
EDIT:
-(void)tableView:(UITableView *)tableView didDeselectRowAtIndexPath:(NSIndexPath *)indexPath{
[tableView deselectRowAtIndexPath:indexPath animated:YES];
}
A table row with two columns. One contain a image and another column contain a very large text. The text should start to the right of the image and if goes beyond the image size then the next line should come below the image.
IMAGE. Text starts here and then
follows like this
The iPhone Mail application has an edit button in the navigation bar. Tapping that button shows a delete button in the toolbar and shows checkbox controls in the table cells. Tapping one or more checkboxes then tapping the delete button causes the checked messages to be deleted.
How can I add similar functionality to my own code?
Here's a screenshot of the effect I'm looking for:
What is an index in table? Related with realworld entitly like librabry.
what are the types of indexes? please related this too also with real world entity.
I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes.
My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique:
SELECT OBJECT_NAME(OBJECT_ID) as tableName,
last_user_update as lastUpdate
FROM mydb.sys.dm_db_index_usage_stats
This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?
I'm trying to pass a table name into my mysql stored procedure to use this sproc to select off of different tables but it's not working...
this is what I"m trying:
CREATE PROCEDURE `usp_SelectFromTables`(
IN TableName varchar(100)
)
BEGIN
SELECT * FROM @TableName;
END
I've also tried it w/o the @ sign and that just tells me that TableName doesn't exist...which I know :)
I have about 40000 records in that table that contains plain text and within the plain text, contains that kind of tags which its only characteristic is that they are braced between [ ]
[caption id="attachment_2948" align="alignnone" width="480" caption="the caption goes here"]
How could I remove those? (replace by nothing)
I could also run a PHP program if necessary to do the cleanup.
I have read and implemented this http://stackoverflow.com/questions/818287/changing-jtable-cell-color
What I'd like to know is how to actually use this code? I just want to change a table cell's colour when I click on it.
I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way?
SQL Server 2005
I'm struggling getting my head around the Django's ORM. What I want to do is get a list of distinct values within a field on my table .... the equivalent of one of the following:
SELECT DISTINCT myfieldname FROM mytable
(or alternatively)
SELECT myfieldname FROM mytable GROUP BY myfieldname
I'd at least like to do it the Django way before resorting to raw sql.
I have table and I want to swap the values from two rows. I have the rows IDs of the two rows.
Is there any query to do that? Here is an example. Before the query I have this:
row1 : 1,2,3
row2 : 5,6,7
After the swap I want this:
row1 : 5,6,7
row2 : 1,2,3
I don't want write it in .NET code because I think an SQL query is easier than that.
how to set anything in database then he not allow duplicate rows in a table
means
name abc
name abc
means some row sames as each other then i need to take one copy of it and remove each other
i have a problem which is that i want to extract information about FAT(file allocation table) in C# but the restriction is i cannot use System.IO
so How i get drive types?cluster information e.t.c
Trying to get something similar for Firefox extension using XUL. The most difficult part is the grid with unequal number of rows.
I tried <grid> but it didn't work well. Also don't want to use HTML inside of XUL. Any ideas how to build such table?