SQL Server Blogs

Post

SQL Server

Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Blogs

Get List of Database Tables,Stored Procedures,View,Index,Functions and more

Here, you will see how to get list of database tables,stored procedures, view, index, functions and more
Pankaj Pandey May 02, 2013
Get definition/Script of all stored procedures

Get definition/Script of all stored procedures of a database.
Pankaj Pandey May 02, 2013
Difference between Rank() and Dense_Rank() function in SQL Server

We use either Rank() or Dense_Rank() to get consecutive numbering. But there is a difference between these two functions.
Pradip Pandey Apr 25, 2013
Get Procedures used in another Procedure

Can we get the procedures which are used in another procedures. Is there any solution to get those?
Siva Ganesh Rongala Apr 25, 2013
How to Convert Indian Rupee to Indian Rupee System

This blog defined how to Convert money to Indian Rupee System using SQL Function.
Bhupendra Singh Apr 24, 2013
Insert Table Values From One Database To Another Database

Here is a SQL query for inserting data from one database table into another database table.
Pankaj Pandey Apr 23, 2013
Execute SQL Query In String Format

Learn how to execute a SQL query that is created in a string format dynamically.
Pankaj Pandey Apr 23, 2013
Insert Data from One Table to Another Table in SQL Server

Query to insert data from one table to another table in on shot.
Pankaj Pandey Apr 22, 2013
Query Shortcut in SQL SERVER

Run the SQL Query using Query ShortCut.
Gaurav Gupta Apr 12, 2013
Difference between PatIndex and CharIndex function in SQL SERVER

This blog shows Similarity and difference between PatIndex and CharIndex function in SQL SERVER.
Gaurav Gupta Apr 11, 2013
Sequence in SQL Server 2012

An introduction to Sequence in SQL Server 2012.
Joxin Stanly Apr 08, 2013
How To Call A Function In SQL Server Stored procedure

In this blog, learn how to call a function from an SQL Server stored procedure.
Pankaj Pandey Mar 20, 2013
Difference Between Stored Procedures and Triggers

Learn what is the difference between a SQL Server stored procedure and trigger.
Pankaj Pandey Mar 20, 2013
Copy All Tables From One Database To Another In SQL Server

Here is a SQL query to copy all tables from a SQL Server database to another SQL Server database including tables data.
Pankaj Pandey Mar 19, 2013
Difference between ROW_NUMBER, RANK and DENSE_RANK

Discover concepts like ROW_NUMBER, RANK and DENSE_RANK.
Nitesh Singhal Mar 19, 2013
How to know SQL Server version , edition and build version

In this blog I will explain about knowing the SQL Server details like version and edition. So we know the limitation of the server we work with. We could use the command in this blog for SQL SERVER...
Shyju Feb 12, 2013
SQL Server 2008 SSMS accessing SQL Server 2012 instance

SQL Server management Studio's Backward and Forward compatibility.
Vidya Vrat Agarwal Dec 28, 2012
Integrated Statement completion feature of MS SQL Server

MS SQL 2012 or its previous version MS SQL 2008 has inbuilt statement completion feature. This can be set for all languages or for T-SQL only.
Anil Kumar Dec 26, 2012
Display Second or N th. Salary from Table in SQL Server

In this blog I have explained how to display the nth number from a table.
Vithal Wadje Dec 03, 2012
Row_Number Function With PARTITION BY Clause In SQL Server

SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.
Rohatash Kumar Nov 19, 2012

821 - 840 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Blockchain Beginner