Start Date, End Date For Privious, Current And Next Month In SQL Server With Time Stamp
01-Jun-2018 Kamal Pratap
0 Comments 1698 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.
Continue Reading...

How To Generate (N) Digit Random Number Between Start And End Range In SQL Server
01-Jun-2018 Kamal Pratap
0 Comments 1663 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.
Continue Reading...

Difference between @@IDENTITY, SCOPE_IDENTITY(), IDENT_CURRENT in SQL Server
15-Mar-2018 Kamal Pratap
0 Comments 1943 Views
SQL Server
Sometimes we need to get last inserted identity for any table. There are three properties to get last inserted identity.
Continue Reading...

Implement Ranking Functions in SQL Server
13-Mar-2018 Alok Kushwaha
0 Comments 1622 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.
Continue Reading...

Create a Database Mail Configuration Using T-SQL Script
05-Feb-2018 Kamal Pratap
1 Comments 2608 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.
Continue Reading...

Configure Database Mail In SQL Server Database
03-Feb-2018 Kamal Pratap
0 Comments 2476 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.
Continue Reading...

Create and schedule database backup job using SQL Server Management Studio
03-Feb-2018 Kamal Pratap
0 Comments 1412 Views
SQL Server
Here we explain how to configure automatic, scheduled database backups in MS SQL Server.
Continue Reading...

How to convert URL to Shorten URL or Tiny URL in SQL Server
27-Jan-2018 Kamal Pratap
0 Comments 2320 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.
Continue Reading...

Drop all Tables, Stored Procedures, Views And Triggers with one SQL query in SQL Server.
15-Dec-2016 Kamal Pratap
0 Comments 1733 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.
Continue Reading...

How to Find a Stored Procedure Containing Text or String
09-Sep-2016 Kamal Pratap
0 Comments 2937 Views
SQL Server
Many times raise some question when we work on SQL Server.
Continue Reading...

1 2 Next Last