Recent IT Questions

1 - 9 of 9
<<PREVIOUS 1 NEXT>>

Mysql syntax

Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...

View Answer   |  Nov 4 2009  9:59 PM GMT
MySQL, tables, Data Tables
asked by Ak1bo78

  30 pts.

Constraints (MySql,tables,null,PK,FK etc)

Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

Answer Question   |  Nov 4 2009  7:52 PM GMT
MySQL, tables, constraints
asked by Ak1bo78

  30 pts.

Random values selection

how i can select random values from a coloumn from a given table

View Answer   |  Nov 22 2008  5:12 AM GMT
Database programming, tables
asked by Kamboj

  5 pts.

Problems from reindexing tables every day on a SQL Server

We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

View Answer   |  Oct 27 2008  5:58 PM GMT
SQL Server, Indexing (information management), tables
asked by SQL Server Ask the Experts

  2430 pts.

Get all table names by SQL

Hi, how can I get all table names of a bib by a sql-query? Thanks a lot

View Answer   |  Oct 21 2008  7:34 AM GMT
SQL, tables, SQL Query
asked by Oli001

  5 pts.

Problems with the SQL query function

I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table...

View Answer   |  Aug 21 2008  4:16 PM GMT
SQL, Query, tables
asked by SQL Server Ask the Experts

  2430 pts.

Problem inserting data using OPENROWSET in SQL Server 2000

When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

View Answer   |  Jul 9 2008  5:56 PM GMT
SQL Server 2000, Functions, tables
asked by SQL Server Ask the Experts

  2430 pts.

Designing Table Layout

Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

Answer Question   |  Jul 8 2008  8:57 AM GMT
Microsoft Excel, Database design, tables
asked by CMS

  5 pts.

Error when trying to drop a table that doesn't exist in RUNSQLSTM

If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?

View Answer   |  Jul 2 2008  10:03 AM GMT
RUNSQLSTM, DROP, tables
asked by Gingertosser

  10 pts.

1 - 9 of 9
<<PREVIOUS 1 NEXT>>