If you are going to switch the encoding from UTF-16 to Windows-1252, you will have to work with the final output as NVARCHAR(MAX) as it cannot be cast back to...

You are better off using the CHARINDEX function, and CHAR or NCHAR functions when dealing with special characters.

😎

DECLARE @TEST_STR NVARCHAR(128) = N'ASDFGHJ[QWER';

SELECT CHARINDEX(NCHAR(91),@TEST_STR) AS POS

Result

POS

----

8

First a question, is float the correct data type for the query, most certainly not if dealing with monetary values.

To print the number, you can use either the STR or...

Do a loop or a cursor, construct a SQL statement for each database, and execute separately.:cool:

If I understand the question correctly, you can use the UNICODE function to determine the case if the characters, even if the column/db is case insensitive.

😎

Quite some room for improvements, start by moving the parameters to the sp_executesql params and validating the inputs.

😎

You are almost there, look at this code, should get you over this hurdle

😎

SELECT

SDH.SalesOrderID AS '@SalesOrderID'

,(SELECT

...

Question: where...

paulo.morgado (4/21/2014)

---

I'm sorry but I failed to get an answer from the provided link.

I have a query that evaluates into an XML document.

I want to read it with SqlCommand.ExecuteXmlReader.

But the...

Brandie Tarvin (4/21/2014)

---

Nevermind. I'm in brain-dead...

PSB (4/21/2014)

---

I have a couple of 14 digit int time in my table

SELECT DATEADD(hh,-5,dateadd(s, convert(bigint, 61353491400000) / 1000, convert(datetime, '1-1-1970 00:00:00')))

The above query throws an error :

Arithmetic overflow error converting...

Open the Script Task Editor and choose Edit Script. In the VSTA editor, select Project menu and Add Reference...

😎

Check out Using XML Data Types on technet

😎

Jeff Moden (4/20/2014)

---

Ok... I have to ask. What do either of those functions do for creating a table other than returning some meta-data that you could write some dynamic...

Quick question, why are you using the nolock hint?