I have used a similar procedure to move records in a sequence. I won't repeat the table setup, but I need to point out that I used "1" as...

This is a very helpful script; thank you for providing it.

Because most of our permissions are assigned by role, and individual users are assigned to roles, having a similar generator...

In my experience, every table has a row in sys.sysindexes that can be used to tell the number of rows in the table.

SELECT i.rowcnt, o.name

FROM sys.sysobjects o JOIN sys.sysindexes...

I like the script. I would like to see the datetime fields formatted using format 121 so that the second and millisecond precision is retained.

To the comment that SQL Server should be able to find these relationships: I'm sure it would be possible to write a parsing engine to determine what each script is...

I have not seen anything in SQL Server that will identify for a developer the code that will break when creating a foreign key reference on a table. SQL...

SELECT CASE WHEN column_id = MIN(column_id) OVER(PARTITION BY 1) THEN 'INSERT INTO ' + OBJECT_NAME(object_id) + ' (' ELSE '' END + name + CASE WHEN column_id = MAX(column_id)...

Another way to solve this problem is to create a temp table in the first procedure. The second procedure looks for the existence of the temp table and adds...

It seems to me that this solution will only work if there are only two levels of parent/child relationship. Do you have cases where the relationships go to three...

The data in the challenge is obviously unrealistic in order to be able to produce the graph. I use graphing in SQL Server for on a regular basis, as...

The use of the term "schema" in this article is confusing because the term has a specific meaning in SQL Server which differs from its use here. Perhaps using...