You can’t make the trigger run asynchronously, but you could have the trigger synchronously send a message to a SQL Service Broker queue. The queue can then be processed asynchronously by a stored procedure.
You’re right: at the standard isolation level, read committed, you do not need to wrap select statements in transactions. Select statements will be protected from dirty reads whether you wrap them in a transaction or not. connection 1: connection 2: begin transaction update user set name=”Bill” where id = 1 select name from users where … Read more
You should read this: http://www.sommarskog.se/error-handling-I.html I can’t recommend that link highly enough. It’s a bit long, but in a good way. There’s a disclaimer at the front that it was originally written for SQL Server 2000, but it covers the new try/catch error handling abilities in SQL Server 2005+ as well.
Creating one global Entity Framework DbContext in a web application is very bad. The DbContext class is not thread-safe (and same holds for Entity Framework v1’s ObjectContext class). It is built around the concept of the unit of work and this means you use it to operate a single use case: thus for a business … Read more
One option that avoids needing to add EndDate + 23:59:59.999 is to not use the between comparison and instead use column_name >= @StartDate and column_name < @EndDate +1
In SQL, the way to do this is to double the apostrophe: ‘he doesn”t work for me’ However, if you are doing this programmatically, you should use an API that accepts parameters and escapes them for you automatically. Programmatically escaping and using string concatenation to assemble a query yourself is a sure way to end … Read more
yes it does. See this
If you know quantity of columns, but don’t know its names and types, you can use following trick: select NULL as C1, NULL as C2 where 1 = 0 — Returns empty table with predefined column names union all select * from Test — There should be exactly 2 columns, but names and data type … Read more
It’s a perfectly legitimate solution for some designs. Say you have a hierarchy of one-to-many relations like Customer – Order – Basket – Item – Price, etc., which can be unfilled on any level: a Customer may have no Orders, an Order can have no Baskets, etc. In this case you issue something like: SELECT … Read more
DECLARE @UTC BIGINT SET @UTC = 1348203320997 SELECT DATEADD(MILLISECOND, @UTC % 1000, DATEADD(SECOND, @UTC / 1000, ‘19700101’))