You are here
Home > Posts tagged "Software Development"

MS SQL Server Cheatsheet

Reseeding a table identity in MS SQL Server DBCC CHECKIDENT (tablename, RESEED, new_reseed_value) Truncate Table truncate tablename Check Log size of all database DBCC SQLPERF(LOGSPACE);   Connection String Standard Security: 1. Server=ServerNameOrIpAddress;Database=DatabaseName;User Id=Username; Password=Password; Trusted Connection: 2. Server=ServerNameOrIpAddress;Database=DatabaseName;Trusted_Connection=True; Connection to a SQL Server instance: 1. Server=ServerNameOrIpAddress\InstanceName;Database=DatabaseName;User Id=myUsername;Password=Password; Trusted Connection from a CE device: 1. Data Source=ServerNameOrIpAddress;Initial Catalog=DatabaseName;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=Password; Connect via an IP address: 1. Data

PHP Cheatsheet

PHP is a server scripting language, and a powerful tool for making dynamic and interactive Web pages. PHP is a widely-used, free, and efficient alternative to competitors such as Microsoft's ASP. from w3schools Example of several ways of Loop Foreach Loop: foreach ($array as $value) { code to be executed; } example: foreach($ArrayOfObject as $object) { } For Loop: for (initialization;