Skip to content

No Column Name

My learnings and thoughts on SQL Server and PowerShell

  • About Me:
    • Twitter:
    • DBA.stackexchange
  • Community Scripts
  • T-SQL Tuesday
  • SQL Server
  • PowerShell
  • Twitter

Tag: stored procedures

Finding Parameters that do not match Column Names

You think this will take me hours? Ha! Think again.

Finding Parameters that do not match Column Names

Words: 437

Time to read: ~ 2 minutes

Script Link: https://github.com/shaneis/RandomScripts/blob/master/WhereParameterNameDoesNotMatchColumnName.ps1

Continue reading “Finding Parameters that do not match Column Names”

Author Shane O'NeillPosted on May 25, 2018May 25, 2018Categories UncategorizedTags columns, dbatools, parameters, Powershell, scripts, sql-server, stored procedures2 Comments on Finding Parameters that do not match Column Names

Temporarily Renaming Stored Procedure Columns

With an error surprise!

Temporarily Renaming Stored Procedure Columns

Words: 567

Time to read: ~ 3 minutes

Continue reading “Temporarily Renaming Stored Procedure Columns”

Author Shane O'NeillPosted on May 16, 2018May 16, 2018Categories UncategorizedTags actual execution plans, error messages, execution plans, Renaming columns, sql-server, stored procedures, WITH RESULT SETSLeave a comment on Temporarily Renaming Stored Procedure Columns

When Stored Procedures say they Alter Schemas of the Target Table

…even when they shouldn’t!

When Stored Procedures say they Alter Schemas of the Target Table

Words: 423
Time to read: ~ 2 minutes

Continue reading “When Stored Procedures say they Alter Schemas of the Target Table”

Author Shane O'NeillPosted on March 29, 2018March 28, 2018Categories SQL New BloggerTags errors, sql-server, stored procedures, temp tables3 Comments on When Stored Procedures say they Alter Schemas of the Target Table

Follow me on Twitter

My Tweets
  • About Me:
    • Twitter:
    • DBA.stackexchange
  • Community Scripts
  • T-SQL Tuesday
  • SQL Server
  • PowerShell
  • Twitter
No Column Name Powered by WordPress.com.
 

Loading Comments...