faridprogrammer

CREATE TABLE Countries (
  Id  int IDENTITY(1,1) NOT NULL,
  Iso  varchar(2) NOT NULL,
  Name  varchar(80) NOT NULL,
  Iso3  varchar(3) NULL,
  NumCode int  NULL,
  PhoneCode int NOT NULL,
  CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED ([Id] ASC),
  CONSTRAINT [uc_Countries_Iso] UNIQUE NONCLUSTERED ([Iso] ASC)
) 

faridprogrammer

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)

faridprogrammer

/**
 * @param {object} scope - Object that all bound data will be attached to.
 */
function twoWayBind(scope) {
  // a list of all bindings used in the DOM
  // @example
  // { 'person.name': [<input type="text" data-bind="person.name"/>] }
  var bindings = {};

  // each bindings old value to be compared for changes