Viewing 15 posts - 1 through 15 (of 373 total)
I am using 'Pragmatic Task factory' tasks/adapters to Synchronize the Salesforce data with SQL Server data. It is very cool.
October 1, 2014 at 1:31 am
@hugo - Good analysis. I like detailed explanation. Thanks for sharing
September 5, 2014 at 12:09 am
twin.devil (9/3/2014)
Nice Question Steve. Thanks for sharing
+1
Learned new syntax
September 3, 2014 at 11:45 pm
Adding new table doesn't require downtime at all.
If your queries are not using SELECT * then you are ok to add new column (as it will not affect your application...
September 2, 2014 at 4:06 am
SqlMel (9/1/2014)
+7!Thanks for the question, Steve.
Very good function, btw.
+1
September 2, 2014 at 4:01 am
crazy_new (9/1/2014)
Hey guys, is it possible to delete from a table,then insert into that same table, and then delete from a second table, all in one INSERT trigger?
Recursive trigger is...
September 1, 2014 at 2:56 am
Miles Neale (8/29/2014)
SQLRNNR (8/29/2014)
Stuart Davies (8/29/2014)
Easy end to the weeks - thanks+1
+2
+1
September 1, 2014 at 2:50 am
The idea of the query is not bad (though a bit repetitive). But the execution is rather poor. Too bad.
Thanks for the question
September 1, 2014 at 2:44 am
where you want to manipulate the value? During INSERT operation?
Or you are trying to build SQL Query to retrieve the data as per your need?
August 27, 2014 at 3:42 am
As you mentioned dirty read is ok then use
SELECT <<column names>> FROM table1 WITH (NOLOCK)
Also, nolock hint should not be used with DELETE & UPDATE statements. This is in deprecated...
August 27, 2014 at 2:55 am
Viewing 15 posts - 1 through 15 (of 373 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy