Using MS SQL Server

difference between explicit inner join and implicit
Is there any difference between explicit inner join and implicit inner join Example of an explicit inner join: SELECT * FROM employee INNER JOIN department ON employee.DepartmentID = department.DepartmentID Example of an implicit inner join: SELECT * FROM employee, department WHE... 31 Mar 2008 20:39

Internal query processor error
Hi, I am trying to execute rather complex query, and I got query processor error. I read the Microsoft support page and it said I should install SP4, and I did, but the error is still there. I am running MSDE with SP4 installed. Everything else works like a charm. Zvonko ... 31 Mar 2008 20:00

min_active_rowversion ( was Re: Triggers and Flag bit)
Erland Sommarskog wrote: Sharif Islam (mislam(a)spam.uiuc.edu) writes: Thanks for the help. Here's how I am using it. I created a column 'Flag' with timestamp datatype. ------ declare @before timestamp declare @after timestamp set @before= min_active_rowversion() -1 update MyTable... 31 Mar 2008 20:00

CASE WHEN Equivalent in WHERE Clause?
On Fri, 28 Mar 2008 11:40:05 -0700 (PDT), --CELKO-- wrote: Is there an equivalent construction to the CASE WHEN statement that can be used in the WHERE clause? << 1) There is no CASE statement in SQL; but we do have a CASE expression. You still have a procedural mindset and have not started thinking in... 31 Mar 2008 20:00

concurrency problem with lists ("check constraint" on groups of rows)
Hi! In the meantime I found out that most of the actual problems came from another corner: an FK with "on cascade delete", which result in dublet groups. But the problem is still actual since I plan to scale- up the application; but before doing that I must ensure that it will be able to handle more concurrency. ... 31 Mar 2008 19:19

Data Browser for SQL Server
Hello all, I was wondering if anyone was aware of an application that is just designed for browsing sql server table and data. I have seen one called aespe Table Browser which looked promising but it doesnt work. I like the way ms-access does everything, but I cant use that without first linking the tables.... 2 Apr 2008 21:22

How to Interrogate SQL Server Tables for Specific Values - Here's how to do it in MS Access
robboll (robboll(a)hotmail.com) writes: If you're really not sure what I am asking: Say you are looking for the string "abc123" and you need to look in all the tables and columns for that value. I have the routine to do so in Access as posted. I am looking for a way to do it using SQL Server. Appriciate a... 31 Mar 2008 20:00

SQL Server 2005 disk layout - opinions?
Since this is not my area of expertise, I asked in our internal MVP forum, and my MVP mate Andrew Kelly had this comment: I have an EMC SAN. I will separate storage into 3 RAID 10 LUNs (separate spindles): D: is TEMP E: is DATA (DATABASES) F: is LOG The server has 2 dual-core CPUS, so I will p... 31 Mar 2008 19:19

Namespace problem in Bulkload
I have namspace problem in Bulkload where if in XML data file, I have a namespace like xmlns='urn:TMSWebServices', then in my schema I must put xmlns:tm="urn:TMSWebServices" right? but if I put that, then I will not able to use Bulkload as it say tm:callSign has invalide charater. How can I deal with namespace... 31 Mar 2008 20:00

Encoding problem in SQLXML - bulkload
I got an XML Data in UTF-8 encoding like this Dah$)A(&li but when I run the schema to insert data into SQL Server 2005 Express edition, the data will become like this Dah$)A!'�0�7li How can I solve the encoding problem? XML data: ======================================= <crew program='SH0087740... 31 Mar 2008 20:39