TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
SQL
FOLLOW
Learn SQL, a language to query and manipulate relational database management systems.
Articles
(370)
Blogs
(494)
Resources
(18)
Videos
(8)
News
(4)
Articles
How to Encrypt and Decrypt a Password
How to Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase.
Syed Shakeer
Feb 18, 2011
Binary_Checksum the Alternate of NewID() to Fetch Random Records in SQL Server
In this article I will demonstrate Binary_Checksum, the Alternate of NewID() to fetch random records in an SQL Server.
Amit Choudhary
Oct 04, 2011
Complex SQL Queries With Split() Function in SQL
In this article, you will learn about Complex SQL queries with the split() function in SQL.
Mahesh Alle
May 23, 2013
How to Create a Trigger in SQL
SQL triggers are database objects, a particular kind of stored procedure, which “reacts” to certain actions we make in the database. Learn what is a trigger in SQL Server and how to create triggers...
Pankaj Kumar Choudhary
Jun 02, 2015
Create, Delete, and Update Triggers in SQL
This article discusses how to create and manage triggers in a database using SQL.
Shashi Ray
Oct 02, 2008
How To Add Primary Key To Existing Table In SQL
In this article, you will learn how to add primary key in an existing table.
Naresh Beniwal
Jan 30, 2023
Computed Columns in SQL Server
Computed columns are derived columns based on the other existing columns. Computed columns are data types can create based on the situation.
Rakesh Kalluri
Jul 10, 2014
XML Data Type in Microsoft SQL Server
In this article, we will see about XML data type in Microsoft SQL Server 2005.
Ratnesh Singh
Apr 14, 2009
How to Encrypt and Decrypt Text
This article explains how to Encrypt and Decrypt text.
Syed Shakeer
Jan 21, 2011
Stored Procedure For Login Page and Custom Error Handling
This is a continuation of the previous article in which we used a generic handler to generate a CAPTCHA image.
Santosh Gadge
Jul 21, 2014
SQL Server Index
This article explains why SQL Server Index is so very important in the Database Management System.
Ripon Datta
Jul 09, 2013
SQL Injection In Dynamic SQL
In this article you will learn about SQL Injection in Dynamic SQL.
Jignesh Trivedi
Apr 17, 2016
Tips to Increase SQL Server Query Performance: Part 2
This article provides more tips to increase SQL Server query performance.
Pankaj Kumar Choudhary
Jun 15, 2015
SQL CLR For Beginners: Part 2: Create Trigger in SQL-CLR Project
In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).
Sourav Kayal
Sep 01, 2013
Insert Rows Using User Defined Table Types
In this article I am going to explain how to insert multiple rows using a user defined table type.
Sandeep Singh Shekhawat
Dec 03, 2012
How to Store Date and Time in Separate Columns in SQL Server 2005
In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.
Deepak Sharma
Mar 29, 2012
Distributed Database Management Systems
I will illustrate the principles of Distributed Database Management Systems through this article.
John Charles Olamendy
Dec 17, 2008
SQL Server 2008 R2 on Windows 8 Error 17058 When Starting the Service
Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.
Amit Choudhary
Mar 08, 2013
@@ Identity Vs ScopeIdentity Vs Ident_Current in SQL
This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.
Jasminder Singh
Nov 29, 2014
Differences Between SCOPE IDENTITY, IDENT CURRENT, and IDENTITY in SQL Server
In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008
Mahesh Alle
Jun 24, 2013
No Records Available.
201
-
220
of
370
<<
9
10
11
12
13
>>
Mastering SQL
Challenge yourself
SQL Skill
E-Book Download
Get Certified
Node.js