there are 38 of thses files on my c drive alone. can they be safely deleted, esp teh one in the temp folders?
I am getting this.
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'VHR_DATASQL'. No entry found with that name. Make sure that the name is ent...
I am using a specialized version of SQLPlus to generate a query and then pasting this query into another application to get the data. For these reasons the SQL functions are very limited AND ...
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
...
Hi there
I was wondering if someone could kindly give me some ideas and even a possible title for a Masters Thesis I have to complete.
I have a genuine interest in databases especially s...
What is the meaning of:
"COLLATE SQL_Latin1_General_CP1_CI_AS NULL"
I really need some advice on how to go about tackling an entity relationship diagram. I have to design one based on a bookshop and have to show the cardinality and optionality of each relation...
Hello,
I have a PBF file and was wondering which software I should use to open it? I've tried using Excel but it's having trouble opening the file. Any suggestions?
Thanks
Hello,
I need to insert miliiseconds in a date field in oracle 9i . I use the following query
UPDATE MSGDB SET CUSTOM25=to_date('2003111212110000','YYYYMMDDHHMISSSS') WHERE MSGDB_ID = 2...
I am trying to create a query that gives me all people with a date of only <06/01/03. If there are people with both dates of < and > 06/01/2003, then I don't want them to show in the query. An...
How can I limit a select statement to x numbers of
rows returned. If this was Oracle I could say
select * from my_table where ROWNUM < 50
to get the first 49 rows. I want to do the same
thing ...
How you people compare all the technologies
ODBC Vs OLEDB Vs ADO Vs ADO.NET
Regards,
Imran
Hi experts,
Can you please look into following query :
SELECT
BA.*
FROM
tblBookingAction BA INNER JOIN tblBookingTask BT ON BA.BookingTaskID = BT.bookingTaskID
INNER JOI...
Dear All,
kindly give me the query to check the index for the oracle table........
Thanks,
Priyashree
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 have am trying to write an ASP page that pulls data from a SQL Server database, where the SQL server is on a different machine than the IIS server.
I have everything working, except when ...
Hi ,
How to create Database schema in oracle 10g.
Thanks,
Sathish
Hi,
I want to combine two columns in a sql statement with 'AS' but am unsure how to do it with SQL Server. For example, combine a LastName field with a FirstName field 'AS' Fullname. Help?
Has Google published details of what their back end Database technology is? Is their database based on a standard RDBMS (Oracle/DB2?) or a proprietry indexing system?
I am working with opt...
working in oracle and up to last night all wokred fine, but today I am getting this error and not too sure what is causing that, any help would be appreciated.
I get it everytime I create a u...
Hello Gurus!
I am working with an application that updates a FACT table in an oracle schema. I want to add a trigger to that FACT table that executes a stored procedure that moves the data f...
Hi,
I have a question about
'How to use Oracle's 'Execute Immediate' with keywords 'Using' & 'Into' together.'
======================================================
I have no proble...
Hello,
How do I change a user password in DB2? I have the db2admin password but I don't have the password of one of the users.
Thanks
Is there a built in oracle function that will give the number of days since a certain (built in oracle) date? eg given 01/01/2000 it would return a number representing the number of days since...
While restoring the SQL Server database, I got the message:
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally.
Are there oth...
