Viewing 15 posts - 4,861 through 4,875 (of 5,393 total)
It could look like this:
CREATE TRIGGER TR_TEST
ON MyTable
INSTEAD OF INSERT
AS
BEGIN
TRUNCATE TABLE MyTable
INSERT INTO MyTable
SELECT *
FROM INSERTED
END
Hope this helps
Gianluca
-- Gianluca Sartori
September 11, 2009 at 1:18 am
You cannot BULK INSERT from HTTP. You will have to download the file first.
The file can be downloaded with some tool like cURL (http://curl.haxx.se/).
Hope this helps
Gianluca
-- Gianluca Sartori
September 11, 2009 at 1:11 am
I suppose indexes are the same and statistics are up to date...
I think some more details are required here to understand what goes on. Please take a look at this...
-- Gianluca Sartori
September 11, 2009 at 12:56 am
Try this:
http://dotnetslackers.com/articles/net/BarcodeImageGenerationMadeEasy.aspx
1st Google result for "barcode .net image", btw.
-- Gianluca Sartori
September 10, 2009 at 7:50 am
Don't worry: I lost hours and hours in the past because of typos.... and I still do!:-D
-- Gianluca Sartori
September 10, 2009 at 6:50 am
Would renaming Priotity to Priority fix the issue?
DECLARE @PriorityAmount table (
Amount Decimal(18,2)
,Priotity int) -- shouldn't be Priority??
-- Gianluca Sartori
September 10, 2009 at 6:39 am
I would not install fonts to display barcodes, I'd rather build the barcode image with some software and store the picture in a binary column.
You could use barbecue[/url], for instance.
Hope...
-- Gianluca Sartori
September 10, 2009 at 6:26 am
To ensure the results are always sorted in the same way you have to add an ORDER BY clause.
If you don't provide an explicit order, results are not sorted in...
-- Gianluca Sartori
September 8, 2009 at 6:11 am
laptop: got one, company paid
sql books: never seen one
university: cs degree
driving license: you must have it here to survive
certification: I'm planning to take one, but I will have to pay...
-- Gianluca Sartori
September 8, 2009 at 3:09 am
.... ooops!
That's what I was trying to say, but something short-circuited between my mind and my fingers...
Thanks for correcting!
-- Gianluca Sartori
September 3, 2009 at 4:35 am
Thanks for clarifying.
I'm afraid you will have to do it the old way:
1) update ... from src inner join dest
2) insert into .... where not exists....
-- Gianluca Sartori
September 3, 2009 at 3:52 am
This query is a real nightmare...
First of all, I would say that this query will never perform well, since you are using several correlated subqueries in the select list.
I...
-- Gianluca Sartori
September 3, 2009 at 3:47 am
MERGE is a new feature of SQL Server 2008, there's no such feature in SQL Server 2005.
I don't see any CASE in your query: am I missing something?
-- Gianluca Sartori
September 3, 2009 at 2:48 am
INSERT INTO TABLE1 select *, date_deleted
from TABLE2
Where KEY_ID In (Select KEY_ID From table3 Where Invoice_Num in (select Invoice_num from #TempDelete))
I suggest that you replace the * wildcard with...
-- Gianluca Sartori
September 3, 2009 at 1:00 am
With SAN, cluster and backups you should be ok.
SAN and cluster for immediate recovery, backup for delayed recovery.
I wouldn't set up a replicated db just to have data immediately...
-- Gianluca Sartori
September 2, 2009 at 9:05 am
Viewing 15 posts - 4,861 through 4,875 (of 5,393 total)