اكواد سيكوال جديدة

كود بلغة HTML:

---

<a href="http://www.4shared.com/file/110353638/728e41be/A_tricky_ordering_problem.html" target=_blank>A tricky ordering problem.sql</a>
<a href="http://www.4shared.com/file/110353317/d6ccfc46/Age_Calculation_in_years.html" target=_blank>Age Calculation in years.sql</a>
<a href="http://www.4shared.com/file/110353808/533d3f77/Case-sensitive_replace_for_strings_on_case-insensitive_server.html" target=_blank>Case-sensitive replace for strings on case-insensitive server.sql</a>
<a href="http://www.4shared.com/file/110353511/3b2225c1/Case-Sensitive_search_on_case-insensitive_SQL_installation.html" target=_blank>Case-Sensitive search on case-insensitive SQL installation.sql</a>
<a href="http://www.4shared.com/file/110353653/b3063fb0/Changing_columns_to_rows_-_Example_2.html" target=_blank>Changing columns to rows - Example #2.sql</a>
<a href="http://www.4shared.com/file/110353568/dbf0ba2/Check_a_string_for_numeric_digits_only.html" target=_blank>Check a string for numeric digits only.sql</a>
<a href="http://www.4shared.com/file/110353352/c2cacdcd/CHECK_CONSTRAINT_for_verifying_IP_address_values_in_a_field.html" target=_blank>CHECK CONSTRAINT for verifying IP address values in a field.sql</a>
<a href="http://www.4shared.com/file/110353747/acb2a0df/Check_for_existence_of_an_OS_file.html" target=_blank>Check for existence of an OS file.sql</a>
<a href="http://www.4shared.com/file/110353862/e5b271ef/Check_for_existence_of_DB.html" target=_blank>Check for existence of DB.sql</a>
<a href="http://www.4shared.com/file/110353445/40fa7faa/Compare_Rows_in_tables_using_ISQL__temp_tables_only.html" target=_blank>Compare Rows in tables using ISQL &amp; temp tables only.sql</a>
<a href="http://www.4shared.com/file/110353557/b62d45f0/Concat_several_address_fields_together__example_.html" target=_blank>Concat several address fields together (example).sql</a>
<a href="http://www.4shared.com/file/110353482/722ba505/Concatenating_values_grouped_by_columns.html" target=_blank>Concatenating values grouped by columns.sql</a>
<a href="http://www.4shared.com/file/110353753/b2c45587/Conditional_Firing_of_Triggers.html" target=_blank>Conditional Firing of Triggers.sql</a>
<a href="http://www.4shared.com/file/110353453/b082ebde/Converting_TIMESTAMP_values_to_numeric.html" target=_blank>Converting TIMESTAMP values to numeric.sql</a>
<a href="http://www.4shared.com/file/110353308/5f68d096/Copy_Text_Data_from_one_column_to_another.html" target=_blank>Copy Text Data from one column to another.sql</a>
<a href="http://www.4shared.com/file/110353232/9552007c/Counting_lines_in_an_external_text_file_from_T-SQL.html" target=_blank>Counting lines in an external text file from T-SQL.sql</a>
<a href="http://www.4shared.com/file/110353584/9a8a6a07/Counting_ocurrences_of_a_pattern_in_text_data.html" target=_blank>Counting ocurrences of a pattern in text data.sql</a>
<a href="http://www.4shared.com/file/110353539/7cfcf71/Create_rows_from_columns_-_opposite_of_pivoting.html" target=_blank>Create rows from columns - opposite of pivoting.sql</a>
<a href="http://www.4shared.com/file/110353767/9e84c25d/Custom_Ranking_for_Search_conditions___Similar_to_Full-Text_Rank_column_.html" target=_blank>Custom Ranking for Search conditions ( Similar to Full-Text Rank column).sql</a>
<a href="http://www.4shared.com/file/110353391/f776d37b/Decode_powers_of_2.html" target=_blank>Decode powers of 2.sql</a>
<a href="http://www.4shared.com/file/110353573/8376e36b/Delete_all_but_the_two_latest_messages_for_each_user.html" target=_blank>Delete all but the two latest messages for each user.sql</a>
<a href="http://www.4shared.com/file/110353588/933c262c/Dissecting_datetime_value_storage_to_individual_dateparts.html" target=_blank>Dissecting datetime value storage to individual dateparts.sql</a>
<a href="http://www.4shared.com/file/110353605/27126ec0/Dynamic_execution_of_SP___This_method_is_not_well-known__.html" target=_blank>Dynamic execution of SP ( This method is not well-known ).sql</a>
<a href="http://www.4shared.com/file/110353839/f175c22/Elements_List_Problem.html" target=_blank>Elements List Problem.sql</a>
<a href="http://www.4shared.com/file/110353563/9a6dd22a/Example_for_encrypting_data_using_XOR.html" target=_blank>Example for encrypting data using XOR.sql</a>
<a href="http://www.4shared.com/file/110353536/9770d2e0/Example_that_demonstrates_how_to_manipulate_BLOB_data_using_T-SQL.html" target=_blank>Example that demonstrates how to manipulate BLOB data using T-SQL.sql</a>
<a href="http://www.4shared.com/file/110353593/1df5cee5/File_details_using_NT_commands__undocumented_SP.html" target=_blank>File details using NT commands &amp; undocumented SP.sql</a>
<a href="http://www.4shared.com/file/110353802/b3e8d669/Finding_average_of_top_3_scores_for_each_player.html" target=_blank>Finding average of top 3 scores for each player.sql</a>
<a href="http://www.4shared.com/file/110353601/207faad9/Finding_gaps_in_sequential_numbers.html" target=_blank>Finding gaps in sequential numbers.sql</a>
<a href="http://www.4shared.com/file/110353756/c2aea108/Flight_Itinerary_Problem.html" target=_blank>Flight Itinerary Problem.sql</a>
<a href="http://www.4shared.com/file/110353698/8861a934/Flight_Schedule_Ordering_problem.html" target=_blank>Flight Schedule Ordering problem.sql</a>
<a href="http://www.4shared.com/file/110353329/1a598282/For_getting_identity_column_using_CROSS_JOIN__sub-query_technique.html" target=_blank>For getting identity column using CROSS JOIN &amp; sub-query technique.sql</a>
<a href="http://www.4shared.com/file/110353293/18bad860/For_getting_max_date_or_record_with_NULL_values_in_a_group.html" target=_blank>For getting max date or record with NULL values in a group.sql</a>
<a href="http://www.4shared.com/file/110353337/e4fa9ec4/Formatting_int__decimal_values_with_commas.html" target=_blank>Formatting int &amp; decimal values with commas.sql</a>
<a href="http://www.4shared.com/file/110353831/1ccd410/Generate_combinations_of_data_from_2_tables__match_against_a_combinations_table.html" target=_blank>Generate combinations of data from 2 tables &amp; match against a combinations table.sql</a>
<a href="http://www.4shared.com/file/110353786/7700df45/Generate_combinations_of_data_from_columns_2.html" target=_blank>Generate combinations of data from columns #2.sql</a>
<a href="http://www.4shared.com/file/110353707/c8de65db/Generate_combinations_of_data_from_columns.html" target=_blank>Generate combinations of data from columns.sql</a>
<a href="http://www.4shared.com/file/110353771/6efc5629/Generate_sequence_numbers_based_on_a_particular_order_of_rows.html" target=_blank>Generate sequence numbers based on a particular order of rows.sql</a>
<a href="http://www.4shared.com/file/110353676/f15aa9bd/Generate_sequence_numbers_within_a_group_of_values.html" target=_blank>Generate sequence numbers within a group of values.sql</a>
<a href="http://www.4shared.com/file/110353714/48cc0520/Generating_duplicates_of_existing_rows.html" target=_blank>Generating duplicates of existing rows.sql</a>
<a href="http://www.4shared.com/file/110353397/1e15764e/Generating_unique_values_or_ids_for_rows_in_SELECT_statement.html" target=_blank>Generating unique values or ids for rows in SELECT statement.sql</a>
<a href="http://www.4shared.com/file/110353648/3dcfd779/Generic_logic_to_search__replace_characters_in_a_string.html" target=_blank>Generic logic to search &amp; replace characters in a string.sql</a>
<a href="http://www.4shared.com/file/110353816/ad9e2331/Get_data_for_a_given_Anniversary_date__Year.html" target=_blank>Get data for a given Anniversary date &amp; Year.sql</a>
<a href="http://www.4shared.com/file/110353300/51b358a4/Get_MondayDate_given_a_date_-_assuming_sunday_is_the_first_day_of_the_week.html" target=_blank>Get MondayDate given a date - assuming sunday is the first day of the week.sql</a>
<a href="http://www.4shared.com/file/110353612/a06dca22/Get_only_one_matching_row_for_each_name_from_several_address_rows.html" target=_blank>Get only one matching row for each name from several address rows.sql</a>
<a href="http://www.4shared.com/file/110353341/42d8ad36/Getting_only_a_header_value_for_a_column__with_duplicates__kinda_like_a_header.html" target=_blank>Getting only a header value for a column (with duplicates) kinda like a header.sql</a>
<a href="http://www.4shared.com/file/110353775/69919230/Getting_the_second_recent_date_from_a_set_of_values.html" target=_blank>Getting the second recent date from a set of values.sql</a>
<a href="http://www.4shared.com/file/110353477/85d94d45/Greatest_Circle_Distance_Calculation_with_a_simple_UPDATE_loop.html" target=_blank>Greatest Circle Distance Calculation with a simple UPDATE loop.sql</a>
<a href="http://www.4shared.com/file/110353521/100f7602/How_to_add_hhmm_formatted_time_values_and_get_output_as_hhmm.html" target=_blank>How to add hh,mm formatted time values and get output as hh,mm.sql</a>
<a href="http://www.4shared.com/file/110353334/7df3cf7e/How_to_determine_the_type_of_DML_operation_in_a_multi-statement_trigger.html" target=_blank>How to determine the type of DML operation in a multi-statement trigger.sql</a>
<a href="http://www.4shared.com/file/110353820/6fd0d5c7/How_to_form_effective_date_only_search_condition.html" target=_blank>How to form effective date only search condition.sql</a>
<a href="http://www.4shared.com/file/110353827/f1b44064/How_to_get_NT_Accounts_from_DOMAIN.html" target=_blank>How to get NT Accounts from DOMAIN.sql</a>
<a href="http://www.4shared.com/file/110353488/92fe4c1b/How_to_pass_a_list_of_IDs__simulate_an_IN_clause.html" target=_blank>How to pass a list of IDs &amp; simulate an IN clause.sql</a>
<a href="http://www.4shared.com/file/110353525/1762b21b/How_to_simulate_arrays_in_T-SQL_using_a_temporary_table.html" target=_blank>How to simulate arrays in T-SQL using a temporary table.sql</a>
<a href="http://www.4shared.com/file/110353734/7afa67a2/Int_to_hexadecimal_string_conversion_using_SELECT_statement.html" target=_blank>Int to hexadecimal string conversion using SELECT statement.sql</a>
<a href="http://www.4shared.com/file/110353473/82b4895c/KILL_all_for_DB.html" target=_blank>KILL all for DB.sql</a>
<a href="http://www.4shared.com/file/110353621/1249c85b/Maximum_Value_from_5_columns.html" target=_blank>Maximum Value from 5 columns.sql</a>
<a href="http://www.4shared.com/file/110353544/363f250b/Merge_several_varbinary_data_into_a_single_image_field_like_doing_a_string_concatenation.html" target=_blank>Merge several varbinary data into a single image field like doing a string concatenation.sql</a>
<a href="http://www.4shared.com/file/110353546/d8314427/Methods_to_form_complex_strings_for_dynamic_SQL_execution.html" target=_blank>Methods to form complex strings for dynamic SQL execution.sql</a>
<a href="http://www.4shared.com/file/110353404/53918a38/Min_of_columns.html" target=_blank>Min of columns.sql</a>
<a href="http://www.4shared.com/file/110353740/32d6357c/Minimum_value_from_4_variables_-_datetime_example.html" target=_blank>Minimum value from 4 variables - datetime example.sql</a>
<a href="http://www.4shared.com/file/110353411/3ae04ff6/Modulus_of_Floating_Point_Numbers.html" target=_blank>Modulus of Floating Point Numbers.sql</a>
<a href="http://www.4shared.com/file/110353843/a08323fb/Moving_Average_Example_1.html" target=_blank>Moving Average Example #1.sql</a>
<a href="http://www.4shared.com/file/110353627/fb2a6d6e/Number_of_days_between_a_given_date__3rd_sunday_of_current_month.html" target=_blank>Number of days between a given date &amp; 3rd sunday of current month.sql</a>
<a href="http://www.4shared.com/file/110353235/b3695df/number_of_days_in_month.html" target=_blank>number of days in month.sql</a>
<a href="http://www.4shared.com/file/110353359/55181445/Numeric_precision_example_that_shows_-0000_value.html" target=_blank>Numeric precision example that shows -.0000 value.sql</a>
<a href="http://www.4shared.com/file/110353464/5cb2dbe/One_single_big_IF_check_to_make_sure_the_IP_address_specified_in_a_char_field_is_OK.html" target=_blank>One single big IF check to make sure the IP address specified in a char field is OK.sql</a>
<a href="http://www.4shared.com/file/110353689/e67da8e3/Ordering_rows_randomly_based_on_the_identity_column_value.html" target=_blank>Ordering rows randomly based on the identity column value.sql</a>
<a href="http://www.4shared.com/file/110353496/6c5d505d/Perform_a_DISTINCT_query_of_tables_with_BLOB_fields.html" target=_blank>Perform a DISTINCT query of tables with BLOB fields.sql</a>
<a href="http://www.4shared.com/file/110353717/d1c5549a/Pivot_Table_Example_2.html" target=_blank>Pivot Table Example #2.sql</a>
<a href="http://www.4shared.com/file/110353720/648c92fa/Pivot_Table_Example_3.html" target=_blank>Pivot Table Example #3.sql</a>
<a href="http://www.4shared.com/file/110353415/3d8d8bef/Pivot_table_example_-_solution_1.html" target=_blank>Pivot table example - solution 1.sql</a>
<a href="http://www.4shared.com/file/110353286/71cb1dae/Pivot_Table_Example.html" target=_blank>Pivot Table Example.sql</a>
<a href="http://www.4shared.com/file/110353726/8def37cf/Previous__Current_Salary_calculation_for_Employees.html" target=_blank>Previous &amp; Current Salary calculation for Employees.sql</a>
<a href="http://www.4shared.com/file/110353363/9ee0ae98/Product_of_values_in_a_column.html" target=_blank>Product of values in a column.sql</a>
<a href="http://www.4shared.com/file/110353501/22391480/Programmatically_determine_which_table_a_trigger_was_called_from.html" target=_blank>Programmatically determine which table a trigger was called from.sql</a>
<a href="http://www.4shared.com/file/110353421/11cd1c35/Query_to_show_the_NOT_IN_problem_when_there_are_NULL_rows_in_the_IN_clause__MAIN_table.html" target=_blank>Query to show the NOT IN problem when there are NULL rows in the IN clause &amp; MAIN table.sql</a>
<a href="http://www.4shared.com/file/110353466/ebc54c92/Ranking_from_highest_within_each_group.html" target=_blank>Ranking from highest within each group.sql</a>
<a href="http://www.4shared.com/file/110353366/ee8a5a17/Recipe_Query_Example_-_Get_Recipes_for_given_ingredients.html" target=_blank>Recipe Query Example - Get Recipes for given ingredients.sql</a>
<a href="http://www.4shared.com/file/110353457/b7ef2fc7/Resequencing_values_in_an_indexed_field.html" target=_blank>Resequencing values in an indexed field.sql</a>
<a href="http://www.4shared.com/file/110353344/32b259b9/Retrieve_Individual_Octets_from_an_IP_address.html" target=_blank>Retrieve Individual Octets from an IP address.sql</a>
<a href="http://www.4shared.com/file/110353371/69f5fef5/Retrieving_records_based_on_a_range_or_number.html" target=_blank>Retrieving records based on a range or number.sql</a>
<a href="http://www.4shared.com/file/110353424/61a7e8ba/Rolling_up_trick1.html" target=_blank>Rolling up trick#1.sql</a>
<a href="http://www.4shared.com/file/110353616/a7000e3b/Sample_for_how_to_send_progress_info_from_long_running_sps.html" target=_blank>Sample for how to send progress info from long running sps.sql</a>
<a href="http://www.4shared.com/file/110353779/6027de1b/Search_for_combination_of_column_values_in_different_rows.html" target=_blank>Search for combination of column values in different rows.sql</a>
<a href="http://www.4shared.com/file/110353378/10294651/Searching_for_strings_withing_TAGS.html" target=_blank>Searching for strings withing TAGS.sql</a>
<a href="http://www.4shared.com/file/110353250/2d06c6d6/SELECTING_5_integer_variables_as_an_INT_column.html" target=_blank>SELECTING 5 integer variables as an INT column.sql</a>
<a href="http://www.4shared.com/file/110353244/3370338e/Solution_to_February_Reader_Challenge_of_SQLMAG.html" target=_blank>Solution to February Reader Challenge of SQLMAG.sql</a>
<a href="http://www.4shared.com/file/110353451/5e8c8af2/Some_CHECK_constraint_example_using_datetime_fields.html" target=_blank>Some CHECK constraint example using datetime fields.sql</a>
<a href="http://www.4shared.com/file/110353598/8a27176d/Sorting_only_based_on_the_numeric_digits_in_a_column_containing_alpha-numeric_values_of_the_form_nnnXXX.html" target=_blank>Sorting only based on the numeric digits in a column containing alpha-numeric values of the form nnnXXX.sql</a>
<a href="http://www.4shared.com/file/110353682/71af716b/Split_a_character_value_in_a_column_into_several_fixed_length_values.html" target=_blank>Split a character value in a column into several fixed length values.sql</a>
<a href="http://www.4shared.com/file/110353665/7148c946/Statistical_Mode_Calculation.html" target=_blank>Statistical Mode Calculation.sql</a>
<a href="http://www.4shared.com/file/110353811/33fab692/Storing_date__time_values_separately.html" target=_blank>Storing date &amp; time values separately.sql</a>
<a href="http://www.4shared.com/file/110353791/f07f7ba7/Strip_dirty_characters_from_a_numeric_string.html" target=_blank>Strip dirty characters from a numeric string.sql</a>
<a href="http://www.4shared.com/file/110353578/14a43ae3/Strip_the_tags_out_of_a_HTML_string.html" target=_blank>Strip the tags out of a HTML string.sql</a>
<a href="http://www.4shared.com/file/110353845/49e086ce/Stripping_Email_Address_from_a_text_or_character_value.html" target=_blank>Stripping Email Address from a text or character value.sql</a>
<a href="http://www.4shared.com/file/110353642/dd1a3e67/Stripping_individual_values_from_a_comma-separated_string_using_SELECT_statement_only.html" target=_blank>Stripping individual values from a comma-separated string using SELECT statement only.sql</a>
<a href="http://www.4shared.com/file/110353515/3c4fe1d8/Stripping_money_value_from_a_string_with_non-numeric_data.html" target=_blank>Stripping money value from a string with non-numeric data.sql</a>
<a href="http://www.4shared.com/file/110353729/1d502a5e/Summary_Total_Generation_using_ROLLUP.html" target=_blank>Summary Total Generation using ROLLUP.sql</a>
<a href="http://www.4shared.com/file/110353433/e6d84c58/Table_that_uses_a_custom_time_field__varchar___checks_validity_of_the_datetime_value.html" target=_blank>Table that uses a custom time field (varchar) &amp; checks validity of the datetime value.sql</a>
<a href="http://www.4shared.com/file/110353854/27fc8719/Team_Placement_in_a_League.html" target=_blank>Team Placement in a League.sql</a>
<a href="http://www.4shared.com/file/110353429/1f169407/Text_fields_stripping_into_varchar_variables.html" target=_blank>Text fields stripping into varchar variables.sql</a>
<a href="http://www.4shared.com/file/110353798/89a3c303/Topic__Seminars__Registrants_aggregation_problem.html" target=_blank>Topic , Seminars &amp; Registrants aggregation problem.sql</a>
<a href="http://www.4shared.com/file/110353505/2554d099/Transfer_BLOB_fields_from_one_server_to_another.html" target=_blank>Transfer BLOB fields from one server to another.sql</a>
<a href="http://www.4shared.com/file/110353437/e1b58841/Transistor_data_transposing_problem.html" target=_blank>Transistor data transposing problem.sql</a>
<a href="http://www.4shared.com/file/110353385/e9002623/Transposing_columns_as_fields.html" target=_blank>Transposing columns as fields.sql</a>
<a href="http://www.4shared.com/file/110353551/5f4ee0c5/Tricks_using_a_numbers_table.html" target=_blank>Tricks using a numbers table.sql</a>
<a href="http://www.4shared.com/file/110353278/11eb2c66/Variant_data_type_storage.html" target=_blank>Variant data type storage.sql</a>
<a href="http://www.4shared.com/file/110353687/1c585e4/Wrong_usage_of_UPDATE_FROM_clause.html" target=_blank>Wrong usage of UPDATE FROM clause.sql</a>

---

بارك اللة فيكم وانا سعيدة بانضمامى للمنتدى