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...
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 ...
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...
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. ...
Dear all
I want to insert a french format date "dd/MM/yy" into a MS SQL table, But the fields default format is American "MM/dd/yy"
How I can change this default format.
Regards
George Er...
Sir, I have an excel file with the following two columns:
File_job & ICNumber
I have an table in my SQL Server name cargodetail where i have the same column:
file_job & ICNumber
...
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
I want to know the exact difference between DBMS and RDBMS.
what is the advantage of having relationships in a Database Management System
Hi,
I am new to TOAD Oracle. I wrote a simple sp and don't know exactly how to execute, although I have tried right click on my sp name in Object window, and set up an input value.
Basic...
Hi,
I have a question about
'How to use Oracle's 'Execute Immediate' with keywords 'Using' & 'Into' together.'
======================================================
I have no proble...
Hello, I'm a total SQL beginner, learning fast but needing some help with a report I'm creating.
The report is for a job ledger and the SQL table includes JobNo, Date, CostCode, TotalCost a...
Hi, I need to format this number
0.23999999999999999
To this
0.240
Any ideas ?
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', '')
...
While trying to install MSDE, I received an error 'A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setu...
I have a table with a notes field of varchar(255). I have created a view of the table to convert the varchar to a char field for fixed lenght bcp out. The problem lies in that the notes fiel...
Ok... Should be fairly simple... I just dont know how to do it...
Say I have a varchar(50) column with a record with "Yeah Baby! Yeah!!"
I want to do a select against a value that has no p...
To load data into my oracle db, I use a bat file named load.bat including:
C:\oracle\ora90\BIN\sqlldr xxx/xxx@xxx,control=anotherfile.ctl,log=c:\logfile.log
...
in which xxx are username,p...
Hello,
I have 2 tables, obviously joined on a key.
I want to insert data into 1 table, and then insert multiple values into the second table using the autonumber that was assigned to the...
Sorry about the Question title, didn't know exactly how to call it...
I have a table called consults:
Name, Last Name, email
And a table called Users:
Name, Last Name, email
I n...
I have a DBase IV table and am attempting to run a like query on it similar to below
ex.
Select * From Tablename Where Title like example%
the like statement doesn't make good use of th...
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...
Hi,
Please kindly assist how can we have a nested case statement.
i.e.
select case when Col > 1 then 'Greater' else case Col =2 then 'Equal' else 'Less' end
Thanks.
Hi,
I used this statement to update one column the 1st table from column value in a 2nd table:
update testb1
set col2=(select col2 from testb2 where testb2.col1=testb1.col1)
But thi...
How you people compare all the technologies
ODBC Vs OLEDB Vs ADO Vs ADO.NET
Regards,
Imran
Experts,
Currenlty all DB in my company is on SQL Server 2000 and we plan to build another DB server with SQL Server 2005 to take the place.
I am wondering what is the best way to perfo...
