Display: Cloud | List
Most Popular Tags
Results (2 total) All > instead (x)
re multiple usage (Using Common Table Expressions)
Multiple usage works when used in the same query; multiple queries in the same statement can't re-use it. $0$0 $0 $0This is a big limitation, granted, but the documentation is correct.$0
Last modified by teljj001 on 11/2/2010 5:58:00 AM
Tags:  a  are  command  contentbug  create  cursor  easy  for  great  in  instead  later  life  like  made  my  of  programming  sql  such  tables  temp  there  use  vfp  why
-- 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
Tags:  base  insert  instead  multiple  of  tables  view
Page view tracker