I rencently used the SQL Server Migration Assistant to import a database into SQL Server 2005. I noticed that a number of tables that were imported have been ammended with a new column called SSMA_timestamp. Can anyone tell me what this is for and how it would be used? ...
What are some different ways to loop through a mysql result set? I'm new to PHP and MySQL so I'm looking for simple ways to loop through and an explanation as to how the provided code works. ...
How can i generate a unique key of length at most 12 character with these attributes: Name, Father's name, Mother's name, Date of birth, Place of birth. Thanks in advance :) ...
If you have the tables Groups, Users, Channels and between each two a linktable, how do you organize that in Domain Driven Design and nHibernate? Does a Group have a UserCollection and a ChannelCollection, a User a GroupCollection and ChannelCollection and a Channel a GroupCollection and UserCollection? And if you want to add a Group to...
Hi all, I have a view which contains a users id and an image column. Here's what i've tried doing to retrieve the image but i keep getting a box with an red x instead of the actual image. View <td><img src="<%= Url.Action( "DisplayImage" , "User" , new { id = item.id} ) %>" alt="" /></td> Controller public FileContentResult Disp...
In the following code, if one of the values assigned violates a database constraint, the Save() updates the record with the other good values. However, the database constraint does not appear to bubble up and and be caught by SubSonic. Does SubSonic provide a way to catch constraint violations like this? try { OutboundShipmentControlle...
hi, i am filling up a big table with text items from different countries. My question is: Should i use a referencePropery to link to languages in another table?. Thats the way i would do it in a normal mysql relational database. or just go redundant and specify the language for each text in the table? Whats better? redundancy & incre...
We have a sql query as follows select * from Table where date < '20091010' However when we look at the query plan, we see The type of query is SELECT. FROM TABLE Worktable1. Nested iteration. Table Scan. Forward scan. Positioning at start of table. Using I/O Size 32 Kbytes for data pages. With MR...
I have a MySQL database that has a few very simple tables. I would like to find an app (implemented in Perl, Python or PHP) that will do the following: Point the app to a database table, and it automatically retrieves the table's schema from the database. It then generates an HTML view of the table's data. The data is displayed as a ...
Firstly, I have found many examples of how to grab data from a db and place it into a list, however this seems to be all for ListActivites. My list is part of the UI and therefore I can't use a ListActivity because it does not consume the whole screen (or can I?). This is the UI: <SlidingDrawer android:layout_width="wrap_content" an...
I have a index on a column and it is correctly used when the query is select * from Table where x = 'somestring' However it seems to be not used when the query is something like select * from Table where x != 'someotherstring' Is this normal or am I missing something else in the query? The actual query is of course much larger and...
I've created a database an a table ("Mail") having 2 columns: id INTEGER, content INTEGER. In my aplication I have tested the connection and it works well. using Finisar.SQLite; ... string db = "mydatabase"; SQLiteConnectionsql_con = new SQLiteConnection("Data Source=" + db + ";Version=3;New=False;Compress=True;"); sql_con.Open(); sql...
I am writing an class using C++ (ATL).. I need to connect to a database. I am familiar with ADO but I see that all the functions are using IDispatch (late-binding/Automation). I am considering using OLEDB instead. What are the pros and cons of each? OLEDB seems like a lot of maintenance if the sql changes (tables, stored procs, etc). I d...
Is there a way in MySQL to COUNT(*) from a table where if the number is greater than x, it will stop counting there? Basically, I only want to know if the number of records returned from a query is more or less than a particular number. If it's more than that number, I don't really care how many rows there are, if it's less, tell me the ...
I was wondering the trade-offs for using databases and what the other options were? Also, what problems are not well suited for databases? I'm concerned with Relational Databases. ...
Hi, We have an application that is written in C# that is connected to a ms sql server. We use to make a stored procedure for every database call, but then we've noticed that using stored procedures gives us a very big disadvantage, we don't know what stored procedures we need to update if we change our database. Now I was wondering if ...
I am using SQL Server 2005 Express and Visual Studio 2008. I have a database which has a table with 400 Columns. Things were (just about manageable) until I had to perform bi-directional sync between several databases. I am wondering what arguments are for and against using 400 column database or 40 table database are? The table in...
I have two tables create table tblchildinfo (id int, name varchar(50), pickuppointid int, dropdownpointid int) and create table tblpoint(pointid int, PointName varchar(50)) So I have primary table tblpoint and child table as tblchildinfo and i want to write a statement such that i will get child id, child name, pickuppointID...
I'm not sure if this type of question has been answered before. In my database I have a product table and specifications table. Each product can have multiple specifications. Here I need to store the revisions of each product in database in order to query them later on for history purposes. So I need an efficient way to store the produ...
All, After several months of not touching our databases I fired up Rapid SQL and get this error when I try and connect to a registered Sybase DB: "Layer (5) Origin (3), Severity (5), Number (3) ct_connect(): network_packet_layer: internal net library error: Unable to find an available protocol driver structure" Any ideas? I'm running...