How do I show fields in a table in oracle?
In mysql I can write show fields from <table>; What is the closest equivalent in Oracle SQL? ...
sql
How to integrate SQL Server 2005 Express Edition to Visual Web Developer 2008 Express Edition
Hi. I use Visual Web Developer Express Edition 2008 and SQL Server 2008 Express edition. I have finished a project recently. But many of hosting firms don't have SQL Server 2008. So i decided to uninstall SQL Server 2008 and install SQL Server 2005. Then I would reproduce my database. I uninstalled SQL Server 2008, installed SQL Server 2...
MySql bulk load command line tool
Does MySql have a bulk load command line tool like bcp for SQLServer and sqlldr for Oracle? I know there's a SQL command LOAD INFILE or similar but I sometimes need to bulk load a file that is on a different box to the MySQL database. ...
How is input to the MySQL function md5 handled?
I'm having problems understanding how input to the md5 function in MySQL 4.1.22 is handled. Basically I'm not able to recreate the md5sum of a specific value combination for comparison. I guess it has something to do with the format of the input data. I have set up a table with two columns of type double(direction and elevation) + a thi...
When to Create, When to Modify a Table?
I wanted to know, what should i consider while deciding if i should create a new table or modify an existing table for a sql db. i use both mysql and sqlite. -Edit- I always thought if i can put a column into a table where it makes sense and can be used by every row then i would always modify it. However at work if its a different 'rele...
Error calling remote scalar-valued function
I am making a call from a sql 2005 database to a sql 2000 scalar-valued function and recieve the following error message: Remote table-valued function calls are not allowed. here is my call: select * from [server/instance].[db name].dbo.[function name](param1, param2) not sure why it says table-valued function, but that's the error...
How to change Column Properties In SQL?
I have many tables; each has a primary key which is an Identity column with a seed of 1. I have another program which converts data from a previous database (dBase) to sql. This programs needs Indentity = No. How can I change Identity and Identity Seed from my code? ...
Connect an SQL database to a DataGridView with separate command buttons?
Hi, I'm a bit puzzled here. I did a form containing a simple datagridview containing data from an MDB file. The connection was alltogether done by Visual Studios wizard so alot of stuff was created automatically. Then I databinded the textboxes to each column in the database and managed to update the database via my own command buttons s...
[Oracle] Tablespace after Create Table. What does it mean?
Hi, Im reading some Oracle scripts, and I found one with this Create Table XXY(...) Tablespace SOME_TABLESPACE .... NOCOMPRESS NOPARALLEL .. What does this mean? What is if for? There are many CreateTable statemsnts, but the Tablespace statement after is exactly the same. As I understand SOME_TABLESPACE must exist when this script i...
MySQL - REGEXP in a WHERE statement?
I have a table with a field called 'user_car'. It consists of a cat'd underscore separated value (user's id _ car's id) user_car rating ----------------------------- 11_56748 4 13_23939 2 1_56748 1 2001_56748 5 163_23939 1 I need to get the average rating for any "car". In my ex...
LIMIT 3 not returning the first three rows in sorted RS (I think)
In my table I have looked manually and found that the top three idle units have been idle for 17, 13 and 13 days. When I use this SQL statement to try and pull the three rows with the highest idle column value, I don't get these numbers, I get 8, 7 and 7. Is there some other command I should use to grab the first 3 rows of a sorted res...
MySQL using calculated return values to calculate other values
This may be difficult to explain, so bare with me. Let's say I have a select Statement with the following: SUM(st.tafPoints/200) as totalFriendReferrals, SUM(CASE WHEN st.gender = "m" THEN st.tafPoints/200 ELSE 0 END) as maleFriendReferrals, SUM(CASE WHEN st.gender = "f" THEN st.tafPoints/200 ELSE 0 END) as femaleFriendReferrals I ne...
What are Sql Browser with foreign key / references support?
I now want to create foreign keys for all of my mew DBs. So far i have been using sqlite and MyIasm DBs so i havent used a DB that supported it. I am thinking i should install and use a MySql server with InnoDb (connected via C#). My question is what can i use to actually see the FKs relations? I would like to see it by using a sqlite d...
T-SQL Parameters
I have the following table in SQL Server 2000: TABLE_NAME | COLUMN_NAME | TYPE_NAME | PRECISION | LENGTH | SCALE | test TestID int 10 4 0 test TestDecimal decimal 18 ...
PHP query multiple Tables
I'm having trouble getting any information to display from this query. Anyone know where I'm going wrong? Thank you! $query = "SELECT * ". "FROM comments, users ". "WHERE comments.user_id = users.user_id ". "ORDER BY comments.date DESC ". "LIMIT 10"; $result = mysql_query($query) or die(mysql_error()); while ($row...
Select latest records by datetime field
How could i select the latest records by datetime of an SQL Server? Here is the pseudo-code... SELECT Records FROM MyTable WHERE current time >= (CurrentTime - 2 minutes) Supposing the current Time is 10:25:39 pm 26/10/2009 10:25:39 pm 26/10/2009 10:25:00 pm 26/10/2009 10:24:53 pm 26/10/2009 10:24:19 pm 26/10/2009 10:23:58 pm 2...
How to get the values of oracle database parameters from a unix development server?
How to get the fallowing details from the unix development server? The below parameter values should be provided in the .dbc file and it should be mapped to the ETL Server . dbms:<br> db_version:<br> db_home: <br> db_name: <br> db_nodes: <br> case: <br> generate_dml_with_nulls:<br> field_type_preference:<br> treat_blanks_as_null:<br> ...
Getting deadlocks in sqlserver
I am getting deadlocks occasionally in sql server. I created a function for locking non database operations (credit card processing) so duplicates cannot happen. My functions are as follows (sorry for the tcl, but the sql is clear enough). Can anyone see why a deadlock happens occasionally????? proc ims_syn_lock_object { db object {time...
Sanitize search string for Dynamic SQL Queries
I know i can use stored procedures to eliminate sql injection attacks but it would bloat the code by more than I'm willing to accept and making it costly to maintain. In my dynamic sql query, I would like to search a string of text in 2 columns in one of my tables but before that happens, I would like my business layer, which is written...
Can't create MySQL trigger with TRIGGER privilege on 5.1.32
My fellow developers and I have our own development schemas on a shared MySQL development database. My assignment requires me to create triggers in my schema, yet I've been unsuccessful so far. CREATE TRIGGER myTrigger AFTER DELETE on myTable FOR EACH ROW BEGIN -- DO STUFF END; MySQL says: ERROR 1419 (HY000): You do not have the ...