Hello Experts,
Can you please provide good DBMS tutorials references?
Thanks,
Shailesh
Hi,
I'm just beginning with triggers...
I've got a trigger that updates 'modify_ts' on the 'product' table after a update, but I want it to update the 'modify_ts' of the 'product' table ...
Can't load database server because the default database is marked as suspect.
I start the SQL server and see it in the taskmanager.
In Enterprise Manager
I try to connect to the SQL s...
Ok - here is an opportunity for someone to explain to me things in very *simple* terms!!
I have two files which I believe to be significant parts of a database. The files are:
FileName....
I am having considerable difficulty in extracting understandable information from most messages in Event Viewer within the company in which I work. I have a user that is experiencing the follo...
I am having trouble with LINQ and transactions when two transactions share the same DataContext object.
In the simplified code below I will get an System.Data.SqlClient.SqlException: Viola...
We are converting oracle-BOXI to sql server-SSRS i cam across the following parameter to_date which is nt recognized in sql server
TD.STANDARD_DATE BETWEEN
to_date('01/01/(A)','MM/DD/YY...
Hello all,
I runned some sql commands on a db, but now, I want to undo the changes made on the db.
Can I rollback using the transaction log? How do I rollback to the --CHECKPOINT-0000-002125...
Hello all,
I know that the parent/child relationship questions have been asked many times before. I have gone through the archives of EE but couldn't find the exact solution to my problem, ...
I have an ADO Stream, opened in binary mode, and I want to write binary data to that stream. Below is a test program that compiles as a console application in VC++ 2008. It simply creates a ne...
I created a select query that ranks store performance within product categories. Since this data will eventually be used in a form, I am attempting to change this to a Make Table or Append que...
Hi.
I have a database with about 200k entries, and i try to show 20 next entries from entrynum ie. 84800.
This takes 4-8 seconds to execute, wich is way to long for å web-site.
Is there...
I need instructions for inserting a hyperlink on my form. I have a table that contains a field named 'Attachments' which I think contains the link to the table with the data I want to display....
Customer and CustomerPrivateInfo are meant to be one to one relationship. If CustomerPrivateInfo record is attempted to be deleted, prevent deletion. If Customer record is deleted, delete its ...
Everytime I use the Database Engine Tuning Advisor after I click "start analysis", under the tuning log I get this error:
E000 Error encountered while generating reports. Write to [msdb]....
Hellow all,
Is there a mysql query that returns the unique id of the next stored record?
greetz,
walter
EXPERTS,
I am working with Oracle10g and needed to change the SID. Here is how I did it, see code box. It seemed to work but now when I try to do anything, such as, alter database sta...
i'm designning an simple inventory system. i have inventory table with below colunm name.
ID PartNumber Desc Q'ty SerialNumber
should i have a table only for SerialNumber?
what...
Hi All
I am using Crystal reports 9 to interrogate a SQL Server 2008 express database and am trying to run a report that will return all bookings for today from a booking table. I am using...
I have an example file
cell
I 20
currently it averages the column, but i need each value to only represent the weighted percentage of calls as shown in column K instead of each being val...
Hello Experts,
This is my first question I just opened an account kindly excuse if not clear.
I am using an SQL in my VB6 pgm that uses both GROUP BY and ORDER BY and need to be able to gr...
I have a table which stores users' dates of birth. I need to create a a query that will group them into the following age ranges:
Age Ranges
18-25
26-30
31-45
45+
Second column is ...
I am joining a number of tables, primarily a members table with a table that tracks their searches.
I want to send them an email about their searches, but what is happening that the SQL is ...
I am looking for the fastest method (milliseconds matter!) to get a ~2Mb single column TXT/CSV file into an open XLS file on a specific worksheet in a specific column.
The CSV file is close...
I'm inserting a record in my table2 and i'd like the id to be returned to be upon the insert. I am executing this from an asp.net application so if possible I'd like to limit the number of req...
