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 ...
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
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 =...
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 ...
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
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...
I need the syntax in SQL to find the last row in a database on SQL server 2000
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,
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 ...
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...
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...
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...
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 ...
hello
i am working on an MS SQL db remotely via enterprise manager. (a web site running MS SQL)
But the enterprise manager is very unreliable, alwasy breaking connections.
We would like...
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 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 have an SQL database from our old MSSQL server that is in the format of two files, foo_Data.MDF, and foo_Log.LDF. How can I convert this, WITHOUT RUNNING MSSQL, to another format, su...
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,
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 the maximum size of VARCHAR2(),
Is it 3000?
If yes,
If I create table with VARCHAR2(3000) is it wasting the memory or it will cover only what space I used?
For example,
...
As system analysis I am reviewing some stored procedures. In one case I asked the developer to create a selectmatching stored procedure that would get as parameters all fields on the table. ...
