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 ...
