Loading
SQL For Beginners - SELECT Statement
This article will help you to learn about SELECT statements in SQL.
Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
This article will help you to learn about SELECT statements in SQL.
In this article, I will explain how to merge multiple rows into a single row using SQL 2005.
In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.
SQL Server 2008 introduced Filtered Index. It is nothing but an optimized non-clustered index.
Learn about the SQL SELECT DISTINCT statement and its uses for retrieving unique data in SQL. Get expert insights on how to implement select distinct SQL queries
In this article, we will learn how to validate a numeric parameter value. In the previous article, you saw how to validate a date parameter SSRS parameter validation using custom code.
In this article I'll show you how to search a column value in all the referencing tables.
In today’s article, we will learn how to call store procedure and user-defined function ( UDF in Database) from store procedure.
This article lists some important SQL Best Practices with examples.
In this article I provide a quick overview of how to use Filter Setting in SQL Server.
In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement
In this article, we will discuss how to get the port no of our own SQL Server instance and how to use that port in the SQL Server setting, and at the end how to use that port in your C Sharp application.
This article discusses how to create databases and tables in MySQL. More emphasis is placed on how to get the details of the latest inserted ID and also the usage of appropriate functions in the case of concurrent insertions by multiple users.
This article explains Inversion of Control and Dependency Injection. Inversion of control is a principle and dependency injection is a way of implementing inversion of control.
In this article, you will learn how to use Index Table variables in SQL Server.
This article shows how to create a subquery to a select statement in SQL Server.
In this article we will learn how to use traditional C# class within SQL-CLR Application.
In this article we will see how to create a simple function in a SQL-CLR Project.
In this article, we create a database in SQL Server and install ASP.NET membership services then install an ASP.NET Memberships Services Database.
How to Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase.
In this article I will demonstrate Binary_Checksum, the Alternate of NewID() to fetch random records in an SQL Server.
In this article, you will learn about Complex SQL queries with the split() function 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 on a database table.
This article discusses how to create and manage triggers in a database using SQL.
In this article, you will learn how to add primary key in an existing table.
In this article, we will see about XML data type in Microsoft SQL Server 2005.
Build a SQL Server stored procedure for ASP.NET login authentication, including CAPTCHA validation, failed-login tracking, account locking, session handling, and login error messages.
This article explains why SQL Server Index is so very important in the Database Management System.
Everything on SQL, not only its articles: the SQL page →
Mahesh Chand9 videos · 23 news posts+5.3Kpoints2
Aarav Patel21 articles · 1 reaction received+2.1Kpoints3
Ananya Desai21 articles · 1 reaction received+2.1Kpoints4
Riya Patel20 articles · 1 reaction received+2Kpoints5
Bhavya Singh20 articles+2KpointsFull leaderboard →
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterMembers onlyWrite an article and earn +1,000 SHARP when it is approved.
Write an article
