Burned! I don't have a SS 2012 instance so I ran some tests on 2014 and hoped the answer would be the same. I got the correct answer for 2014,...

The foreign key is on the column InventoryInDetailID.

ALTER TABLE [dbo].[PharmInvOutItemPackageReceipts] WITH CHECK ADD CONSTRAINT [FK_PharmInvOutItemPackageReceipts_PharmInvInItemPackages] FOREIGN KEY([InventoryInDetailID])

REFERENCES [dbo].[PharmInvInItemPackages] ([InventoryInDetailID])

You are joining in the delete on the column InvOutItemLineID.

DELETE...

OK, I answered my own question. My question is similar to this one: http://stackoverflow.com/questions/1195324/using-the-result-of-the-sql-messages-pane

The client gets the message but T-SQL does not. Any decent unit test framework for SQL should...

I used the second solution. With the proper names, it even documents the query nicely. The bit values are allowed or not allowed values.

So, I used this:

DECLARE @allowed BIT =...

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to get the current datetime....

SQLRNNR (7/21/2015)

---

On the other hand, I do require candidates that I interview to remote into a server and perform a basic hands on exam while I monitor what they are...

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to get the current datetime. If they hesitate more...

I agree with Steve, though it's certainly difficult today to get a foot in the door without the piece of paper. That was not always true.

I have a bachelor's degree,...

SET XACT_ABORT ON

Add that line before you begin the transaction. With that setting, you may not even need a try/catch. The transaction will roll back on error.

Nicholas Cain (4/17/2009)

---

Here's my personal favourite to spring:

It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million dollars. People are phoning...

Real interview question that I asked during a tech screen for an entry-level programmer position:

Q: Where do you see yourself in 5 years?

A: CEO!

Background: This young fellow, an American by...

CREATE TABLE test_numeric_parent (

thekey NUMERIC(10,0) NOT NULL PRIMARY KEY

);

CREATE TABLE test_decimal_parent (

thekey DECIMAL(10,0) NOT NULL PRIMARY KEY

);

CREATE TABLE test_numeric_child (

thekey NUMERIC(10,0) NOT NULL,

x INT NOT NULL PRIMARY KEY

);

CREATE TABLE test_decimal_child...

Orlando Colamatteo (5/5/2015)

---

The ANSI SQL standard defines NUMERIC and DECIMAL separately and there is a distinction in how each might behave different from one another however that is not the...

While decimal and numeric are functionally equivalent, they are not the same type. There are six types in the question.

The system_type_id for decimal and numeric is not the same. The...

Grant Fritchey (4/24/2015)

---

But, if the clustered index is created as you have it above, since it's not marked as UNIQUE, it's going to add an internal column to make the...