http://www.c-sharpcorner.com/blogs/Watch latest blogs from SQL© 1999 - 2012 Mindcracker LLC. All Rights ReservedThis blog defines the difference between both length functions with example.http://www.c-sharpcorner.com/Blogs/11736/len-and-datalength-function-in-sql-server.aspx5/22/2013 3:24:09 AMRohatash KumarLearn about SQL Server Management Studio Keyboard Shortcuts.http://www.c-sharpcorner.com/Blogs/11712/sql-server-management-studio-keyboard-shortcuts.aspx5/19/2013 8:23:27 AMSurjeet YadavCHECK FOR TABLE/PROCEDUE THAT DEPEND ON PROCEDURE/TABLE.http://www.c-sharpcorner.com/Blogs/11703/find-dependent-object-in-sql-server.aspx5/17/2013 6:42:37 AMSambhav YadavThis blog defines step by step process for to create linked server from MySQL TO SQL Server. http://www.c-sharpcorner.com/Blogs/11655/how-to-create-linked-server-from-mysql-to-sql-server.aspx5/10/2013 5:14:27 AMPankaj PandeyRemove Duplicate rows in a table.http://www.c-sharpcorner.com/Blogs/11626/remove-duplicate-rows-in-a-table.aspx5/6/2013 12:22:27 AMSiva Ganesh RongalaCall or execute a Stored Procedure from Select Statement in SQL Server using OPENROWSET.http://www.c-sharpcorner.com/Blogs/11616/call-or-execute-a-stored-procedure-from-select-statement-in.aspx5/3/2013 9:45:14 AMSachin KaliaRemove last character from a string by using some SQL functions.http://www.c-sharpcorner.com/Blogs/11591/remove-last-character-from-a-string-in-sql-server.aspx4/30/2013 6:11:34 AMPradip PandeyThis blog is about how to upgrade a database file to use LocalDBhttp://www.c-sharpcorner.com/Blogs/11585/how-to-upgrade-a-database-file-to-use-localdb.aspx4/29/2013 12:57:13 PMRaj KumarThis blog defines the case statement with a simple example in SQL Server. http://www.c-sharpcorner.com/Blogs/11581/case-statement-in-sql-server.aspx4/29/2013 6:07:49 AMYogesh BajpaiHere, You will see how to create function and then call in SQL Query in SQL Server 2008.http://www.c-sharpcorner.com/Blogs/11580/how-to-create-function-in-sql-server.aspx4/29/2013 5:25:27 AMYogesh BajpaiHow to Convert Indian Rupee to Indian Rupee System using SQL Function.http://www.c-sharpcorner.com/Blogs/11525/how-to-convert-indian-rupee-to-indian-rupee-system.aspx4/24/2013 4:38:26 AMBhupendra Singhin this blog we will learn what is Between Functions and Stored Procedurehttp://www.c-sharpcorner.com/Blogs/11463/difference-between-stored-procedure-and-functions.aspx4/18/2013 2:50:58 PMVithal WadjeHow to write dynamic query in SQL. Means your query execute according to your requirement.http://www.c-sharpcorner.com/Blogs/11461/dynamic-query-in-sql.aspx4/18/2013 7:49:34 AMRavi ShekharIn this blog I will tell you that what is the difference between In and Between Operator in SQL.http://www.c-sharpcorner.com/Blogs/11356/difference-between-in-and-between-operator-in-sql.aspx4/11/2013 12:37:06 AMAkash GargIn this blog I will provide a quick overview of how to use the max and min functions in SQL.http://www.c-sharpcorner.com/Blogs/11347/how-to-use-max-and-min-function-in-sql.aspx4/10/2013 1:15:20 AMAkash GargWe can find out the first and last day with time of the previous month by simple step.http://www.c-sharpcorner.com/Blogs/11331/findout-first-day-and-last-day-with-time-of-the-previous-mon.aspx4/9/2013 5:07:24 AMAkash GargUpdate Male TO Female and Female To Male with single queryhttp://www.c-sharpcorner.com/Blogs/11330/update-male-to-female-and-female-to-male-with-single-query.aspx4/9/2013 4:12:30 AMSatyapriya NayakIn this blog we calculate the working days in a company by using SQL.http://www.c-sharpcorner.com/Blogs/11329/calculate-number-of-working-days-between-two-date-by-using-s.aspx4/9/2013 4:07:46 AMAkash GargIn this blog differences between SQL Server 2008 and SQL Server 2012 are shownhttp://www.c-sharpcorner.com/Blogs/11323/difference-between-sql-server-2008-and-sql-server-2012.aspx4/8/2013 5:28:42 AMAkash GargTriggers can be classified as a special type of stored procedure that executes automatically in response to some triggering action like INSERT, UPDATA, DELETE etchttp://www.c-sharpcorner.com/Blogs/11289/triggers-in-sql-server.aspx4/3/2013 11:28:35 AMJatin NagpalSql server table identity column in different session and scopes.http://www.c-sharpcorner.com/Blogs/11257/difference-between-identity-scope_identity-ident_cur.aspx3/31/2013 5:38:53 AMNitesh SinghalDeleting Duplicate Records in SQL Table.http://www.c-sharpcorner.com/Blogs/11193/deleting-duplicate-records-in-sql-table.aspx3/25/2013 10:10:01 AMKunal VaishyaThese are Sql keywords we usually used to filter data between two tables mostly.http://www.c-sharpcorner.com/Blogs/11146/difference-between-except-and-not-in-and-not-exist.aspx3/18/2013 6:52:40 AMNitesh SinghalI have a SQL script that has to update a field in a table but the field name is a row in another table could you please help.http://www.c-sharpcorner.com/Blogs/11138/how-to-update-a-field-where-the-field-name-is-equal-to-a-row.aspx3/18/2013 2:35:52 AMRamiro HunsewrajMostly developers need to transfer data from one table to another. For this purpose we have two scenarios.http://www.c-sharpcorner.com/Blogs/11124/transfer-data-from-one-table-to-another.aspx3/14/2013 1:29:50 AMNitesh SinghalTransaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.http://www.c-sharpcorner.com/Blogs/11107/transaction-count-after-execute-indicates-a-mismatching-numb.aspx3/11/2013 12:18:33 PMAnil Kumar In this blog your will how to save an image in sql Server 2005 with unique key.http://www.c-sharpcorner.com/Blogs/11097/save-an-image-in-sql-server-2005-with-unique-key.aspx3/8/2013 10:39:12 AMNiks BishtIn this article your will how to select from stored procedure dynamically.http://www.c-sharpcorner.com/Blogs/11096/selct-from-store-procedure-dynamically.aspx3/8/2013 10:27:24 AMGohil JayendrasinhHow to insert values in identity column in SQL Server. Identity columns are used to automatically assign new incremented value to identity column when new record inserted based on previous value in SQL Server. http://www.c-sharpcorner.com/Blogs/11088/insert-values-into-identity-column-in-sql-server.aspx3/7/2013 7:34:58 AMBrijesh KumarThis is a function which return number of weekends between two dates using sql datepart function.http://www.c-sharpcorner.com/Blogs/11054/get-number-of-weekends-between-two-dates.aspx3/3/2013 4:23:43 AMPankaj RanaHow to find second highest salary in SQL Server.http://www.c-sharpcorner.com/Blogs/11040/second-highest-salary-in-sql-server.aspx2/27/2013 2:18:58 AMRajeev KumarBulk Insert into table using User-Defined Table Type using store proceduewhttp://www.c-sharpcorner.com/Blogs/11012/bulk-insert-into-table-using-user-defined-table-type.aspx2/21/2013 6:13:21 AMPankaj RanaCreate Temp Table and Insert Data in to Temp Table using Dynamic Query http://www.c-sharpcorner.com/Blogs/10978/create-temp-table-and-insert-data-in-to-temp-table-using-dyn.aspx2/16/2013 1:25:40 AMGohil JayendrasinhIn this blog you will learn import excel data into SQL temp table.http://www.c-sharpcorner.com/Blogs/10968/import-excel-data-into-sql-temp-table.aspx2/14/2013 4:44:02 AMnilay mistryIn this article i will describe how to Break Circular dependence between table in SQL Server.http://www.c-sharpcorner.com/Blogs/10922/break-circular-dependence-between-table-in-sql-server.aspx2/4/2013 4:38:28 AMHemanth KumarIn this article I will describe Insert Data Into Identity columns of Table in SQL Server.http://www.c-sharpcorner.com/Blogs/10921/insert-data-into-identity-columns-of-table-in-sql-server.aspx2/4/2013 4:37:06 AMHemanth KumarIn this blog I have explained in brief about the Types of Stored Procedure in Sql Server.http://www.c-sharpcorner.com/Blogs/10903/types-of-stored-procedure-in-sql-server.aspx1/29/2013 6:56:55 AMVithal WadjeHere SQL SERVER Practical Scenario for joins and aggregate functions. http://www.c-sharpcorner.com/Blogs/10896/sql-server-practical-scenario.aspx1/25/2013 6:27:49 AMBala Due to the lack of mechanisms, DBA generally do mistakes to maintain data quality:http://www.c-sharpcorner.com/Blogs/10835/data-quality-problems-in-database.aspx1/21/2013 1:42:16 AMPradip PandeyIn this blog I am going to explain that how can do add, rename and drop a column from a table.http://www.c-sharpcorner.com/Blogs/10741/how-to-add-rename-and-drop-column.aspx1/2/2013 1:08:02 PMSandeep Singh ShekhawatIn this blog I am going to explain difference between VARCHAR and NVARCHAR.http://www.c-sharpcorner.com/Blogs/10736/difference-between-varchar-and-nvarchar.aspx1/1/2013 10:02:08 PMSandeep Singh ShekhawatIn this blog I am going to explain that how can get Maximum and Minimum integer number using user defined Scalar-valued functions in sql server 2008http://www.c-sharpcorner.com/Blogs/10721/get-max-and-min-integer-value-using-scalar-valued-function.aspx1/1/2013 1:07:10 AMSandeep Singh ShekhawatSometimes it required to execute the packages from SSMS after deploying it to SSISDB catalog in SQL Server. But what if we want to interrupt the execution in the middle or when package stops the progress or hangs.http://www.c-sharpcorner.com/Blogs/10677/stopping-execution-of-ssis-package-in-ssms.aspx12/27/2012 5:36:55 AMAmit ChoudharyError message when calling sp_send_dbmail Procedure sysmail_verify_profile_sp, profile name is not validhttp://www.c-sharpcorner.com/Blogs/10666/sp_send_dbmail-profile-name-is-not-valid.aspx12/26/2012 2:08:28 AMBryian TanIn this post we will write a query that will return the file sizes of all the databases present on a SQL Server.http://www.c-sharpcorner.com/Blogs/10659/how-to-retrieve-file-size-of-all-databases-present-in-sql-se.aspx12/24/2012 9:03:15 AMNitesh LuharukaToday, in this post we will see how to retrieve the size of data files of all databases present in SQL Server and the actual amount used in these files.http://www.c-sharpcorner.com/Blogs/10627/how-to-retrieve-the-file-size-used-by-a-sql-server-database.aspx12/20/2012 5:39:48 AMNitesh LuharukaThis post details another solution to a very basic problem that we face in our development and tend to miss writing Stored Procedures.http://www.c-sharpcorner.com/Blogs/10621/solution-executenonquery-always-returning-1-when-calli.aspx12/19/2012 5:40:01 AMNitesh LuharukaIn this blog, we will see how to Shrink the truncated log file in SQL Server. http://www.c-sharpcorner.com/Blogs/10614/transactional-log-shrink-conditions-in-sql-server.aspx12/18/2012 4:38:01 AMShivom AgarwalInterchanging data of two rows of table with out temporary fields.http://www.c-sharpcorner.com/Blogs/10606/data-swapping-of-two-rows.aspx12/14/2012 4:38:48 AMShankar MTo know the number of columns in a table with out using describe statement in Oracle SQLhttp://www.c-sharpcorner.com/Blogs/10591/number-of-columns-in-table.aspx12/12/2012 6:33:51 AMShankar MFileStream class can read and write operating system files. http://www.c-sharpcorner.com/Blogs/10587/filestream-class-in-C-Sharp.aspx12/10/2012 9:29:07 AMShankar MThis blog explains that what is use of ROWCOUNT.http://www.c-sharpcorner.com/Blogs/10583/use-of-rowcount.aspx12/9/2012 7:25:25 AMSandeep Singh ShekhawatIn this blog Advantages and Disadvantages of views in Sql Server.http://www.c-sharpcorner.com/Blogs/10575/advantages-and-disadvantages-of-views-in-sql-server.aspx12/7/2012 5:53:28 AMVithal WadjeIn this blog I am going to explain that how can get comma (,) separate values from a columnhttp://www.c-sharpcorner.com/Blogs/10534/get-comma-separated-value-from-a-column.aspx12/1/2012 10:14:55 AMSandeep Singh ShekhawatA SQL script that checks a strored procedure exists or not . If it is, it deletes the stored proc before running its creation script.http://www.c-sharpcorner.com/Blogs/10529/checking-a-stored-procedure-exists-or-not-in-database.aspx11/29/2012 6:10:26 PMHemant SrivastavaIn this blog, You will see how to use DBCC CHECKIDENT in SQl Server. http://www.c-sharpcorner.com/Blogs/10514/reset-identity-column-value-in-sql-server.aspx11/28/2012 4:53:26 AMRohatash KumarIn this blog, You will see how to swap two columns values in SQL Server.http://www.c-sharpcorner.com/Blogs/10510/swap-two-columns-values-in-sql-server.aspx11/27/2012 5:37:58 AMRohatash KumarIn this blog I have explained properties and different Types of Sub-Queries of SQL Server.http://www.c-sharpcorner.com/Blogs/10499/properties-and-different-types-of-sub-queries-in-sql-server.aspx11/26/2012 8:02:26 AMVithal WadjeIn this blog, I have explained Common Table Expression in SQL Server.http://www.c-sharpcorner.com/Blogs/10497/common-table-expression-in-sql-server.aspx11/26/2012 2:25:48 AMRohatash KumarIn this blog I have explained the difference between DELETE and TRUNCATE commands in SQL Server.http://www.c-sharpcorner.com/Blogs/10485/difference-between-delete-and-truncate-commands.aspx11/23/2012 8:42:30 AMVithal WadjeIn this blog, You will see Row_Number function without Partition By or with Partition By clause.http://www.c-sharpcorner.com/Blogs/10458/row_number-function-with-partition-by-clause-in-sql-server.aspx11/19/2012 6:18:16 AMRohatash KumarIn this blog we learn which process are done when we use the select query in sql server to retrive the recordshttp://www.c-sharpcorner.com/Blogs/10396/working-of-select-query-in-sql-server.aspx11/7/2012 5:36:59 AMVithal WadjeIn this blog, we are going to show how we can get the actual data table size in SQL Server-2008 in a very easy way. http://www.c-sharpcorner.com/Blogs/10322/how-to-get-the-table-size-in-sql-server-2008.aspx10/30/2012 7:12:25 AMHemant SrivastavaThis blog defines How we can search an array of strings. http://www.c-sharpcorner.com/Blogs/10316/array-search-in-C-Sharp.aspx10/30/2012 4:04:32 AMRohatash KumarInteresting thing in code to add one field in table once the table is already in the database.http://www.c-sharpcorner.com/Blogs/10299/adding-new-field-in-database.aspx10/26/2012 6:07:59 AMKunal VaishyaFind procedure and function from this query.http://www.c-sharpcorner.com/Blogs/10298/find-procedure-and-function-in-sql-server.aspx10/26/2012 6:04:34 AMKunal VaishyaThis is a good query to fetch comma separated data using XML Path.http://www.c-sharpcorner.com/Blogs/10297/fetch-comma-separated-data-using-xml-path.aspx10/26/2012 6:03:12 AMKunal VaishyaThis is the query to repair suspect database In SQL Server. If your Database is marked as suspected, here are the steps to fix it.http://www.c-sharpcorner.com/Blogs/10296/query-to-repair-suspect-database-in-sql-server.aspx10/26/2012 6:01:50 AMKunal VaishyaHow to Create a Backup Job in SQL Server.http://www.c-sharpcorner.com/Blogs/10294/create-a-backup-job-in-sql-server.aspx10/25/2012 10:03:40 AMAmit PatelIn this blog, you will see how to use Ntile function in SQL Server.http://www.c-sharpcorner.com/Blogs/10286/ntile-function-in-sql-server.aspx10/25/2012 3:31:24 AMRohatash KumarSQL Server 2012 comes with a different Editions with adding diffrent feature,in this blog i will explain the diffrent types of SQL Server 2012 Editions.http://www.c-sharpcorner.com/Blogs/10263/sql-server-2012-editions.aspx10/20/2012 6:33:12 AMVithal WadjeHere, I am discussing only two data type date and time.http://www.c-sharpcorner.com/Blogs/10228/using-date-and-time-data-type-in-sql-server-2008.aspx10/17/2012 8:23:16 AMSandeep Singh ShekhawatSometimes their is need to update the existing table in sql server database such as to add, remove column of existing table or change the size or type of data type of table Column. This article is useful for above requirement.http://www.c-sharpcorner.com/Blogs/10227/alter-table-statement-in-sql-server.aspx10/17/2012 8:07:40 AMVithal WadjeThis blog explain how we can get the frequency distribution of each element in a column using SQL.http://www.c-sharpcorner.com/Blogs/10222/sql-query-to-find-out-the-frequency-of-each-element-in-a-col.aspx10/17/2012 12:28:10 AMHemant SrivastavaHare, I give you an Example of Dynamic Stored Procedure with output parameter. http://www.c-sharpcorner.com/Blogs/10135/dynamic-stored-procedure-with-output-parameter.aspx10/5/2012 7:46:47 AMGohil JayendrasinhSplit Column in to or more column.http://www.c-sharpcorner.com/Blogs/10010/column-splitting-function.aspx9/7/2012 2:29:17 AMGohil JayendrasinhThis blog shows the difference between temp table and global temp tablehttp://www.c-sharpcorner.com/Blogs/9972/difference-between-and-in-sql-server.aspx9/2/2012 5:40:33 AMAkshay PatelUser defined data types created on the basis of system data types.http://www.c-sharpcorner.com/Blogs/9969/user-defined-data-type-in-sql-server.aspx9/1/2012 2:42:59 AMAkshay PatelIn this blog I try to take backup of all databases using ‘sp_MSforeachdb’ procedure.http://www.c-sharpcorner.com/Blogs/9947/get-backup-of-all-databases-without-using-cursor.aspx8/28/2012 6:37:20 AMAkshay PatelIn this blog, we will see how do we merge 2 rows values separated with comma in SQL.http://www.c-sharpcorner.com/Blogs/9868/merge-2-rows-values-in-sql.aspx8/14/2012 7:25:05 AMPradip PandeyThis code snippet splits string.http://www.c-sharpcorner.com/Blogs/9827/how-to-split-a-string-in-sql-server.aspx8/6/2012 7:00:37 AMAkshay PatelBitwise operators are very efficient. It allows us to hold conditional logic in an integer column.http://www.c-sharpcorner.com/Blogs/9808/bitwise-operation-in-sql-server.aspx8/3/2012 4:55:26 AMAkshay PatelIn this blog let us see how to add identity property for the existing column in a table which already has rows.http://www.c-sharpcorner.com/Blogs/9784/add-identity-property-to-the-existing-column-in-a-table-whic.aspx7/28/2012 1:38:12 AMSanthosh Kumar JayaramanThis blog demonstrate how to use PIVOT table in sql server.http://www.c-sharpcorner.com/Blogs/9783/how-to-use-pivot-table-in-sql-server.aspx7/27/2012 9:42:32 AMRahul BhattHere, We will see how to handle null values in DataTable's in DateTime column using SQL DateTime DataType.http://www.c-sharpcorner.com/Blogs/9778/handling-null-values-in-datatables-in-datetime-column-using.aspx7/27/2012 6:08:32 AMYogesh Kumar JaiswalIn this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn.http://www.c-sharpcorner.com/Blogs/9688/new-features-sql-2012-the-alwayson-feature.aspx7/16/2012 9:37:22 PMChristopher EdwardThis Query is usefull for searching.http://www.c-sharpcorner.com/Blogs/9649/passing-a-varchar-full-of-comma-delimited-values-to-a-sql-se.aspx7/10/2012 6:36:44 AMGohil JayendrasinhWe can get all value as single string with coma separator using this query. http://www.c-sharpcorner.com/Blogs/9637/get-a-column-value-in-a-single-coma-separated-string-in-sql.aspx7/6/2012 7:20:50 AMKunal VaishyaSend mail using gmail mail credentail from database serverhttp://www.c-sharpcorner.com/Blogs/9632/send-mail-from-database-sever-using-gmail.aspx7/6/2012 1:50:42 AMPankaj RanaHow to configure Database Mailing in SQL SERVER.http://www.c-sharpcorner.com/Blogs/9627/configuring-database-mailing-in-sql-server.aspx7/5/2012 2:38:08 PMLajapathy ArunHow to Delete or drop an Alias Data Type.http://www.c-sharpcorner.com/Blogs/9626/deleting-or-dropping-an-alias-data-type-in-sql-server.aspx7/5/2012 2:33:31 PMLajapathy ArunHow to Refresh a View in SQL SERVER.http://www.c-sharpcorner.com/Blogs/9625/refreshing-a-view-in-sql-server.aspx7/5/2012 2:29:07 PMLajapathy ArunHow to get the Information About the Columns of a Table.http://www.c-sharpcorner.com/Blogs/9624/getting-information-about-the-columns-of-a-table-in-sql-serv.aspx7/5/2012 2:23:21 PMLajapathy ArunGet Inserted auto generated values in SQL using @@Identityhttp://www.c-sharpcorner.com/Blogs/9623/get-inserted-auto-generated-values-in-sql.aspx7/5/2012 10:48:42 AMParthiban SelvarajRemove special characters when writing SQL queries using escape keywordhttp://www.c-sharpcorner.com/Blogs/9621/sql-server-–-remove-special-characters-when-writing-sql-quer.aspx7/5/2012 10:23:15 AMParthiban SelvarajHow to find the Size of INDEX on ALL TABLE in the current Database in SQL SERVERhttp://www.c-sharpcorner.com/Blogs/9613/finding-the-size-of-index-on-all-table-in-the-current-datab.aspx7/4/2012 8:45:48 AMLajapathy ArunHow to find the Size of INDEX on Specific TABLE in SQL SERVERhttp://www.c-sharpcorner.com/Blogs/9612/finding-the-size-of-index-on-specific-table-in-sql-server.aspx7/4/2012 8:40:56 AMLajapathy ArunHow to get DATA & LOG File information of ALL Database in SQL SERVERhttp://www.c-sharpcorner.com/Blogs/9611/getting-data-log-file-information-of-all-database-in-sql-s.aspx7/4/2012 7:21:47 AMLajapathy ArunHow to get the Size/Space of ALL Databases in the Current Serverhttp://www.c-sharpcorner.com/Blogs/9610/space-usage-of-all-databases-in-the-current-server.aspx7/4/2012 7:09:40 AMLajapathy Arunusage of SQL_VARIANT_PROPERTY in SQL SERVER.http://www.c-sharpcorner.com/Blogs/9609/practical-usage-of-sql_variant_property-in-sql-server.aspx7/4/2012 6:56:14 AMLajapathy Arun