Display: Cloud | List
Most Popular Tags
Results (6 total) All > tables (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
SQL Data (Getting SQL Server Assistance)
how can i take a column from an existing table with data and put it into anopther table with a column that will put a unique value for each item in the first column. example [ITEM] [nvarchar](255) will insert in a table called ItemID and PartID will be a unique identifier
Last modified by StevenB92870 on 9/15/2011 2:26:17 PM
Tags:  contentbug  tables
You can also use the same Cross Apply and Outer Apply with derived tables joined to your main query, this means you can select from a view instead of a TV function (code reuse), seems to work fine with top X and order too, so solved one of my really annoying recurring problems without ridiculously long / complex order by & group by in outer selects ! Fantastic, why MS don't mention this (I thi
Last modified by MemeDeveloper on 7/28/2010 7:01:07 AM
Tags:  apply  derived  joins  outer  tables
-- 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
Working with Lists and Tables: VBA Samples (Part 2 of 2) (May 2009)Summary: Tables and lists are an integral part of Microsoft Excel. Microsoft Excel MVP Ron de Bruin explains some handy VBA subroutines that can make you more productive when using tables or lists. (8 printed pages)Ron de Bruin, Excel MVPFrank Rice, Microsoft CorporationMay 2009Applies to: Microsoft Office Excel 2003, Microsoft Off
Last modified by Microsoft on 5/6/2009 9:04:22 PM
Tags:  tables
How to get a list of tables from an access database (OleDbConnection.GetSchema Method (System.Data.OleDb))
OleDbConnection oleConn = new OleDbConnection("<connection string here>"); string[] restrictions = new string[4]; restrictions[3] = "Table"; oleConn.Open(); // Get list of user tables DataTable dbRet = oleConn.GetSchema("Tables", restrictions); oleConn.Close(); // dbRet will have a column n
Last modified by Jereme__Guenther on 1/20/2009 4:04:08 PM
Tags:  access  tables
Page view tracker