Adrian Small

Oracle Link

by Adrian Small

SQLServerCentral.com

Distributed Queries

SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However not all database systems run on SQL Server and it seems that we often see data from some other system being consolidated on SQL Server for additional processing or reporting. DTS usually handles the load, but there are times that you might want create a linked server to an Oracle system for updating individual rows. New author Adria

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2004-12-29

17,482 reads

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Adding new column with DEFAULT

Which number will the COUNT() return after executing the following statements:

DROP TABLE IF EXISTS #test;
CREATE TABLE #test (id INT)
INSERT INTO #test (id)
SELECT *
  FROM GENERATE_SERIES(1, 3) AS gs
;

ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0;
go
UPDATE #test SET flag = 0 WHERE id = 1
UPDATE #test SET flag = 1 WHERE id = 2

INSERT INTO #test (id) VALUES (4)

SELECT COUNT(*)
  FROM #test AS t
 WHERE flag = 0

See possible answers

Adrian Small

Oracle Link

Blogs

Measuring RAG Solutions: Are We Retrieving the Right Information?

Advice I Like: Lots of Ideas

Building a DBA Agent for Your SQL Server Estate with MCP

Forums

Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233

Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203

BCA KCU KUNINGAN Telp/Wa:0821-8200-174

Question of the Day

Adding new column with DEFAULT