SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

sp_send_dbmail profile name is not valid

Error message when calling sp_send_dbmail Procedure sysmail_verify_profile_sp, profile name is not valid
Bryian Tan Dec 26, 2012
How to Retrieve File Size of all Databases Present in SQL Server on Hard Disk

In this post we will write a query that will return the file sizes of all the databases present on a SQL Server.
Nitesh Kejriwal Dec 24, 2012
How to Retrieve the File Size used by a SQL Server Database on Hard Disk

Today, 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.
Nitesh Kejriwal Dec 20, 2012
Solution - ExecuteNonQuery() always returning -1 when calling a Stored Procedure

This post details another solution to a very basic problem that we face in our development and tend to miss writing Stored Procedures.
Nitesh Kejriwal Dec 19, 2012
Transactional Log Shrink Conditions in SQL Server

In this blog, we will see how to Shrink the truncated log file in SQL Server.
Shivom Agarwal Dec 18, 2012
Data Swapping of two rows

Interchanging data of two rows of table with out temporary fields.
Shankar M Dec 14, 2012
Number of columns in Table

To know the number of columns in a table with out using describe statement in Oracle SQL
Shankar M Dec 12, 2012
Use of ROWCOUNT

This blog explains that what is use of ROWCOUNT.
Sandeep Singh Shekhawat Dec 09, 2012
Advantages and Disadvantages of views in Sql Server

In this blog Advantages and Disadvantages of views in Sql Server.
Vithal Wadje Dec 07, 2012
Get comma separated value from a column

In this blog I am going to explain that how can get comma (,) separate values from a column
Sandeep Singh Shekhawat Dec 01, 2012
Checking a Stored Procedure exists or not in database

A SQL script that checks a strored procedure exists or not . If it is, it deletes the stored proc before running its creation script.
Hemant Srivastava Nov 29, 2012
Reset Identity Column Value in SQL Server

In this blog, You will see how to use DBCC CHECKIDENT in SQl Server.
Rohatash Kumar Nov 28, 2012
Swap Two Columns Values in SQL Server

In this blog, You will see how to swap two columns values in SQL Server.
Rohatash Kumar Nov 27, 2012
Common Table Expression in SQL Server

In this blog, I have explained Common Table Expression in SQL Server.
Rohatash Kumar Nov 26, 2012
Properties and Different Types of Sub-Queries in SQL Server

In this blog I have explained properties and different Types of Sub-Queries of SQL Server.
Vithal Wadje Nov 26, 2012
Difference between DELETE and TRUNCATE commands

In this blog I have explained the difference between DELETE and TRUNCATE commands in SQL Server.
Vithal Wadje Nov 23, 2012
Working Of Select Query in Sql Server

In this blog we learn which process are done when we use the select query in sql server to retrive the records
Vithal Wadje Nov 07, 2012
How to Get the Table Size in SQL server 2008

In 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.
Hemant Srivastava Oct 30, 2012
Array Search in C#

This blog defines How we can search an array of strings.
Rohatash Kumar Oct 30, 2012
Query to Repair Suspect Database In SQL Server

This is the query to repair suspect database In SQL Server. If your Database is marked as suspected, here are the steps to fix it.
Kunal Vaishya Oct 26, 2012

241 - 260 of 498