tablename

SQL 2000 Table Name as variable in stored procedure.

Table Name : RM_master Fields : cust_no acct_no acct_code Question is, I want to make the table RM_master as a variable in the parameters in the stored procedure? This has no syntax error but when I execute this in the query analyzer by right clicking on the stored procedure name the variable table name (RM_master) ...

How to show the tablenames with foreign key = myId

I am trying to figure out where my primary keys of a table with translation per language resides as a foreign key. This is what i already have ... SELECT * FROM ( SELECT TM.seqtrans, T.trans, CASE T.seqlang WHEN 1 THEN 'NL' WHEN 2 THEN 'FR' ...

Using mysqlimport where the filename is different from the table name

Hi all, I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as the table name. Is there any way to work round this? I can't rename the file as it is used by other processes and I don't want to copy the file as there will be many of them, some being very large. I want to use mysql...

Sql - tablename as variable

Hi folks, i am trying to execute this query: declare @tablename varchar(50) set @tablename = 'test' select * from @tablename This produces the following error: Msg 1087, Level 16, State 1, Line 5 Must declare the table variable "@tablename". What's the right way to have table name populated dynamically? TIA ...

mongoid, set_table_name & attr_accessible

Hi! I'm using rails3 edge and mongoid 2beta6 with ruby 1.9.2-head. How can I manually change the table name, just like set_table_name for ActiveRecord? For example my model Signup should use the table "users" for storage, not "signups". Another question is how to implement the bevahior of attr_accessible AR provides? Thanks, Corin ...

SQL/JDBC : select query on variable tablenames

Hi all, I'm using Oracle DB and I would like to write a SQL query that I could then call with JDBC. I'm not very familiar with SQL so if someone can help me, that could be great ! Here is the problem. I have a table MY_TABLE wich contains a list of another tables, and I would like to keep only the nonempty tables and those that their na...

VB .NET : DataGridView.DataMember throws error when assigned a two-part name. i.e. Sales.StoreContact

My problem is oulined here: http://support.microsoft.com/kb/314043 Microsoft says: "This behavior is by design." No workaround is provided. I need a workaround. So I have a dataset which is populated correctly with the contents of the table name Sales.StoreContact. When I try DataGridView1.DataMember="Sales.SalesContact" the IDE th...