Al Programming

Free source code programming in C#, VB.Net, Java, SQL

Monday, September 17, 2012

WITH (SQL Server)

›
SQL Server > DML  > WITH Specifies a temporary named result set, known as a common table expression ( CTE ). This is derived from a ...
Friday, September 14, 2012

REPLACE (Transact-SQL)

›
SQL Server > Built-in Functions   > REPLACE Replaces a specified string value with another string value. REPLACE ( expression , p...
Friday, August 31, 2012

Height div to window height with scroll

›
Java >  Height div to window height with scroll <script type="text/javascript" language="javascript">     w...
Wednesday, August 22, 2012

SqlCommand, SqlParameter c#

›
C# > Data   >  SqlCommand &  SqlParameter   SqlCommand Represents a Transact-SQL statement or stored procedure to execute a...

Generate Method Stub

›
Visual Studio Generate Method Stub is an IntelliSense Automatic Code Generation feature that provides an easy way to have Visual Studio cr...
Saturday, August 18, 2012

SET NOCOUNT SQL Server

›
SQL Server  >   Transact-SQL  >  SET NOCOUNT             Stops the message indicating the number of rows affected by a Trans...

Trunc Date Only No Time SQL Server

›
SQL Server  >  Built-in Functions   >  CAST > Trunc Trunc date in SQL Server SELECT Cast ( GetDate () AS date ) Result...
‹
›
Home
View web version
Powered by Blogger.