SonghaySystem(::)

 

The Funky Knowledgebase: SQL and Database Management Systems

2008-08-19 SQL Server Express: “SQL Server Express and Hosting”
2008-05-12 Microsoft SQL Server 2005/2000 Compatibility Problem: SQL 2005 CREATE TABLE Syntax Fails in SQL 2000
2008-01-15 SQL Server 2005 t-SQL: The Use of the nodes() Method for SQL Types; Converting XML Data into SQL Types
2007-12-28 SQL Server 2000: DTS; “Package Ownership Issues”; http://www.sqldts.com/212.aspx
2007-12-22 SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; XML Data Modification Language (DML)
2007-12-22 SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; replace value of; XML Data Modification Language (DML)
2007-12-22 SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert element; XML Data Modification Language (DML)
2007-12-22 SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; delete; XML Data Modification Language (DML)
2007-12-22 SQL Server 2005 t-SQL: The Use of the nodes() Method for XML Types
2007-12-11 SQL Server 2005 t-SQL: Flippant Remarks about Using XPath Assertions Instead of XML Schema
2007-12-10 SQL Server 2005 t-SQL: Basic XQuery Example
2007-11-19 T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0/2000; Command Names Pattern
2007-11-19 T-SQL: Stored Procedure Structure for Microsoft SQL Server 6.5
2007-11-19 T-SQL Code: Example of Connecting to Index Server and Listing Files in Scope
2007-11-19 SQL: When to Use Dynamic SQL and When to Use Stored Procedures; Views and SELECT Stored Procedures
2007-11-19 T-SQL Code: Stored Procedure AutoDTS_complianceDumps; An Example of Running a DTS Package in tSQL
2007-11-19 T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0
2007-11-07 SQL Server 2005: Flippant Remarks about the New FOR XML PATH() Syntax
2007-09-17 SQL Server 2005 t-SQL: Linking an Orphaned Database User to a Server Login
2007-04-04 T-SQL Code: A Function for Checking for the Existence of an Object; fItemExists()
2007-03-19 T-SQL: User-Defined Function Structure; Table/Set Form
2007-03-19 T-SQL: User-Defined Function Structure; Scalar Form
2007-01-16 SQL Server 2005 PROBLEM: Using the ADO.NET DbCommand.ExecuteScalar() Method Truncates at 2033 Characters
2006-10-20 SQL Server 2005 t-SQL: Bulk Insert Operation
2006-07-12 SQL Server 2000: CONVERT() Style Identifiers
2006-01-14 SQL Server 2000: UTC datetime values; GETUTCDATE()
2006-01-14 T-SQL Code: Date Format User-Defined Function; dbo.fDateFormat()
2005-09-16 SQL Server 2000: Flippant Remarks about Mixed Mode; Security; Authentication
2005-09-15 DTS ActiveX Script Task: Assigning SQL Statements to Execute SQL Tasks Based on Global Variables
2005-05-06 tSQL Code: Example of OPENROWSET with Trusted Connection; NTLM
2005-04-28 SQL Server 2000: Flippant Remarks about Renaming Databases
2005-03-27 T-SQL Code: Adding/Refreshing Login and User Metadata; CreateUsers.sql; Troubleshooting Orphaned Users
2004-11-23 SQL Server 2000 Data Transformation Services; Flippant Remarks about the DTS Data Driven Query Task; Updating Data with DTS
2004-10-16 MySQL Adminstration: mysqldump Help Text;mysqldump Ver 9.11 Distrib 4.0.21; Win95/Win98 (i32); Igor Romanenko, Monty, Jani & Sinisa
2004-08-31 DTS: Fixed-Role Permissions for Logins to Change Data in SQL Server 2000; Data Transformation Services; db_ddladmin
2004-04-29 T-SQL Syntax: The LIKE Operator with Bracket Wildcard Operators ([]); Using Wildcard Characters as Literals
2003-12-04 DTS ActiveX Script Task: Formatting an Apache Log File; Visual Basic ActiveX Script; Data Transformation Services
2003-08-11 T-SQL Code: Correlated Sub-Queries in the SELECT Projection List
2002-05-31 T-SQL: Flippant Remarks about Table Aliases and the Self Join
2002-01-15 SQL Server 2000: Flippant Remarks about Designing for Portability
2002-01-05 MS SQL Server 7.x: Tables sysxlogins and sysservers
2002-01-05 MS SQL Server 7.x: When to Use Views; Normalized Data
2001-05-26 T-SQL: Dynamic SQL in a Stored Procedure; sp_executesql
2001-05-26 T-SQL: Using OPENROWSET to Join Server Data with File-based Data
2001-04-07 SQL Server 7.x and VB 6.x Code: Manipulating Data Transformation Services (DTS) Programmatically
2001-04-07 T-SQL Code: DELETEing Duplicates
2001-03-31 T-SQL Code: Searching for a Finite Set of Unknowns with a Single SELECT Statement; the ISNULL() Function
2001-03-04 T-SQL Code: Example of the use of a Cursor; Parsing WebCom Hit Log Files; NewHitLog
2001-03-04 T-SQL Code: Another Example of the use of a Cursor; Parsing WebCom Hit Log Files; GetHitsImport
2000-12-24 T-SQL: Renaming a Table Containing Data; Saving/Restoring Data from a Dropped Table; SELECT INTO
2000-12-24 SQL: SELECTing Duplicates
2000-12-24 PL/SQL: Oracle 7; Date Arithmetic with SYSDATE
2000-12-24 SQL: The Differences Beteween HAVING and WHERE
2000-12-24 T-SQL Code: A Procedure Using CASE Structures to Format Times
2000-12-24 SQL: The Difference between UNION and UNION ALL
2000-12-24 SQL: Domain Aggregate Record Sets Are Not Updatable
2000-12-24 Denormalization; SQL 7.x OLAP and Data Cubes
2000-12-24 SQL: AND and OR Operate on True, False and Null
2000-11-04 From SQL Server 7 to Oracle 7: Remarks
2000-02-02 ODBC SQL: The Syntax for Stored Procedure Execution
1999-08-15 T-SQL: Implicit Descision Structures Using substring(), sign() and charindex(); the Sybase isnull() System Function
1999-08-11 T-SQL: Notes on the Outer Join
1999-02-09 T-SQL: Values Stored in Sybase/Microsoft Sysobjects Table
1999-02-09 MS-SQL and T-SQL: Deleting Records Not in Another Table
1999-02-09 T-SQL: DELETEing Rows Based on a Date Column; Use of DATEADD() And GETDATE()
1999-02-09 T-SQL: Measuring How Long a Query Takes
1999-02-02 Notes on SQL Server Standards and Guidelines
1999-01-06 MS SQL Server 6.5: ISQL/w Can Connect to Sybase Databases
0201616386_0764597922
Copyright© 2008 by Bryan D. Wilhite All rights reserved. No part of this material may be used or reproduced in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher except in the case of brief quotations embodied in critical articles and reviews. Making copies of any part of this material for any purpose other than your own personal use is a violation of United States copyright laws.

The information provided by Bryan D. Wilhite at kintespace.com is provided “as is” without warranty of any kind. In no event shall Bryan D. Wilhite or any of his affiliates be liable for any damages whatsoever including, but not limited to, direct, indirect, incidental, consequential, loss of business profits or special damages due to material published by Bryan D. Wilhite or any of his affiliates.