|
Which free/open source or commercial IDE has best WYSIWYG accessible table maker?
to make and manage large and highly accessible financial Data tables with lots of data.
currently i'm using dreamweaver CS3, does any other tool have better table maker
...
Started by jitendra on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Ust use....
IF your current IDE doesnt have one i wouldnt switch or purchase yet another tool .
Perhaps something like Aptana Studio is what you want? It's free to boot!
You may also want to check out Alternativeto.net for all your program suggestion needs .
|
|
I have a table in a SQL Server 2005 Database that is used a lot. It has our product on hand availability information. We get updates every hour from our warehouse and for the past few years we've been running a routine that truncates the table and updates...
Started by Ryan Montgomery on
, 11 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
I'd look at not truncating the table and refilling replace the table you could control....
I think this is going about it the wrong way - updating a table has to lock it, although you can limit that locking to per page or even per row.
|
|
I have an Table USER (USER_ID, PASSWORD, NAME, ...) and an Table ACCESS_ROLES for the Users, every user can have one ACCESS_ROLE (ONE-TO-ONE).
Wich table has the Foreign Key?
I would put the USER_ID into ACCESS_ROLES table. Is there any best practice ...
Started by ArneRie on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Since you will be having a one called access_role_id and then do the foreign key on the... .
If you have a One-To-One mapping, I would put the foreign key into the table that you USERS table and add a foreign key constraint into ACCESS_ROLES.
|
Ask your Facebook Friends
|
I store various user details in my MySQL database. Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manipulate the data as required. Setting up a new system, it...
Started by Peter on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It may (or may not) help to make some queries (which of using only JOIN method....
If you have one table with goodCombining the tables is called denormalizing.
On normalization is best suited for your needs depends on your demands.
|
|
I have one table that saves comments for a varied set of content types. These are saved in other tables (news, articles, users). I wonder what's the best way to connect these tables? In previous projects I used a second table for each kind of content....
Started by okoman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I'd set up foreign key relationships....
I would probably have a separate comments table for each content table so that I could take field would refer back to the content table and user_id field would refer back to the users table.
|
|
Could someone chime in as to whats a better practice? for select queries should I return all or the IDs that I require?
Efficiency? Scalability? etc.
thanks
Env: SQL Server 2008, VS2008 (VB)
Started by Jay_GISDev on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Stay away!
A good example of why it's bad: "select * from... .
To do select * when you have a view that is supposed to mirror the layout of a table, but strange things can happen if you modify the underlying table without regenerating the view.
|
|
I have an SSIS project where one of the steps involves populating a SQL Server table from an Oracle Table.
The Oracle table has a column ssis_control_flag . I want to pull across all records that have this field set to 'T'.
Now, I was wondering which ...
Started by James Wiseman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Of directly accessing the Oracle table..
|
|
I have a table with an identity field. What the best SQL query to get the Ids of all the deleted records from this table?
Started by fung on
, 7 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
A completely AND c.intId < b.intId....
which does require a refactoring of your example, would be to not delete from the table, but to have ) OPTION (MAXRECURSION 0)
Though this won't be very efficient if the table is very large.
|
|
Hi,
is there any easy way to determine how much space each table in an Access 2007 database is using?
I have an unusually big Access database and need to find out which table uses the most space. The row counts do not give enough information about the...
Answer Snippets (Read the full thread at stackoverflow):
For functioning Access databases you can get the simple tool Access Memory Reporter 1.0 which shows is your objective once you discover the largest table? How large is your MDB? Have you compacted of tables/records in it? If so see....
|
|
I am using ASP.NET and the Entity Framework to make a website. I currently have a map table for a many to many relationship between... let's say users and soccer teams. So:
Users
Teams
UserTeams
Part 1 : Is it best practice to use a composite key for ...
Started by SkippyFire on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Some ORM.
Know the key for a given table (table name + ID), without having to reference the schema.
|
