tsql

Carlos L Chacon
September 28, 2012
No Comments

Recursive CTE Query

Recursive CTE Query https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g September 28, 2012 December 16, 2020

A client came to me and had the similar to data set below. Create Table…

Carlos L Chacon
August 31, 2012
No Comments

sp_executesql

sp_executesql https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g August 31, 2012 December 16, 2020

I don’t normally have a need to do dynamic sql; however, I found myself at…

Carlos L Chacon
August 10, 2012
No Comments

Grant access to tables

Grant access to tables https://sqldatapartners.com/wp-content/themes/crocal/images/empty/thumbnail.jpg 150 150 Carlos L Chacon Carlos L Chacon https://secure.gravatar.com/avatar/5e3365b6a313f63d0ad1fd6748a46345?s=96&d=mm&r=g August 10, 2012 February 5, 2021

Often, when setting up database security where it hadn’t been before, there is a need…

Recursive CTE Query

sp_executesql

Grant access to tables

Learn More

What We Do

Say Hello

©2020 SQL Data Partners. All rights reserved.

Learn More

What We Do

Say Hello

©2020 SQL Data Partners. All rights reserved.

SQL Data Partners is Joining

Marathon Consulting

Read more about the transition and what to expect