Viewing 15 posts - 226 through 240 (of 2,894 total)
You need to create DDL triggers for that. Start from here:
http://msdn.microsoft.com/en-us/library/ms190989(v=sql.105).aspx
August 1, 2013 at 7:23 am
ben.brugman (8/1/2013)
Eugene Elutin (8/1/2013)
It's not just "allows" dirty read. It does exactly perform what is called "dirty reads"!
For my understanding:
1. Dirty reads is the reading of data which is not...
August 1, 2013 at 4:44 am
...One way is to assign getdate() in datetime varibale before start of query execution and after the query execution complete and find the difference between both of them.
The above will...
August 1, 2013 at 4:40 am
Does using the WITH (NOLOCK) hint in queries allow dirty reads?
It's not just "allows" dirty read. It does exactly perform what is called "dirty reads"!
August 1, 2013 at 4:08 am
What about if there is a two months difference between given Start and End and you want consiquent 8 days to generate?
StartMonth,StratYear,EndMonth,EndYear,DaysBetween
12 2008 2 2009 8
It would be...
August 1, 2013 at 4:06 am
...
exec sp_executesql N'select top 51 when 6 then @StatusCode1 when 1 then @StatusCode2 ORDER BY incident0.TicketNumber desc
@StatusCode1=N'Canceled',@StatusCode2=N'In Progress'
SQL you have posted will not compile as it's invalid - there...
August 1, 2013 at 4:01 am
Erland Sommarskog (7/31/2013)
Eugene Elutin (7/31/2013)
August 1, 2013 at 3:24 am
smriti.subramanian (7/31/2013)
select *...
July 31, 2013 at 10:21 am
I can see that records of type 1 have something looking like ID: *9517469000*
Basically you need this one in each related row.
It should not take a lot of time...
July 31, 2013 at 9:47 am
I would like to create 6 staging tables to hold the different types but I'm not sure if it's best to load all the data into SQL first then split...
July 31, 2013 at 9:43 am
Not very clear what your current query trying to do.
From one prospective, using "=*" means you want to return all data from "right" table regardless if any corresponding record is...
July 31, 2013 at 9:35 am
Welcome to the forum!
Before we can help you, you really need to read and follow these tips when posting questions:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 31, 2013 at 8:49 am
Slightly modified Dwain code to return exactly what OP has asked:
DECLARE @t TABLE (strcol CHAR(3));
DECLARE @ValueOfInterest INT = 10;
INSERT INTO @t (strcol)
SELECT ' 5' UNION ALL SELECT ' ...
July 31, 2013 at 7:56 am
Right now I have no time to prepare setup for your case. So if you could post DDL of tables involved with some sample data (as INSERT) and clearly defined...
July 31, 2013 at 7:06 am
I agree with ChrisM@Work, that there is nothing in the query plan explaining such extravagant behaviour of these queries.
From what I can see, it's only happens when you UNION...
July 31, 2013 at 3:41 am
Viewing 15 posts - 226 through 240 (of 2,894 total)