Viewing 15 posts - 1,816 through 1,830 (of 2,894 total)
I will definitely try with byte array a bit later, but for now another version with using static instance of RegEx (just added to the same asembly):
...
March 23, 2012 at 7:08 am
Fear Naught (3/23/2012)
GilaMonster (3/22/2012)
One important point... Do not assume the inserted table contains a single row. It may not. It will contain all the rows affected by the update.
This is...
March 23, 2012 at 6:48 am
Jeff Moden (3/22/2012)
Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:i was waiting for that one. :w00t:
Somebody had to say it...and I was kind...
March 23, 2012 at 5:49 am
...
Let's have a race and see how much of a difference there is.
...
NO Jeff! You don't want to do this!
Ok,
Here we are...
1. Test data ( I have around 850,000...
March 23, 2012 at 5:37 am
...
It all depends on the application/environment. I did database development where the sometimes the application handled the transaction (made several calls to the database running several stored procedures) and...
March 22, 2012 at 10:38 am
Ankit.shah22 (3/22/2012)
That helps a lot ..thank you for a kind suggestion...
Is there any way we can find out from T- SQL scripts?
Do you have DDL triggers which do this kind...
March 22, 2012 at 10:25 am
If you don't backup database :w00t: your only other option will be time-machine... :alien:
March 22, 2012 at 10:22 am
If the maximum number of Start/EndDate combinations is definite, then you can do something like this:
declare @mytable table (ID int, StartDate datetime, EndDate datetime)
insert into @mytable
select '239', '05/05/2011','07/21/2011'
UNION ALL
select '239',...
March 22, 2012 at 9:55 am
The answer to your question is:
YES YOU CAN!
Could you please post in a proper way?
Or to make it right will take you more time than to find a solution by...
March 22, 2012 at 9:25 am
...
I'd say it gives you a standard way of writing the code with explicit control over the commit/rollback.
When I see BEGIN TRANSACTION, it give the idea that the following multiple...
March 22, 2012 at 9:22 am
In a short: because T-SQL is not the same as C# :hehe:
It doesn't mater where you declare your variable, inside or outside of the loop. Declaration will only happen once...
March 22, 2012 at 8:31 am
GuruGPrasad (3/22/2012)
I think i can't use Triggers. Because, The values of Master table will be updated every time a record is inserted / updated / deleted in detail...
March 22, 2012 at 8:23 am
Upgrade, or create custom audit solution based on triggers.
March 22, 2012 at 8:04 am
Looking this thread, you can see again how important it is to follow "forum etiquette" and post DDL, sample data and expected results in most appropriate way when asking the...
March 22, 2012 at 7:38 am
You use LEFT JOIN or NOT EXISTS:
INSERT DestinationTable (...)
SELECT ...
FROM AnotherSource s
LEFT JOIN DestinationTable d
ON d.CodeProject = s.CodeProject
...
March 22, 2012 at 7:31 am
Viewing 15 posts - 1,816 through 1,830 (of 2,894 total)