Alan.B (8/20/2013)

---

opc.three (8/19/2013)

---

Here is a non-cursor option, just for the sake of having an alternative to using a cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += 'EXEC LoadFile ' + QUOTENAME(FILENAME,...

ScottPletcher (8/20/2013)

---

Erland Sommarskog (8/20/2013)

---

How...

And for completeness here is your XML version that handles character entitization properly by using TYPE with FOR XML and the .value XQuery method:

USE YourDatabaseName

go

IF OBJECT_ID('dbo.newtable') IS NOT NULL

...

Erland Sommarskog (8/19/2013)

---

opc.three (8/19/2013)

---

Can you please elaborate? I use this technique quite often and am interested to know what you mean by "as the correct result of SELECT statement is...

The attempt is warranted but using XML has its drawbacks....

Erland Sommarskog (8/19/2013)

---

opc.three (8/19/2013)

---

Here is a non-cursor option, just for the sake of having an alternative to using a cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += 'EXEC LoadFile ' +...

Here is a non-cursor option, just for the sake of having an alternative to using a cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += 'EXEC LoadFile ' + QUOTENAME(FILENAME, '''') +...

The Import and Export Wizard reachable via SSMS is quite handy to copy data to a test instance. In SSMS Object Explorer, right-click your source database, select Tasks, and choose...

In SQL 2008 and 2005 a simple SQLCLR function that leverages the TryParse method of the Int32 object is the most complete way to check for whether a string value...

Nice use of PowerShell.

Something like this?

USE YourDatabaseName;

GO

CREATE TABLE newtable

(

softwaremanufacturer VARCHAR(100),

productname VARCHAR(100),

productversion VARCHAR(100),

a VARCHAR(100),

b VARCHAR(100),

c VARCHAR(100),

d VARCHAR(100)

);

GO

WITH cte

...

OnlyOneRJ (8/18/2013)

---

Thanks Hanshi, Ness & GAIL...

below will be tyhe step which will be done incase of deletion..

1) Restore Last Full Backup (Normal Backup)

2) Restore all Log Backup Copies after Full...

Spotfire

refactor

jeanna_mcmahon (8/8/2013)

---

Orlando, this guide is pretty amazing. It's exactly what I was looking for to handle random data dumps from another team that needed to be imported to a...