briankwartler (5/5/2015)

---

I have a question about the answer provided. It says:

Declaring a "FLOAT" without providing the number of bits to use, e.g. FLOAT(n), results in the default FLOAT(54) which is...

For those finding this post through a search engine, like I did...

A single-precision floating point number is represented as the REAL data type which can also be declared as FLOAT(24).

A...

Thanks for the detailed write-up.

Issue 1: you are setting the value of @tableHTML before you set @tableHTML1 and @tableHTML2. Hopeflly that happened when you tried to prepare the code for posting on this forum.

Issue...

This is not about canceling a query, it's about control flow. Try out the TRY...CATCH construct and use THROW to change how your procedure flows:

BEGIN TRY

DECLARE @MaxLoadDate AS DATE =...

+1 to the idea of removing Access from the equation if possible and having the data provider write to SQL Server. If that is not possible then look into converting...

ScottPletcher (4/22/2015)

---

Orlando Colamatteo (4/22/2015)

---

ScottPletcher (4/22/2015)

---

Orlando Colamatteo (4/22/2015)

---

I'll second the point: definitely store your dates and times in a column of type DATETIME. If you make that a non-negotiable starting point...

ScottPletcher (4/22/2015)

---

Orlando Colamatteo (4/22/2015)

---

I'll second the point: definitely store your dates and times in a column of type DATETIME. If you make that a non-negotiable starting point the rest of...

I'll second the point: definitely store your dates and times in a column of type DATETIME. If you make that a non-negotiable starting point the rest of this will be...

matthew.hudsonbryan (4/22/2015)

---

This version fixes the small mistake of the last and outputs the database name and username along with the drop statement to make it easier to see the users...

Personally I like the "concatenated aggregate" method sqlservercentral 46394 showed however Erland pointed out some problems with it if you mess with the ORDER BY in specific ways, e.g. adding...

brian.miller 15246 (3/30/2015)

---

Thank you for the post. However it appears to only work for tables in the 'dbo' schema and returns the columns in alphabetical order.

The modified script below...

Tom Bakerman (3/30/2015)

---

Why all the complication with REPLACE(REVERSE(STUFF(REVERSE ...

I typically do this to get a comma separated list:

SELECT STUFF((SELECT ',' + name AS [data()]

FROM sys.columns

WHERE OBJECT_NAME(object_id) = @TableName

ORDER BY...

PS regarding your question about best practices I was not sure if you meant tools or strategy so focused on toos in my last post since you mentioned Maintenance Plans...

Go to http://ola.hallengren.com and check out his solution for backing up your databases and logs. I've been using it for years and it has saved me countless hours. It even...