http://www.c-sharpcorner.com/articles/Watch latest articles from SQL© 1999 - 2012 Mindcracker LLC. All Rights ReservedExtended Properties in SQL Server allows us to create additional customized properties to store additional information. Extended Properties are a way to create a self-documenting database.http://www.c-sharpcorner.com/UploadFile/ff2f08/extended-properties-in-sql-server/6/12/2013 5:52:04 AMJignesh TrivediThe article explains some nice data retreving techniques including Derived Tables and CTE.http://www.c-sharpcorner.com/UploadFile/6897bc/some-nice-select-query-techniques-for-db-programmers/5/15/2013 11:18:09 PMSivaraman DhamodaranHow to use a database to find nearby locations.http://www.c-sharpcorner.com/UploadFile/afenster/how-to-find-a-doctor-near-your-home-in-sql-server/6/7/2013 4:10:14 AMAndrew FensterIn this article I describe the Transact-SQL security functions SUSER_ID, SUSER_NAME, SESSION_USER and SESSIONPROPERTY.http://www.c-sharpcorner.com/UploadFile/5089e0/sql-security-functions-part-3/6/3/2013 11:26:29 AMNitin BhardwajIn this article we have a look at how to enable line numbers in the SQL Server Query Window.http://www.c-sharpcorner.com/UploadFile/rohatash/display-line-numbers-in-sql-server-query-window/5/31/2013 2:22:04 AMRohatash KumarIn this article you will learn about Complex SQL queries with the split() function in SQL 2008.http://www.c-sharpcorner.com/UploadFile/8911c4/complex-sql-queries-with-split-function-in-sql-2008/5/23/2013 6:45:30 AMMahesh AlleObjectContext and DbContext has capability to querying and working with data as objects.http://www.c-sharpcorner.com/UploadFile/ff2f08/objectcontext-vs-dbcontext/5/22/2013 9:59:48 AMJignesh TrivediIn this article you will learn how to use SQL Profiler and database Tuning Advisor to improve the performance of a database.http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-use-sql-server-profiler-and-tuning-advisor/5/21/2013 7:03:27 AMRaj KumarIn this article, I will demonstrate how can we call stored procedure from entity framework? There are many different way to call stored procedure from entity framework. http://www.c-sharpcorner.com/UploadFile/ff2f08/call-store-procedure-from-entity-framework/5/21/2013 6:38:59 AMJignesh TrivediIn this article you will learn how to create a report in SSRS 2008.http://www.c-sharpcorner.com/UploadFile/47fc0a/create-a-report-in-ssrs-2008/5/20/2013 7:27:57 AMSurjeet YadavIn this article you will learn about Join statements of SQL server.http://www.c-sharpcorner.com/UploadFile/47fc0a/explain-sql-joins/5/19/2013 8:19:09 AMSurjeet YadavIn this article we will create symmetric key and encrypt and decrypt string using this key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-5/5/16/2013 6:05:53 AMAkshay PatelHere I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.http://www.c-sharpcorner.com/UploadFile/0f68f2/finding-duplicates-among-multiple-columns-in-sql/5/15/2013 5:26:55 AMHemant SrivastavaIn this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/5/14/2013 11:43:00 PMRaj KumarSQL server Extended event is nothing but event handling system for server system. http://www.c-sharpcorner.com/UploadFile/ff2f08/extended-event-in-sql-server/5/14/2013 9:55:43 AMJignesh TrivediIn this article we will encrypt plain text and decrypt encrypted text using asymmetric key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-4/5/14/2013 4:52:38 AMAkshay PatelIn this article you will learn how to use a Temporary Table in SQL Server.http://www.c-sharpcorner.com/UploadFile/8911c4/temporary-table-in-sql-server/5/13/2013 11:03:16 AMMahesh AlleIn this article we will generate certificate and using this certificate we will encrypt and decrypt the string.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-3/5/12/2013 4:52:57 AMAkshay PatelIn this article we will discuss how get the port no of our own SQL Server instance and how to use that port in SQL Server setting and at the end how use that port in your C Sharp application.http://www.c-sharpcorner.com/UploadFile/e881fb/secured-connection-between-sql-server-and-C-Sharp-using-specific/5/10/2013 4:53:40 AMNaveed ZamanIn this article we will discuss Database Master Key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-2/5/8/2013 4:08:38 AMAkshay PatelIn this article we will discuss Service Master Key, backup, restore and alter Service Master Key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-1/5/6/2013 5:08:55 AMAkshay PatelI encountered a problem today and thought to share with all of you so that in the future, if you confront such an issue then this article may help you.http://www.c-sharpcorner.com/UploadFile/97fc7a/the-database-principal-owns-a-schema-in-the-database-and-ca/5/6/2013 12:37:58 AMSachin KaliaHere you will learn how to create a Job Task in SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/0fca19/step-by-step-procedure-to-create-a-job-task-in-sql-server-20/5/6/2013 12:16:02 AMPankaj PandeyThis article looks at SQL Server string, numeric and date functions and their Oracle equivalents.http://www.c-sharpcorner.com/UploadFile/c5c6e2/sql-server-functions-and-oracle-equivalent/5/4/2013 12:25:20 PMShankar MIn this article we create a database in SQL Server 2008 and install ASP.NET membership services then install an ASP.NET Memberships Services Database.http://www.c-sharpcorner.com/UploadFile/3d39b4/learn-membership-services-part-1-installing-Asp-Net-members/5/4/2013 11:26:40 AMSandeep Singh ShekhawatIn this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. http://www.c-sharpcorner.com/UploadFile/eec362/temporary-tables-vs-table-variable-in-sql-server-2008/5/4/2013 11:16:35 AMYogesh BajpaiIn this article I explain how to count and delete duplicate records from SQL database table.http://www.c-sharpcorner.com/UploadFile/c63ec5/find-and-delete-duplicate-records-from-sql-table/4/30/2013 9:19:33 AMSharad GuptaRecently I am working on Entity Framework as data access layer based Project. We found many performance issues with this application. http://www.c-sharpcorner.com/UploadFile/ff2f08/prevent-dead-lock-in-entity-framework/5/2/2013 9:15:40 AMJignesh TrivediIn this article, I would like to show how to extract the metadata about a database in SQL Server.http://www.c-sharpcorner.com/UploadFile/rohatash/databasepropertyex-function-in-sql-server/5/1/2013 5:28:05 AMRohatash KumarThe purpose of this article is to explain how to keep track of user activities in the Database Managements System.http://www.c-sharpcorner.com/UploadFile/e881fb/user-activity-log-using-C-Sharp-with-sql-server/4/27/2013 10:47:37 AMNaveed ZamanThis article shows how to create a subquery to a select statement in SQL Server. http://www.c-sharpcorner.com/UploadFile/rohatash/creating-subquery-in-sql-server/4/25/2013 1:38:59 AMRohatash KumarIn this article you will learn how to Change Static themes to Dynamic themes using C Sharp with SQL Server.http://www.c-sharpcorner.com/UploadFile/e881fb/changing-static-themes-to-dynamic-themes-using-c-sharp-with/4/21/2013 8:13:58 AMNaveed ZamanSometimes or every time their need to perform the Insert,Select ,update,delete record task on table using single stored procedure instead of Creating different stored procedure for each operation.http://www.c-sharpcorner.com/UploadFile/0c1bb2/insertselectupdate-delete-records-in-single-stored-proce/10/18/2012 8:35:01 AMVithal WadjeIn this article, I would like to show the functions DATEADD, EMONTH, TODATETIMEOFFSET in SQL Server. http://www.c-sharpcorner.com/UploadFile/rohatash/modifying-date-and-time-values-in-sql-server/4/16/2013 4:13:43 AMRohatash KumarIn this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.http://www.c-sharpcorner.com/UploadFile/rohatash/getting-date-and-time-parts-from-datetime-in-sql-server/4/15/2013 1:06:11 AMRohatash KumarIn this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.http://www.c-sharpcorner.com/UploadFile/rohatash/working-with-date-and-time-in-sql-server-and-C-Sharp/4/11/2013 4:18:56 AMRohatash KumarIn this article you will learn about ISNULL versus COALESCE in SQL.http://www.c-sharpcorner.com/UploadFile/ff2f08/isnull-vs-coalesce-in-sql/4/9/2013 7:57:46 AMJignesh TrivediI have reviewed and answered many articles related to SQL Server. For the previous one and a half months, I found 3 to 4 articles related to finding comma separated values in SQL Server. So I decided to write an article on Comma Separated Values in SQL, it might help people who are looking for a solution of this.http://www.c-sharpcorner.com/UploadFile/ff2f08/comma-separated-value-in-sql-query/4/8/2013 10:28:46 AMJignesh TrivediIn this article I provide a quick overview of how to use Filter Setting in SQL Server. http://www.c-sharpcorner.com/UploadFile/rohatash/using-filter-settings-option-in-sql-server/4/4/2013 4:48:45 AMRohatash KumarIn this article you will see how to compare the database projects in a solution with SQL Server Database.http://www.c-sharpcorner.com/UploadFile/013102/tips-tricks-compare-database-project-in-solution-with-sq/4/2/2013 7:26:06 AMCk Nitin In this article I provide a quick overview of how to use the right and left functions in SQL Server. http://www.c-sharpcorner.com/UploadFile/rohatash/using-right-and-left-function-in-sql-server/4/1/2013 10:01:28 AMRohatash KumarIn this article I provide a quick overview of how to add a number in a string in SQL Server. http://www.c-sharpcorner.com/UploadFile/rohatash/adding-a-number-in-string-in-sql-server/3/22/2013 7:47:28 AMRohatash KumarThis Article helps you understand three types SQL Server Transactions. You can also learn how they differ from each other.http://www.c-sharpcorner.com/UploadFile/6897bc/sql-server-transaction-types/3/22/2013 12:02:19 AMSivaraman DhamodaranIn this article I have described the magic tables and how to use magic tables in SQL Server.http://www.c-sharpcorner.com/UploadFile/93126e/what-are-the-magic-tables-used-by-triggers-in-sql-server/3/19/2013 6:39:13 AMManish SharmaHere I am sharing some of the SQL queries which are commonly asked. I was practicing with such queries and wanted to know more from people.http://www.c-sharpcorner.com/UploadFile/praneet.rane/commonly-ask-sql-queries/3/18/2013 6:57:12 AMPraneet RaneIn this article, you'll learn about SSRS Reporting Document.http://www.c-sharpcorner.com/UploadFile/26ae36/ssrs-reporting-document-in-sql-server/3/15/2013 5:57:16 AMVijendra SinghToday I was given a task to convert comma-separated numbers into comma-separated weekday names in SQL.http://www.c-sharpcorner.com/UploadFile/e70b61/convert-comma-separated-numbers-into-comma-separated-weekday/3/8/2013 7:30:06 AMAhmar HusainWindows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.http://www.c-sharpcorner.com/UploadFile/vendettamit/sql-server-2008-r2-on-windows-8-error-17058-when-starting-th/3/8/2013 4:42:54 AMAmit ChoudharyHow to configure reports on server and with ASP.NET.http://www.c-sharpcorner.com/UploadFile/india1234/steps-to-configure-reports-on-server/2/8/2013 5:21:13 AMSanjeev rajputSPARSE column is ordinary type column that has an optimized storage for NULL values. http://www.c-sharpcorner.com/UploadFile/ff2f08/sparse-column-in-sql-server1/2/7/2013 8:20:16 AMJignesh TrivediSQL Server 2008 introduced Filtered Index. It is nothing but an optimized non-clustered index. http://www.c-sharpcorner.com/UploadFile/ff2f08/filtered-indexes-in-sql-server/2/4/2013 6:50:16 AMJignesh TrivediThis sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-use-the-except-and-intersect-operators-in-sql-server-2005/9/28/2008 12:00:00 AMRaj KumarIn this article we learn how to use Service Broker and triggers to capture data changes.http://www.c-sharpcorner.com/UploadFile/ff2f08/asynchronous-triggers-using-sql-broker/1/23/2013 10:36:30 AMJignesh TrivediThe SQL Server Service Broker helps developers to build scalable as well as secure database applications.http://www.c-sharpcorner.com/UploadFile/ff2f08/service-broker-in-sql-server/1/22/2013 9:49:56 AMJignesh TrivediIn this article you will learn about SQL Data Types in detail.http://www.c-sharpcorner.com/UploadFile/8911c4/sql-data-types/1/17/2013 6:07:28 AMMahesh AlleCommon Table Expression (CTE) was introduced in SQL Server 2005, which offers a more readable form of the derived table, which can be declared once and referenced multiple times in a query. http://www.c-sharpcorner.com/UploadFile/ff2f08/common-table-expression-cte-in-sql-server/1/16/2013 9:10:33 AMJignesh TrivediIn this article I am going to explain the case statement in Transact-SQL and how to sort table data using the case statementhttp://www.c-sharpcorner.com/UploadFile/3d39b4/case-statement-in-sql/1/4/2013 12:10:00 PMSandeep Singh ShekhawatIn the last article I showed how we can implement CRUD operations using Entity Framework using SQL database, now I would like to show you how we can implement the same using MySql database.http://www.c-sharpcorner.com/UploadFile/Dorababu742/implementing-crud-operation-in-mysql-using-entity-framework/12/27/2012 8:56:10 AMDorababu In this post I would like to share something regarding Entity Framework, how we can implement CRUD operations using stored procedures in Entity Framework.http://www.c-sharpcorner.com/UploadFile/Dorababu742/entity-framework-crud-operations-using-stored-procedure/12/26/2012 9:31:08 AMDorababu Recently I had been on an interview and this was the question that I was asked about SQL Server which I would like to share with all of you.http://www.c-sharpcorner.com/UploadFile/17e8f6/sql-server-interview-question/12/24/2012 11:29:23 AMVishal GilbileMicrosoft SQL Server 2012 has a customized clause for paging and it is efficient. Custom paging is the option for handling huge records.http://www.c-sharpcorner.com/UploadFile/bc1c71/custom-paging-in-sql-server-2012/11/13/2012 4:28:18 PMAnil Kumar In this article, I will explain the three basic thingss to do to send mail in SQL Server.http://www.c-sharpcorner.com/UploadFile/c1f7d5/employees-birthday-mail-by-sql-server/12/18/2012 4:52:29 AMShivom AgarwalIn this article I have explained DDL statements used in SQL Serverhttp://www.c-sharpcorner.com/UploadFile/0c1bb2/introduction-to-ddl-statements-in-sql-server/12/7/2012 7:42:41 AMVithal WadjeIn this article I am going to explain the Take and Skip operators in LINQ to SQL. The Take operator is used to return a given number of rows from a database table and the Skip operator skips over a specifed number of rows in a database table.http://www.c-sharpcorner.com/UploadFile/3d39b4/take-and-skip-operator-in-linq-to-sql/12/6/2012 6:58:50 AMSandeep Singh ShekhawatIn this article I am going to explain how to use aggregate functions in LINQ to SQL as well as in SQL Server.http://www.c-sharpcorner.com/UploadFile/3d39b4/aggregate-functions-in-linq-to-sql/12/5/2012 6:13:54 AMSandeep Singh ShekhawatIn this article is a detailed explanation of the Insert statement in SQL Server.http://www.c-sharpcorner.com/UploadFile/0c1bb2/introduction-to-insert-statement-in-sql-server/12/4/2012 7:42:27 AMVithal WadjeIn this article I am explaining how to get the last inserted identity value of an auto increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT()). Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value that are produced in a single session; in other words a connection while IDENT_CURRENT() returns the last identity value according to the table for any session.http://www.c-sharpcorner.com/UploadFile/3d39b4/difference-among-identity-scope_identity-and-ident_curr/12/3/2012 6:40:29 AMSandeep Singh ShekhawatIn this article I am going to explain how to insert multiple rows using a user defined table type. http://www.c-sharpcorner.com/UploadFile/3d39b4/insert-rows-using-user-defined-table-types/12/3/2012 7:37:47 AMSandeep Singh ShekhawatIn this article I am explaining, with a sample demo, storing Session State in a local or remote SQL Server.http://www.c-sharpcorner.com/UploadFile/2124ae/out-of-process-session-state-in-sql-server/11/13/2012 8:59:24 AMKumar SaurabhThis article shows how we can determine the size of an entire database using C# and the size of each and every table in the database using a single SQL command.http://www.c-sharpcorner.com/UploadFile/0f68f2/how-to-get-whole-database-size-using-C-Sharp-in-sql-server/11/6/2012 6:13:04 AMHemant SrivastavaIn this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.http://www.c-sharpcorner.com/UploadFile/3d39b4/find-nth-highest-salary-in-sql-server/11/6/2012 5:25:38 AMSandeep Singh ShekhawatIn this article I explain most of the SQL Server functions for manipulating text.http://www.c-sharpcorner.com/UploadFile/3d39b4/sql-server-text-data-manipulation/11/2/2012 11:54:48 AMSandeep Singh ShekhawatThis article describes cursors, declaration of cursors, opening of cursors, fetching from cursors, closing of cursors and deallocating cursors.http://www.c-sharpcorner.com/UploadFile/63f5c2/cursor-in-sql-server/10/20/2012 6:02:09 AMNishu In this article, I describe Views in SQL Server.http://www.c-sharpcorner.com/UploadFile/63f5c2/view-in-sql-server/10/22/2012 4:54:47 AMNishu In this artcle I describe triggers http://www.c-sharpcorner.com/UploadFile/63f5c2/triggers-in-sql-server/10/17/2012 6:23:33 AMNishu Microsoft SQL Server Compact Edition is an embedded database system that allows us to integrate it in our Web, Desktop and Mobile applications.http://www.c-sharpcorner.com/UploadFile/abhikumarvatsa/entity-framework-console-applications-with-sql-server-compac/10/8/2012 9:39:29 AMAbhimanyu K VatsaIn this artcle you will see how to use the top keyword in a select query to get the top element from the query.http://www.c-sharpcorner.com/UploadFile/d2b5dd/top-is-really-a-nice-and-important-in-sql-server-2008/10/6/2012 8:58:00 AMVikrant MoreIn this article, we’re going to learn the principles and techniques you can use to help troubleshoot and evaluate query performance by illustrating examples in Microsoft SQL Server and Oracle database.http://www.c-sharpcorner.com/UploadFile/john_charles/performance-tuning-in-database-systems/11/8/2008 12:00:00 AMJohn Charles OlamendyIn this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts. http://www.c-sharpcorner.com/UploadFile/john_charles/create-a-sql-server-ce-database-from-sql-schema-file/3/4/2009 12:00:00 AMJohn Charles OlamendyIn this article we will go through the most basic and frequently asked interview questions on SQL Server. http://www.c-sharpcorner.com/UploadFile/shivprasadk/sql-server-faqs/2/16/2009 12:00:00 AMShivprasad This article demonstrates how to create SSRS report. This article begins with the SSRS Introduction, Use of SSRS and step by step creation of report.http://www.c-sharpcorner.com/UploadFile/db2972/create-ssrs-report-using-report-wizard/9/17/2012 8:50:30 AMAkshay PatelOnce upon a time there was an interview question, "How do you find the second Maximum". With the SQL Ranking function of course. Continue reading the story. http://www.c-sharpcorner.com/UploadFile/6897bc/ranking-functions/8/30/2012 11:01:37 PMSivaraman DhamodaranThis article discusses how to create database and tables in MySQL. More emphasis is placed on how to get the details of the latest inserted ID and also the usage of appropriate functions in the case of concurrent insertions by multiple users.http://www.c-sharpcorner.com/UploadFile/akkiraju/handling-concurrency-data-insertion-operations-in-mysql/9/11/2012 8:23:08 AMAkkiraju IvaturiIn this article I would like to discuss the Magic tables used in the SQL Server.http://www.c-sharpcorner.com/UploadFile/d2b5dd/magic-tables-in-sql-server/9/10/2012 7:46:33 AMVikrant MoreLet me share share some of the Sql questions I have been asked during interviews.http://www.c-sharpcorner.com/UploadFile/SukeshMarla/select-a-row-randomly-using-sql/8/14/2012 1:58:56 PMSukesh MarlaThis article explains Inversion of Control and Dependency Injection. Inversion of control is a principle and dependency injection is a way of implementing inversion of control.http://www.c-sharpcorner.com/UploadFile/db2972/inversion-of-control-and-dependency-injection/9/3/2012 8:37:36 AMAkshay PatelIn SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.http://www.c-sharpcorner.com/UploadFile/ff2f08/table-valued-clr-function-in-sql-server-2005/8/28/2012 9:20:23 AMJignesh TrivediIn SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.http://www.c-sharpcorner.com/UploadFile/ff2f08/clr-function-in-sql-server-2005/8/27/2012 10:02:51 AMJignesh TrivediHere you will see how to put your SQL Server’s Query Execution Engine on hold for a while.http://www.c-sharpcorner.com/UploadFile/2f73dd/put-sql-server’s-query-execution-engine-on-hold/8/26/2012 10:06:41 AMPrabhu RajaThis article demonstrates how to use full text catalog and full text search in SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-use-full-text-search-in-sql-server-2008/8/22/2012 7:51:47 AMRaj KumarOne of the friends in C-sharpcorner has asked me for help displaying the difference of data from two different data sources.http://www.c-sharpcorner.com/UploadFile/akkiraju/find-difference-of-data-between-two-data-sources/8/21/2012 9:50:36 AMAkkiraju IvaturiIn this article you will see how to display rows as columns with totals displayed on each row and column.http://www.c-sharpcorner.com/UploadFile/akkiraju/displaying-rows-as-columns-with-total-displayed-on-each-row/8/19/2012 3:53:35 AMAkkiraju IvaturiIn this article I explain how to create and use a cursor in SQL, and also how to fetch the records from the table using the cursor.http://www.c-sharpcorner.com/UploadFile/c25b6d/fetching-the-records-through-cursor-in-sql-server-2005/8/17/2012 6:35:54 AMRicha GargIn this article I will explain how to merge multiple rows into a single row using SQL 2005. http://www.c-sharpcorner.com/UploadFile/c25b6d/combining-more-than-one-rows-into-a-single-row-in-sql-server/8/16/2012 5:28:16 AMRicha GargIn this article we will discuss how to configure and send emails from SQL server 2008. http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-configuresend-sql-server-database-mail/8/7/2012 3:56:52 AMRaj KumarHere I am going to discuss deleting files using SQL Job.http://www.c-sharpcorner.com/UploadFile/0f68f2/delete-and-create-files-with-a-sql-job-in-sql-server-2008/8/7/2012 6:36:05 AMHemant SrivastavaIn this article you will learn how to update data of View in SQL.http://www.c-sharpcorner.com/UploadFile/hirenvisavadiya/view-for-updating-data-in-sql/8/2/2012 12:40:42 PMHiren VThe purpose of this article is to show step-by-step how to connect C# to MySQL using MySQL Connect/Net.http://www.c-sharpcorner.com/UploadFile/shubham0987/connect-C-Sharp-with-mysql/7/31/2012 6:58:19 AMShubham SaxenaIn this example, we will see how to use an update statement of SQL using Inner Joins.http://www.c-sharpcorner.com/UploadFile/pandeypradip/use-update-statement-in-sql-using-inner-join/7/30/2012 1:59:41 AMPradip PandeyIn this article you will learn some basics about Compound Operators of SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/ff2f08/compound-operators-in-sql-server-2008/7/25/2012 11:10:00 AMJignesh Trivedi