SQL Server Tutorial - Fresh Code Hub

Start Date, End Date For Privious, Current And Next Month In SQL Server With Time Stamp

01-Jun-2018 Kamal Pratap

0 Comments 2926 Views

SQL Server

Here we explain how to use Start Date, End Date For Privious, Current And Next Month In SQL Server With Time Stamp. This T-SQL return the start and end date with minimum and maximum time.

How To Generate (N) Digit Random Number Between Start And End Range In SQL Server

01-Jun-2018 Kamal Pratap

0 Comments 2768 Views

SQL Server

Sometime we need to use unique random number into our application. Below we explain the logic to generate random number between two given range.

Difference between @@IDENTITY, SCOPE_IDENTITY(), IDENT_CURRENT in SQL Server

15-Mar-2018 Kamal Pratap

0 Comments 2881 Views

SQL Server

Sometimes we need to get last inserted identity for any table. There are three properties to get last inserted identity.

Implement Ranking Functions in SQL Server

13-Mar-2018 Alok Kushwaha

0 Comments 2441 Views

SQL Server

There are four ranking function in SQL Server. ROW_NUMBER, RANK, DENSE_RANK, and NTILE are use to return a ranking value for each row over the partition.

Create a Database Mail Configuration Using T-SQL Script

05-Feb-2018 Kamal Pratap

1 Comments 4502 Views

SQL Server

It is the enterprise solutions to send email to your customer or vendor from SQL server. It provides features like scalability, security, and reliability.

Configure Database Mail In SQL Server Database

03-Feb-2018 Kamal Pratap

0 Comments 3763 Views

SQL Server

In this article i am going to explain how to configure database mail in SQL Server database. This is the best solution to sending email from the SQL Server database engine to SMTP servers.

Create and schedule database backup job using SQL Server Management Studio

03-Feb-2018 Kamal Pratap

0 Comments 1897 Views

SQL Server

Here we explain how to configure automatic, scheduled database backups in MS SQL Server.

How to convert URL to Shorten URL or Tiny URL in SQL Server

27-Jan-2018 Kamal Pratap

1 Comments 4257 Views

SQL Server

Many times we need to send the URL into SMS and email but due to big URL length the SMS has devided into two parts.

Drop all Tables, Stored Procedures, Views And Triggers with one SQL query in SQL Server.

15-Dec-2016 Kamal Pratap

0 Comments 2622 Views

SQL Server

Here we explain how to drop all Tables, Stored Procedures, Views And Triggers in one SQL statement. Suppose we have lot of tables, procedure, views & triggers we need to remove them from the database will be a difficult task.

How to Find a Stored Procedure Containing Text or String

09-Sep-2016 Kamal Pratap

0 Comments 5101 Views

SQL Server

Many times raise some question when we work on SQL Server.

1 2 Next Last

Asp.Net

MVC

WCF

SQL Server

HTML

CSS

Jquery

Flash Designing

IOS App Development

Window App Development

Android App Development

Categories

Tags

Newsletter