I need to update user information in a huge table. First name and last name columns have to be replaced by same length masked values. Which of the following ways is the most efficient solution...
Hi
The INSERT statement conflicted with the FOREIGN KEY constraint, after inserting 450 records in the table.
If I remove the constraint and run the SP all records inserted into the table ...
Hello experts
I am using Oracle9i.
Need SQL statement to get number or rows affected by previous Select/Insert/Update/Delete query.
Thx.
I used the follow string connections:
strConnect = "Driver={SQL Server}; Persist Security Info=False; Server=SERVER NAME; Database=DB NAME; Trusted_Connection=Yes;"
AND
strConnect = "Drive...
my database 'generaltestportal' get (suspect)
I ran sp_resetstatus 'generaltestportal'
in sqlserver 2000 query analyzer
but it show the following message
Prior to updating sysdatabases e...
I am looking for a best practice method for desiginng a social networking database schema similar to linked in. Your direction would be greatly appreciated
I'm very green to SQL so please excuse my ignorance...
A contractor setup a SQL server this past weekend and converted our access database to a SQL back end. All is well in house, but a re...
DTS jobs on SQL server 200 worked fine.
I recreated (not import/migrate) same very simple job - which is an import table EMP from Oracle table to a SQL Server 2005 table called EMP.
Howev...
I'm putting together an ERD for a medical practice application. So far I have the following:
employees (doctors, nurses, admin staff)
patients
practices (where doctors, nurses, admin staf...
Dear Experts,
I'm trying to count the number of rows in a table whose name is a variable; for exmple @TableName
I'm trying to achieve something like this:
DECLARE @cnt int
SELECT @cn...
I have the following merge statement that either inserts a new record OR updates a record. Then it prints out the number of rows merged.
I want to be able to print out BOTH number of rows ...
In Excel using VBA, I need to Execute a Stored Procedure in SQL Server. I have located several methods to pass the Parameters needed and I "think" the code is working to that point, but I can...
I asked a question recently to produce an index number (row number) row number in a query. That worked OK, but as datasets get larger, the query takes forever to complete.
I used the follo...
I need to move the ACT version 8.0 database .ADF and ALF files from one server to anther.
Only 2 users having access to the files. I made sure both of them are not using it.
I keep hav...
I have a databses wit specific collation, I want to change collation to another collation name.
How can I achive that ?
Thanks,
Hi Experts,
Thanks for your assistance in advance.
I am creating a database for a plant genetics program. Part of the database needs to operate like a family tree.
I have recently re...
I need to be able to import and export data from tables in MSSQL 2000 and MSSQL 2005. That data may contain extended (utf-8) international characters. It may also contain carriage returns.
...
I am attempting to write an sql query to select the top 3 distinct scores from a table structured as follows:
ID Score User
1 10 5
2 ...
Could anyone guide me on how to list tables from my own Access Database in csharp using ODBC connection.....My task is as follows:
I have two databases one new and another modified one..........
I have a csv file that is imported into sql 2005 with SSIS package works great and very fast, but I can only run it through the exicute package utility or management studio. Is there a way to ...
Connection failed:
SQLState; '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server ...
hi friends
i want to draw data flow diagram.I am using java,mysql database.
this is my first designing
pls advide which tool i can use to draw data flow diagram
Regards
I have a song.dbf file, i am able to view using DBF Viewer 2000. My problem is, I am not able to access the dBase table using ADODB connection. I have another try.dbf which i succesfully made ...
I am in urgent need for a a PL/SQL Function to return the next business day and pass the parameters date and number to count the business days(the number could be negative or positive) and i h...
I am trying to implement 10g Fine grained Audit policy.
The policy was completed successfully but when trying to select from the table I was getting the following error:
ORA-28112 FAILED TO ...
