Using MS SQL Server

Differences between relational DB and warehouse ?
Can anyone please explain me main differences between relational DB and warehouse (Point me to web site) ? Apart from theoretical differences I would like to know how Warehouse DB is updated ? If data needs to remain unchanged then what is happening for instance if in source relational DB address for a custo... 23 Jun 2008 23:00

Kuljetusalan ongelmista
Yksinkertainen kysymys: "Mit� Suomen valtion kansantalous saa tehty� niill� 100% puhtailla energiam��rill��n, joita sille tuottaa esim. wanhasta palaneesta vesiekos�hk�voimasta kunnostettu perinteinen pienvesivoimalayhti�mme Lapijoen s�hk� 12v aikana. 10 000 000kWh?" Kertoen selke�� viesti� siit� miten oikeasti ene... 21 Jun 2008 12:46

bcp out in UTF-8 format
I have SQL Server database tables with international character support. Is there any way I bcp out the table in UTF-8 format csv files? ... 21 Jun 2008 10:43

FREEYOUR OWN BUSINESS EARN 150 US $$ PER DAY WITHOUT INVESTMENT.
FREE YOUR OWN BUSINESS EARN 150 US $$ PER DAY http://www.govindswamy-govindaswamy.blogspot.com http://www.kavigovindan.blogspot.com http://www.govindastar.blogspot.com http://www.govindaswamy10.blogspot.com http://www.govindaswamy-amman.blogspot.com ... 20 Jun 2008 23:32

Toad for MSSQL problem: closing script file doesn't "release" the file?
Hi all, After finishing a script in Toad for MSSQL, I saved and closed the file in Toad. I then kicked off our staging process which moves the file from the save location to somewhere else. The staging process choked, coming back with a "file in use" error. After verifying that I had closed the file in Toad, I s... 20 Jun 2008 16:22

Basic SQL Statement Question
I have two tables, Sections and Enrollments. The two tables can be joined on a key. The records for the enrollment table are imported from another system that doesn't always match what is stored in the sections table. For example, there may be a section or two in the enrollments table that does not exist in the ... 23 Jun 2008 09:38

C++ API for SQL Server?
I am thinking of embedding SQL Server express ina (native) C++ application. I am looking for a C++ API for SQE, but cant seem to find one ... Is there a (ANSI) C++ API for making native calls to SQLServer (Express). I am aware of ODBC wrappers, but I'd much rather talk directly to the database, without havi... 25 Jun 2008 09:50

bcp out empty string into csv files
I have a SQL Server table with nvarchar type column which has not null constraint. I am inserting empty string ("") from Java to the table column. When I export this table into .csv file using bcp tool, empty string gets written as NUL character. Is there any way I can bcp out empty string as empty string itself in... 20 Jun 2008 18:25

tbl_A CROSS JOIN top 1000 rows of tbl_B?
How can I cross join all rows of table A with 1000 rows (first 1000, any 1000) of table B? ... 19 Jun 2008 18:51

stored proc with datetime
i need a little syntax help with a SP. i have a datetime field that is part of the search criteria. it may be null in which case it should be ingnored or get all dates. if a date parameter is passed it should find it. it only works for all when the arrivaldate is a varchar. @varArrivalDate varechar(10) = '%', ... 19 Jun 2008 17:49