Alternatura - Software Development Articles and Tips
WEB BASED DEVELOPMENT
(INTRANET/EXTRANET/INTERNET) TECHNOLOGIES |
HTML "PRE-PROCESSORS" TECHNOLOGIES (ASP, PHP, etc): GENERALITIES
|
HTML/DHTML
|
JavaScript
|
HTTP Protocol
|
TCP/IP Protocol
|
XML
- A concise but overall XML Tutorial to the main concepts with real examples (by W3 Schools)
|
ASP.NET
|
ASP & VBScript
|
ADO
|
ColdFusion
|
PHP
|
MACROMEDIA FLASH & ActionScript
|
Scalable Vector Graphics (SVG)
(Drawing vector graphics on the fly with XML)
|
SQL
- Creating a Developing Environment for MS SQL Server (by Roberto Miglietti for Alternatura)
- MS SQL Server: Transact-SQL Reference by MS
- MS SQL Server: SQL multiple condition (
CASE...WHEN...ELSE ) by MS
- MS SQL Server: Type convertion functions (
CAST and CONVERT ) by MS
- T-SQL looping:
WHILE
- Fundamentals of store procedures
- T-SQL table copy and copy-structure
- Copy data and structure
- Copy structure (bulk-copy)
- Cross-Tabs/Pivot views or table transpositions in MS SQL Server
- Static cross-Tabs/Pivot tables using GROUP and CASE, the traditional way but not generic
- Dynamic cross-Tabs/Pivot tables using store procedures
The store procedure has parameters as follows
EXECUTE crosstab SELECT statement, summary calculation, pivot column, table name
- More dynamic pivot/cross-tab tables solutions
Using the sp
- Cross-tabs in MS SQL Server 2005:
PIVOT and UNPIVOT
- Tips
- Concatenation and NULLs (more...)
When concatenating in T-SQL (SELECT FirstName + LastName AS [User Name] FROM Users ), if any of the concatenated fields is NULL the whole concatenation will be NULL.
To avoid this, first get rid of the potential NULL value for all fields using the COALESCE() function:
SELECT COALESCE(FirstName,'') + COALESCE(LastName,'') AS [User Name] FROM Users
- Query pagination methods with ADO, arrays and stored procedures
- Statistics in SQL, good chapter 8 from the Transact-SQL Cookbook
|
SSI (Server Side Includes) - SSI (Inclusión del Lado del Servidor)
|
1
Regular Expressions
|
Accesibility
|
RSS
|
Back to parent link |
|