Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Monday, March 25, 2013
this C#
›
C > Keywords > This Refers to the current instance of the class. Example 1.This is used to qualify the FirstName and LastNam...
Thursday, March 21, 2013
Insert values and create a temporary table from a dynamic query SQL Server
›
SQL Server > Scripts > Insert dynamic temp table Global temporary tables are visible to any user and any connection after they are...
Modulo operator SQL Server
›
SQL Server > Operators > Modulo Modulo operator (%) Returns the remainder of one number divided by another Example: SELECT ...
DATALENGTH SQL Server
›
SQL Server > Built-In Functions > DATALENGTH Returns the number of bytes used to represent any expression Example: IF EXISTS( SE...
Replicate SQL Server
›
SQL Server > Built-In Functions > REPLICATE Repeats a string with specified number of times. Example: SELECT REPLICATE ( ...
STUFF function SQL Server
›
SQL Server > Built-in Functions > STUFF STUFF inserts a string into another string STUFF ( expression , start , length , replac...
Wednesday, March 20, 2013
EXCEPT and INTERSECT SQL Server
›
SQL Server > Operators > EXCEPT AND INTERSECT EXCEPT returns any distinct rows from the left query that are not also found on the...
‹
›
Home
View web version