I know what thisstatement does below but can someone explain two things?
1) What does the N' do in this expression? Is it necessary? What is its purpose?
2) In the Type function, what are valid arguments? Does P mean stored procedure? What does PC mean? What are the other values? Is there documentation someplace that details all of this?
/****** Object: StoredProcedure [dbo].[glCalcPMBeginningBalance] Script Date: 12/25/2009 12:43:53 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[glCalcPMBeginningBalance]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[glCalcPMBeginningBalance]