2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested Databases Solutions: 1 - 25 of 2834
 
have some theory, i think it should work, i havnt figure it out yet.  I couldnt get my sql running. I just need a SQL statement that SELECT TOP 10 records FROM table WHERE records NOT ...
Quick syntax question I have a TSQL statement that needs to update a field on both tables. The statement is : UPDATE CUSTOMER INNER JOIN PROSPECTIVE_CUSTOMER ON CUSTOMER.CUST_ID =...
Is there a command that can be used to temporarily convert a string value in a field to integer? I.E. SELECT name, employeeid FROM users WHERE employeeid = bob In this case employe...
HI, I want to export a list of the column/field names of my SQL (server 2000) tables into an Excel sheet - any ideas on how to do this? thanks Fergal
what is normalization .explain ti with an example also explain 1nf,2nf,3nf,4nf and bcnf and aplly it onto a sample table as an example
Very simple proc, but can't execute it!!!  Getting the dreaded ORA-06512 error: PL/SQL: numeric or value error: character string buffer too small PROC: CREATE OR REPLACE PROCEDURE jjb...
I need the syntax in SQL to find the last row in a database on SQL server 2000
We are really getting crazy for this: Suddenly when trying to connect to Management Studio with trusted connection, our db server is returning this error : Login failed for user ''. The ...
I have a .db file and I am not sure how to open it. I want to save it as either .txt , .csv, .xls or .mdb Maybe its a Sybase database but I don't have Sybase. Any ideas?
I am trying to log in as an Windows XP current user account who is the member of ORA_DBA group using the following command, but it gives me an error. However I can access the sqlpus using us...
Hi, I need to format this number 0.23999999999999999 To this 0.240 Any ideas ?
Hi folks, I need differences between stored-procedure and functions with an example. What are the differences between stored-procedure and triggers? what is a view? Thanks, Pampa
Sorry if this is confusing:  I will try to be as specific as possible. I am passing in @Detail- it can be blank, null, or have text If @Detail is not null or blank, I need to check if Ap...
Hi experts, I need an SQL query (in MS SQL) to select last X records, for example my table has 1000 records, I want to select last 10 records. I know by using TOP I can do that, but it retur...
Hi I want to remove multiple characters (that are not necessary sequential) in a string. To remove the character 'a' from a string I use the following: REPLACE(mystring, 'a', '') ...
Hi, I am trying to run a select statement that will select data from a table for a specified date range, here is the statement: SELECT count(*) from csmadmin.incident WHERE owner_id LIKE ...
I have a classic asp web page that works perfectly with SQL 2000. It does not, however, work with SQL 2005. What do I need to do on the server to get this to work? I've already enabled TCP/IP ...
hi all in some cases when to_date(colname,'dd-MON-YYYY') is given  in the select stmt, the formated date looks like 12-DEC-0004 Thanks in Advance Raj  
Hallo, I would like to select data from a database using 'Select * " based on a value in a row (same column)being unique. By that I mean that that data must not repeat again. Idealy I woul...
Dear Sir, When ever we create database from sql server, it's create two file. (1) .mdf (2) .ldf. I want to see what's available inside the .ldf file. Through program (visula basic or any ...
Can someone please tell me how do I create an outer join between two tables in sql server query. This query gives me an error SELECT     DupTable.API, DupTable.[Lease Name], DupTable.[F...
I need to query the contents of a long column and haven't had any success.   I'm pretty sure I can't accomplish this with SQL+ or TOAD so I'm trying to find out if there is a way to pipe th...
While looping through a cursor I need to loop through each column without knowing the column name.  For instance This works: LOOP  FETCH MVAR_cursor into MVAR_record;  EXIT WHEN MVAR_cur...
I would like to convert the format of a DateTime field in sql. Currently the field (rec_dt) holds a value such as this "4/6/2006 1:08:48 PM" I would like this to be shown in the query as 04/06...
Is there a way to insert multiple records in a database in a single SQL statement?  I'm running the Insert statements separately to input in the track table.  My SQL is below. create table ...