KILL all for DB.sql
Maximum Value from 5 columns.sql
Merge several varbinary data into a single image field like doing a string concatenation.sql
Methods to form complex strings for dynamic SQL execution.sql
Min of columns.sql
Minimum value from 4 variables - datetime example.sql
Modulus of Floating Point Numbers.sql
Moving Average Example #1.sql
Number of days between a given date & 3rd sunday of current month.sql
number of days in month.sql
Numeric precision example that shows -.0000 value.sql
One single big IF check to make sure the IP address specified in a char field is OK.sql
Ordering rows randomly based on the identity column value.sql
Perform a DISTINCT query of tables with BLOB fields.sql
Pivot Table Example #2.sql
Pivot Table Example #3.sql
Pivot table example - solution 1.sql
Pivot Table Example.sql
Previous & Current Salary calculation for Employees.sql
Product of values in a column.sql
Programmatically determine which table a trigger was called from.sql
Query to show the NOT IN problem when there are NULL rows in the IN clause & MAIN table.sql
Ranking from highest within each group.sql
Recipe Query Example - Get Recipes for given ingredients.sql
Resequencing values in an indexed field.sql
Retrieve Individual Octets from an IP address.sql
Retrieving records based on a range or number.sql
Rolling up trick#1.sql
Sample for how to send progress info from long running sps.sql
Search for combination of column values in different rows.sql
Searching for strings withing TAGS.sql
SELECTING 5 integer variables as an INT column.sql
Solution to February Reader Challenge of SQLMAG.sql
Some CHECK constraint example using datetime fields.sql
Sorting only based on the numeric digits in a column containing alpha-numeric values of the form nnnXXX.sql
Split a character value in a column into several fixed length values.sql
Statistical Mode Calculation.sql
Storing date & time values separately.sql
Strip dirty characters from a numeric string.sql
Strip the tags out of a HTML string.sql
Stripping Email Address from a text or character value.sql
Stripping individual values from a comma-separated string using SELECT statement only.sql
Stripping money value from a string with non-numeric data.sql
Summary Total Generation using ROLLUP.sql
Table that uses a custom time field (varchar) & checks validity of the datetime value.sql
Team Placement in a League.sql
Text fields stripping into varchar variables.sql
Topic , Seminars & Registrants aggregation problem.sql
Transfer BLOB fields from one server to another.sql
Transistor data transposing problem.sql
Transposing columns as fields.sql
Tricks using a numbers table.sql
Variant data type storage.sql
Wrong usage of UPDATE FROM clause.sql
Maximum Value from 5 columns.sql
Merge several varbinary data into a single image field like doing a string concatenation.sql
Methods to form complex strings for dynamic SQL execution.sql
Min of columns.sql
Minimum value from 4 variables - datetime example.sql
Modulus of Floating Point Numbers.sql
Moving Average Example #1.sql
Number of days between a given date & 3rd sunday of current month.sql
number of days in month.sql
Numeric precision example that shows -.0000 value.sql
One single big IF check to make sure the IP address specified in a char field is OK.sql
Ordering rows randomly based on the identity column value.sql
Perform a DISTINCT query of tables with BLOB fields.sql
Pivot Table Example #2.sql
Pivot Table Example #3.sql
Pivot table example - solution 1.sql
Pivot Table Example.sql
Previous & Current Salary calculation for Employees.sql
Product of values in a column.sql
Programmatically determine which table a trigger was called from.sql
Query to show the NOT IN problem when there are NULL rows in the IN clause & MAIN table.sql
Ranking from highest within each group.sql
Recipe Query Example - Get Recipes for given ingredients.sql
Resequencing values in an indexed field.sql
Retrieve Individual Octets from an IP address.sql
Retrieving records based on a range or number.sql
Rolling up trick#1.sql
Sample for how to send progress info from long running sps.sql
Search for combination of column values in different rows.sql
Searching for strings withing TAGS.sql
SELECTING 5 integer variables as an INT column.sql
Solution to February Reader Challenge of SQLMAG.sql
Some CHECK constraint example using datetime fields.sql
Sorting only based on the numeric digits in a column containing alpha-numeric values of the form nnnXXX.sql
Split a character value in a column into several fixed length values.sql
Statistical Mode Calculation.sql
Storing date & time values separately.sql
Strip dirty characters from a numeric string.sql
Strip the tags out of a HTML string.sql
Stripping Email Address from a text or character value.sql
Stripping individual values from a comma-separated string using SELECT statement only.sql
Stripping money value from a string with non-numeric data.sql
Summary Total Generation using ROLLUP.sql
Table that uses a custom time field (varchar) & checks validity of the datetime value.sql
Team Placement in a League.sql
Text fields stripping into varchar variables.sql
Topic , Seminars & Registrants aggregation problem.sql
Transfer BLOB fields from one server to another.sql
Transistor data transposing problem.sql
Transposing columns as fields.sql
Tricks using a numbers table.sql
Variant data type storage.sql
Wrong usage of UPDATE FROM clause.sql
الثلاثاء مارس 13, 2012 3:39 pm من طرف Admin
» An Introduction to VBA in Excel
السبت مارس 10, 2012 1:03 pm من طرف Admin
» المهرجان الخيرى الثالث لجمعية مصريين
الخميس مارس 08, 2012 1:47 pm من طرف Admin
» هندسة الشبكات
الأربعاء مارس 07, 2012 7:59 pm من طرف Admin
» ﺎﻬﺗﺎﻘﻴﺒﻄﺗﻭ ﺔﻴﻜﻠﺳﻼﻟﺍ ﺕﺎﻜﺒﺸﻟﺍ
الأربعاء مارس 07, 2012 7:14 pm من طرف Admin
» تعلم الـ JavaScript ( أساسيات كتابة الكود )
الأحد فبراير 12, 2012 3:10 pm من طرف Admin
» مكتبة الأكواد والحلول البرمجية , سوف نخصص هذا الجزء لوضع اي كود يسهل الوصول إلى عملية معينة , كما تستطيع شرح اي خاصية يمكن ان تستخدم للقيام بوظيفة معينة .
الأربعاء فبراير 08, 2012 2:38 pm من طرف Admin
» مجموعة أكواد للغة السي شارب c#
الأربعاء فبراير 08, 2012 2:28 pm من طرف Admin
» شرح عمل تصويت بتقنية AJAX.pdf
الإثنين فبراير 06, 2012 9:17 pm من طرف Admin