SQL RNNR

Blog Post

Seattle SQL Pro Workshop 2016

Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:

Seattle SQL Pro Workshop...

2016-10-24

1 reads

Blog Post

Database Dropped

What do you do when a developer comes to you and asks, “Where did the database go?  The database was...

2016-09-19 (first published: )

1,631 reads

Blog Post

Database Dropped

What do you do when a developer comes to you and asks, "Where did the database go? The database was there one minute, and the next it was...

2016-09-09

1 reads

Blogs

A New Word: Ecstatic Shock

By

ecstatic shock – n. a surge of energy upon catching a glimpse from someone...

The CDO’s Playbook for AI Driven Decision Making

By

The New Arena of Leadership The role of the Chief Data Officer is no...

sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0

By

Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...

Read the latest Blogs

Forums

sp_prepare and sp_execute vs sp_executesql

By rajemessage 14195

I have noticed sp_executesql also makes a single plan for a stmt with parameter...

Who am I?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who am I?

Find Invalid Objects in SQL Server

By Nisarg Upadhyay

Comments posted to this topic are about the item Find Invalid Objects in SQL...

Visit the forum

Question of the Day

Who am I?

If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below? 

create procedure AddNewCustomer
  @customername varchar(200)
AS
BEGIN
    DECLARE @added VARCHAR(100)
    SELECT @added = xxx

    IF @customername IS NOT NULL
      INSERT dbo.Customer
      (
          CustomerName,
          AddedBy 
      )
      VALUES
      (@customername, @added)
END

See possible answers