DevSocial Articles · SQL Server articles

Joins in SQL Server are used to retrieve data from two or more tables with a joining condition. Learn how to use joins in SQL Server.

Abhishek YadavApr 16, 202352,4191,000

Learn how SQL Server temporary tables and table variables work, including local and global temp tables, TempDB storage, creation, and deletion.

Raj BhattApr 14, 20233,2291,000

In this article, you will learn how to synchronise Databases Using Microsoft Sync Framework.

Vipin MittalApr 12, 202313,2031,000

In this article, I will explain how you can copy your azure cloud database into your local server using SQL Server Management Studio 19. SSMS provides us export data tier option to copy the database.

Vijay Pratap SinghApr 11, 20233,9671,000

In this article, we will learn how to use configure Transactional replication in SQL Server.

Amit MohantyApr 10, 202343,7061,000

In SQL Server, a function is a named set of SQL statements that can be called and executed as a single unit.

This article provides a practical guide to SQL CTE (Common Table Expressions), complete with examples that demonstrate how to use this powerful SQL feature to improve query performance and simplify complex queries. It covers the basics of CTE, including syntax and usage, and also delves into advanced topics such as recursive CTEs and using CTEs to implement complex calculations. Whether you're a beginner or an experienced SQL developer, this article is a valuable resource for mastering the use of CTEs in your SQL queries.

Diwakar TiwariMar 31, 20235,5811,000

In this article, I will demonstrate how IIF function in SQL Server.

Jignesh KumarMar 27, 202312,1751,000

This articles helps you in understand that how inner queries works with relation to outer queries and what problems it can create if not used in proper manner.

In this article, we will see how to use @@IDENTITY and SCOPE_IDENTITY() in SQL Server 2012.

Rohatash KumarMar 10, 2023279,5371,000

In this article, you will learn about SQL Server execution plans.

Tural SuleymaniMar 10, 20234,0911,000

In this article, we will see how we can compare the comma-separated values with existing values stored in the table. Values can be in a different order from the user or table. We have to first order it both sides and then compare them.

Yogeshkumar HadiyaMar 9, 202313,9501,000

This article will help you to understand how to start to think on optimization of sql queries and why use indexes in tables

Tural SuleymaniMar 8, 20233,9491,000

In this article, you will learn about job scheduling in SQL Server and a job that runs automatically at your scheduled time.

Nirav DaraniyaMar 8, 202394,1781,000

In this tutorial, we are going to discuss how to schedule an SSIS SQL Job in SQL Server.

Sankara Krishnan VenugopalMar 8, 2023149,0101,000

In this article, we are going to discuss FOR XML Path Clause in SQL Server.

Kirtesh ShahMar 7, 202318,5691,000

In this article, you will learn about a detailed description of the primary key in SQL server.

Priyanka SinghMar 6, 202323,4701,000

Learn about schemas in SQL Server and how they can help you organize your database objects. Discover the benefits of using schemas and how to create and manage them in your SQL Server environment. Get started today and take your database management to the next level.

Jignesh TrivediMar 3, 2023198,8131,000

In this article I describe the Transact-SQL security functions SUSER_ID , SUSER_NAME , SUSER_SID , SUSER_SNAME and SYSTEM_USER.

Sharad GuptaMar 3, 202311,2241,000

In this article, I describe the Transact-SQL security functions IS_MEMBER , IS_SRVROLEMEMBER , LOGINPROPERTY, ORGINAL_LOGIN, and PERMISSION.

Sharad GuptaMar 3, 202310,6721,000

In this article, I describe the Transact-SQL security functions CURRENT_USER, HAS_DBACCESS, HAS_PERMS_BY_NAME, and HASHBYTES.

Sharad GuptaMar 3, 20239,1431,000

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is language-independent, easy to understand, and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.

Jignesh TrivediMar 3, 2023329,5791,000

SQL Server 2022, the latest version of Microsoft's popular relational database management system, comes with significant improvements to the performance of Tempdb.

Tuhin PaulMar 3, 202310,4351,000

Learn how to retrieve a previous row value in SQL Server using the LAG window function or a MIN function with a window frame.

Ishika TiwariMar 2, 202340,7231,000

Learn how to create a SQL Server view and update underlying table data through the view using an UPDATE statement.

This article explains how to create a SSRS report using a SQL parameterized Stored Procedure object.

Priti KumariFeb 28, 2023237,3091,000