Using MS SQL Server

Query Japanese Text in an NVarChar?
I apologize if this has been covered ad nauseum, but I didn't see it in my search. Basically, in an nvarchar(150) column (called "Phrase" in the below samples) I store both english text as well as japanese (the table is for translations). What I'm having trouble with is querying the table by the NVarChar field. ... 16 Apr 2008 07:23

UTF-8 Coding of MSSQL 2005 DB
On Mar 26, 11:11 am, Shawn Beasley <shawn.beas...(a)freenet.de> wrote: Hi List, I am searching franticly for a solution (or the procedure) to setting the coding of a new DB to UTF-8. I can find no setting in the Server Manager, during creation of the DB, to influence this. Can someone please show me the... 15 Apr 2008 10:44

select cases where a datetime is not 3 or more hours older than a similar case
Here is one way (SQL Server 2005): ;WITH RankedLogEntries AS (SELECT PresentationID, AccessTime, IPAddress, PageCalled, ROW_NUMBER() OVER( PARTITION BY PresentationID, IPAddress, PageCalled ORDER BY AccessTime) AS seq FROM OlapWebUseLogEntries) SELECT N.Pre... 15 Apr 2008 10:44

select cases where a datetime is not 3 or more hours older than asimilar case
Hello SQL-experts, I have a table with a datetime field, 'accesstime'. The table also holds a varchar column, 'IPaddress". I now need to select all the IP addresses of this table where this datetime field is not represented within 3 hours of another, similar entry. Here's what I've got: This is my ta... 15 Apr 2008 09:07

case-when error
hello i am learning how to write stored procedures in sql server, i would like to know what's wrong with the following statement? please help the management studio gives me the following error: Msg 156, Level 15, State 1, Procedure spDealMasterSearch, Line 19 Incorrect syntax near the keyword 'CASE'. ... 15 Apr 2008 09:55

import ADO DLL
I have an application that needs to import a DLL file for some database call like - #import "c:\Program Files\Common Files\System\ADO\msado15.dll" \ rename("EOF", "EndOfFile") the path is OS dependent - what if I run on some other PC but the msado15.dll is not specificed in the path specified? ... 15 Apr 2008 09:07

Performing Bulk Load of XML Data
I found this quite interesting. However, it seems to assume I have a schema defined in an xsd or xdr file. I get a data feed that appears to be well formed XML, but there is no schema. Is it possible to bulk load XML data without a schema file being available? If not, is there a tool that will create a schem... 14 Apr 2008 23:24

Login failed for user 'sa'. Reason: Server is in single usermode.
I found a workaround. I simply used SQLCMD rather than Mgmt Studio. I guess Mgmt Studio must be trying to make a 2nd connection somehow, but I don't know why. I scripted this out on my test server beforehand, and Mgmt Studio connected just fine.... <scratching head>... aj aj wrote: SQL Server 2005 SP2... 14 Apr 2008 17:49

Login failed for user 'sa'. Reason: Server is in single user mode.
SQL Server 2005 SP2 2005.090.3054.00 I'm trying to move master/model/msdb to a new spot. I restart SQL Server in single user mode with the "-c;-m;-T3608" startup params. When I try to connect to do the detach, I get: Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can... 16 Apr 2008 09:12

Finding "missing" rows
Hello, I have a DB table with data filled from a weather sensor probe, I have one row every 10 minutes and the data fields is not in DateTime format but in string format: yyyyMMddHHmm So for example I have 200804140340 200804140350 200804140400 200804140410 and so on I need to write a query in SQL server ... 16 Apr 2008 07:23