Multiple usage works when used in the same query; multiple queries in the same statement can't re-use it.
$0This is a big limitation, granted, but the documentation is correct.$0
Last modified by teljj001 on 11/2/2010 5:58:00 AM
-- INSTEAD OF example from MSDN. Slight naming convention changes and use of date data type.CREATE DATABASE InsteadOfExample;GOUSE InsteadOfExample;GOCREATE TABLE Person ( SSN char(11) PRIMARY KEY, Name nvarchar(100), Address nvarchar(100), Birthdate date -- datetime and smalldatetime are deprecated. no need to store time of birth. );GOCREATE TABLE Employee
Last modified by wulgulmerang on 3/2/2010 2:06:21 PM