Viewing 15 posts - 16 through 30 (of 33 total)
Actually what I understand U want to insert Deleted Records into History Table.
For that your trigger query should be like this..
INSERT into...
December 11, 2006 at 4:26 am
Hi,
1. When U R running Ur Query that time Excel Sheet should not be opened.
2. Sheet Name should not have space e.g. Ur Excel Sheet Name is [Add Revenue...
December 11, 2006 at 4:13 am
Ad hoc Query: Ad hoc queries provide the ability to open a connection to a remote data source and query it from within T-SQL code. This one-time connection lives just...
December 8, 2006 at 4:47 am
U can do it better than SQL 2000
1. Add Your External Tool
2. Give Title
3. Fill Command
4. Check Prompt for Arguments
5. U can use "Use Output Window" for your convenience.
When U'll...
December 8, 2006 at 3:52 am
R U working on SQL 2000 or 2005?
If on SQL 2005 - Then think about Table Partitioning. And straight forward see regarding Stored Procedures/Dynamic Stored Procedures. And most important Ur...
December 7, 2006 at 7:03 am
Analysis your need. How frequently user data is deleting and how frequently U need to revert back. What's a % of display the deleted data in Reports. Or ther e...
December 7, 2006 at 6:46 am
Now It will work....
osql -S pc0428 -U sa -P sa123 -d PO -i D
December 7, 2006 at 6:25 am
Thanks Luke L & SQBill -
I picked this from SQL Profiler when Opening SQL Server Management Studio. I knew that it gives 9 with SQL 2005 and 8 with...
December 7, 2006 at 6:08 am
OPENDATASOURCE: It Is a one way to work with Excel or other third party Data in SQL. Some how U may utilize it.
Query - The reference Book: Microsoft SQL Server 2005...
December 6, 2006 at 3:07 am
HI I'M SENDING U SAMPLE QUERY - HOPE IT WILL WORK BUT THERE WILL BE ANOTHER PROBLEME WHEN U'LL CHANGE SECOND FIELD OTHER THAN INT. I'LL POST THAT SOLUTION TOMARROW....
December 5, 2006 at 7:13 am
I would like to see another one named query field
If it is like this....
CASE DatePart(dw, reporting_date) -- for week day name
WHEN 1 THEN '1'
WHEN 2 THEN '2'
...
December 5, 2006 at 5:40 am
U must follow ---> Change the field back to int, make sure they are still indexed (if they were before). And never let the client again decide of the DB...
December 5, 2006 at 4:52 am
I'm agree with SQLBill
Why don't you test it yourself?
But Ok Sending U another simple way...
SELECT
tblSales.FruitID,
tblSales.Date,
tblSales.Volume,
tblSales.Price,
tblFruit.FruitDescription
FROM
tblFruit
INNER JOIN tblSales
ON TblFruit.FruitID = tblSales.FruitID
WHERE...
December 5, 2006 at 4:28 am
Hi Dear Suppose there is three tables eg.: Table1..2..3
and One has 5 Columns, Two has 6 columns and Three has 9.
And here I supposed to there is some Link column...
November 30, 2006 at 6:50 am
Viewing 15 posts - 16 through 30 (of 33 total)