Further on John Corkett's post, the [COLUMN SET] bridges the gap between a normal table and an EAV type table. Standard set based approach can be used on the database...

Another question, is this a default or a named instance?

😎

Tony Webster (11/11/2014)

---

We were having trouble redefining a stored procedure, and got the test case down to this:

CREATE PROC testproc

AS

SELECT 123

-- CONVERT(varchar)

GO

which on one particular server gives:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData...

lizamungro (11/11/2014)

---

I'm new to using SQL Server. I've been asked to optimize a series of scripts that queries over 4 millions records. I've managed to add indexes and remove a...

BWFC (11/11/2014)

---

Stuart Davies (11/11/2014)

---

BWFC (11/11/2014)

---

One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious...

Quick note, as LinksUp noted, the parentheses do not match, there is an extra opening one before the first instance of T0.DiscPrcnt. To prevent/detect this kind of errors, I find...

chandrachamarthi8 (11/10/2014)

---

Msg 2760, Level 16, State 1, Line 1

The specified schema name "coustmer" either does not exist or you do not have permission to use it.

i got this error ..any...

Goes without saying:-D

Glad to help, just realize that this is a limited solution, only single digit joining between the different nodes, will...

Some guys have all the luck.....:-D

😎

Quick note, this xml structure doesn't make things easier;-)

😎

Here is an example that should get you passed this hurdle

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = N'<Status><IdStatus>1</IdStatus>

<NomStatus>Status 1</NomStatus>

<IdStatus>2</IdStatus>

<NomStatus>Status 2</NomStatus>

<IdStatus>3</IdStatus>

<NomStatus>Status 3</NomStatus>

</Status>

<Process>

<IdProcess>1</IdProcess>

<NomProcess>Process...

debanjan.ray (11/9/2014)

---

Hi Experts,

We are storing changed data of tables into XML format for auditing purpose. The functionality is already achieved. We are using FOR XML Path clause to convert...

Jeff Moden (11/9/2014)

---

Steve, I have an idea. Set it up so that when I report a post as spam and I include a secret word in the report, have...

Quick thought, what happens if you script the view (modify/script as ALTER) and run the script unchanged?

😎

First a quick question, what are you trying to achieve with this?

😎

You can use the DATALENGTH function on any datatype, here is a quick example:

DECLARE @SQL_STR VARCHAR(MAX) = '

-- Returns...

Guessed it would be something along those lines, just hope you are...