Display: Cloud | List
Most Popular Tags
Results (25 total) All > create (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
Visual FoxPro 9.0 SP2CREATE CURSOR - SQL CommandCreates a temporary table that exists until closed. CREATE CURSOR alias_name ...[CODEPAGE=nCodePage] (fname1 cFieldType [(nFieldWidth [, nPrecision])] [NULL | NOT NULL] [CHECK lExpression [ERROR cMessageText]] [AUTOINC [NEXTVALUE NextValue [STEP StepValue]]] [DEFAULT eExpression] [UNIQUE [COLLATE cCollateSequence]] [NOCPTRANS
Last modified by Microsoft on 7/11/2007 8:39:11 PM
Tags:  a  any  command  create  cursor  did  find  for  great  i  in  later  like  not  one  sql  temp  this  to  use
CREATE ROUTE Dynamic SQL? (Lesson 2: Creating the Initiator Database)
Why are the CREATE ROUTE statements in dynamic SQL? Is it just to isolate the USE statements? Or, is there some critical reason?
Last modified by JediSQL on 1/11/2012 12:17:59 AM
Tags:  broker;  create  dynamic  route  service  sql
CREATE PARTITION FUNCTION (Transact-SQL)Creates a function in the current database that maps the rows of a table or index into partitions based on the values of a specified column. Using CREATE PARTITION FUNCTION is the first step in creating a partitioned table or index. Transact-SQL Syntax Conventions CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type ) AS RANGE [
Last modified by Microsoft on 7/12/2011 5:53:51 PM
Two dialects of "Method" (Method Element (View))
There appear to be 2 distinct dialects of <Method>. One for the list service, and another for ProcessBatchData. To insert new records in ProcessBatchData I've found <SetVar Name="Cmd">Save</SetVar> along with <SetVar Name="ID">New</SetVar> the only way I've been able to insert new records.
Last modified by Programmer Bill on 6/10/2009 3:12:14 PM
Tags:  create  new
How to: Create a WorkbookExcel Developer ReferenceTo create a workbook in Visual Basic, use the Add method. The following procedure creates a workbook. Microsoft Excel automatically names the workbook BookN, where N is the next available number. The new workbook becomes the active workbook.Sub AddOne() Workbooks.Add End SubA better way to create a workbook is to assign it to an object v
Last modified by Microsoft on 8/19/2009 11:29:56 PM
Tags:  create  excel  vb  wbs
Data Access in Client and Middle-Tier ProgrammingWalkthrough: Creating a SQL Server Express DatabaseThis walkthrough creates a new SQL Server database file based on the Customers and Orders tables in the Northwind Sample database. This database file can then be used as a sample database for completing additional how-to and walkthrough pages in this Help system that reference local database files.D
Last modified by Microsoft on 2/2/2010 12:21:57 AM
Tags:  create  database  server  sql
Link doesn't actually tell you how to do it... (Creating and Modifying Identifier Columns)
To create a new identifier column on an existing table ALTER TABLE (Transact-SQL)
Last modified by Charles C Williams on 1/6/2010 8:56:41 PM
create login (How to: Create a SQL Server Login)
To create a SQL Server login that uses choose Windows Authentication (SQL Server Management Studio) In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.Right-click the Security folder, point to New, and then click Login.On the General page, enter the name of a Windows user in the Login name box. Select Windows Auth
Last modified by Shady ElAsra on 12/27/2009 6:19:02 AM
Tags:  create  login
How to add a local printer? (AddPrinterConnection method of the Win32_Printer class (Windows))
After a LOT OF search i found a .NET solution.The following example adds a printer to your system. Dim strPrinterName as String = "Isidoros Printer"Dim strComputer AsString = My.Computer.Name Dim objWMIService, objPrinter AsObjectobjWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") objPrinter = objWMIService.Get("Win32_Printe
Last modified by Isidoros on 11/7/2009 9:18:00 AM
Page view tracker