Viewing 15 posts - 8,116 through 8,130 (of 11,678 total)
Cadavre (2/6/2012)
Koen Verbeeck (2/6/2012)
http://www.sqlservercentral.com/Forums/Topic1246473-391-1.aspx?Update=1
Now he is just copy pasting MSDN articles into the topics. :rolleyes:
At least it had something to...
February 6, 2012 at 7:27 am
It seems we have a personification of Google on these forums:
http://www.sqlservercentral.com/Forums/Topic1246473-391-1.aspx?Update=1
Now he is just copy pasting MSDN articles into the topics. :rolleyes:
At least it had something to do with the...
February 6, 2012 at 7:23 am
johnitech.itech (2/6/2012)
Comparing Change Data Capture and Change Tracking....
You know it is common courtesy to provide at least a reference to the material you are quoting?
Otherwise you are just violating...
February 6, 2012 at 7:21 am
drew.georgopulos (2/6/2012)
i hadnt thought about much of what you raised (content vs schema, context vs last transaction); thank you for taking the time to write this, i appreciate it.drew
You...
February 6, 2012 at 7:20 am
Divine Flame (2/6/2012)
Pin drop silence here from past 2 days !!! What happened ? Does Brandie's last post has something to do with it ?? :hehe: 😛
Maybe. I've been watching...
February 6, 2012 at 6:55 am
GilaMonster (2/6/2012)
February 6, 2012 at 6:01 am
umut ozkan (2/6/2012)
i have tried "ln.PRODAMOUNT=CONVERT(FLOAT,100)". Its not worked.also ROUND(ln.PRODAMOUNT,0)=100 its worked.
That makes sense.
Floating point is approximate.
Meaning, it can be that the value is actually 99.999987 for example. When you...
February 6, 2012 at 5:38 am
umut ozkan (2/6/2012)
February 6, 2012 at 4:57 am
ako58 (2/6/2012)
CREATE TABLE t(id INT IDENTITY, i INT)BEGIN TRAN
INSERT INTO t VALUES (4),(2),(3)
SELECT * FROM t
ROLLBACK TRAN
SELECT * FROM t
INSERT INTO t VALUES (4),(2),(3)
SELECT * FROM t
where is rollback?
I don't...
February 6, 2012 at 3:24 am
nhimabindhu (2/6/2012)
Requirement is like that without using sql query .populating data using only ssis transfomations.:-)
That is a silly requirement. TSQL will outperform the SSIS components by a multitude (or is...
February 6, 2012 at 3:20 am
Sorry, I forgot the screenshot (see the attachment).
February 6, 2012 at 2:22 am
Apparently you have a magic SQL query, because there is no quantity column in the source, but there is one in the output. :w00t:
Seriously now, you can just execute the...
February 6, 2012 at 2:21 am
Check your own login:
which server roles are assigned to your login?
February 6, 2012 at 2:16 am
Henrico Bekker (2/6/2012)
Koen Verbeeck (2/5/2012)
Henrico Bekker (2/5/2012)
No, you can never rollback a transaction with a TRUNCATE TABLE statement, regardless of recovery mode
isn't also...
February 6, 2012 at 12:40 am
mike 38908 (2/3/2012)
February 6, 2012 at 12:40 am
Viewing 15 posts - 8,116 through 8,130 (of 11,678 total)