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...
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 =...
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
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...
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 need the syntax in SQL to find the last row in a database on SQL server 2000
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...
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...
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
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 ...
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...
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 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
hi experts, i have a very big database in .DAT and some like .BAK extension , any idea how to view the database, meanwhile my programmer not very keen to tell us which application to used to o...
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...
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...
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 ...
When trying to install MSDE I am told that a strong SA password is required and the installation quits... can any one tell me what is the SA password, where do I find it and how do I change it...
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 ...
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...
Hi,
I am using SQL server, and have one table populated, cannot be drop and add it again. How can I change one column (or field) name using SQL statement?
Thanks.
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
Hi,
Can anyone tell me why I am getting the following error message and how to solve it for the SQL code below:
Cannot resolve collation conflict for equal to operation.
As you can ...