dear club members
I want to grant "truncate table privileges" to a non owner user.
If any body know please let me know
THanks
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...
What is the meaning of:
"COLLATE SQL_Latin1_General_CP1_CI_AS NULL"
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...
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...
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...
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 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 ...
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...
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
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...
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 ...
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...
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
...
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,
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?
How you people compare all the technologies
ODBC Vs OLEDB Vs ADO Vs ADO.NET
Regards,
Imran
Dear All,
kindly give me the query to check the index for the oracle table........
Thanks,
Priyashree
Hi,
I have a question about
'How to use Oracle's 'Execute Immediate' with keywords 'Using' & 'Into' together.'
======================================================
I have no proble...
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...
Hi ,
How to create Database schema in oracle 10g.
Thanks,
Sathish
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...
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...
