Check constraints will validate that data in a table follows certain rules.

Error handling will prevent errors from crashing a process by giving the option of following an alternate path if...

Thank you for the feedback.

I hope that you noticed the change in the table name. I also hope that you understand the solution and how does it work.

I was just going to mention that folder. I'm glad that you were able to attach the db successfully.

Remember that SQL Server has different credentials than your user account. That's...

That's great. Thank you for the feedback.

Try changing your code to this, there's no need for all that dynamic code:

DECLARE @colsUnpivot AS NVARCHAR(MAX);

DECLARE @query AS NVARCHAR(MAX);

DECLARE @Table_Name as Varchar(200);

DECLARE @transaction_Table NVarchar(500);

SET @Table_Name =...

What's the result from this query?

SELECT t.name, c.name, c.is_identity

FROM SCCOE_Order_Progression.sys.columns c

JOIN SCCOE_Order_Progression.sys.tables t ON c.object_id = t.object_id

JOIN SCCOE_Order_Progression.sys.schemas s ON t.schema_id = s.schema_id

WHERE s.name = 'dbo'

AND t.name = 'ATTU_Sales_organization'

AND c.name...

What's the result if you run this?

SELECT @@VERSION

It's not including only values from 8.0 to 9.9. It's also not comparing ASCII values.

It's ordering the values as a dictionary would do (but with more characters) and the order...

Brandie Tarvin (10/25/2016)

---

trangen1 (10/25/2016)

---

what do you mean????? "The code below clears the Local Servers Group completely (be aware of this),"???

can I run it without this clearing of the LSG????

'dir -Recurse...

READ COMMITTED should be enough. I would test, though.

Why not do it at once instead of using a variable?

CREATE PROCEDURE dbo.GetNextId @Col1 INT

AS

SET NOCOUNT, XACT_ABORT ON;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

...

Should I be concerned for this person's info?

SQL Server will assign the value automatically. Are you sure that the column has the identity property assigned correctly?

At first, I thought another possibility would be having SET IDENTITY_INSERT ON,...

Functions in SQL don't perform tasks. Functions return values, that's their main purpose in any language.

To perform a process, you need a stored procedure. To update the values in a...

Then create it. Just remember that scalar user defined...