Loading
DevSocial Blogs · SQL Server blogs
Quick takes from developers at work.
Tips, fixes and short write-ups on what developers ran into this week, in their own words.
- Blogs
- 18,829
- Reads
- 471.6M
- Bloggers
- 3,370
Latest · 1,284 blogs
Quick takes from developers at work.
Tips, fixes and short write-ups on what developers ran into this week, in their own words.
In this blog, we learn how to calculate credit debit Transactions like banking report using SQL Sever.
In this blog create auto folder & auto backup using Xp_Cmdshell.
Search views, and stored procedures in a database with a specific name
in this blog, we can find the same name parameter used in procedure, we can get store procedure list by using DMV.
in this blog, find any content from procedure to checking the impacted procedure list.
in this SQL Script we learn & Prepare SQL Query for compare Source & Target Database
In this blog, we learn about SQL dynamic Table Partition.
in this blog, we learn about calling store procedure in select Statement like Table.
In this blog, we learn about how to tune Database & Tables by using SSMS Profile & SSMS Database tuning advisor.
We learn about sequence in SQL for Generating unique Number as per requirement Ex : Account Number (SBank_100001)
in this blog we learn how to use merge in SQL for Insert, update & delete Record as per merge conditionally for bult insert, update & delete bulk records From Source Table To Target Table
In this article we learn about convert complex json data to sql table in easy steps
In this blog, you will learn about bulk data Insertion in SQL Table using Union ALL.
Let's learn about the Logical operators with detailed examples in SQL Programming.
Search procedures on the basic of a column name. You can search only in Stored procedure and All objects as well. So, added 2 queries for the same.
In this blog we will learn the basic differences between Primary key, Unique key and Foreign key. Difference between Primary key and Unique key.
In this blog, you will learn how to export records from sql server to text file.
Create New Database with the help of existing database in same Microsoft SQL Server through the help of Procedure in Local Database.
In this blog, you will learn about SSIS Expression.
In this blog, you will learn how to retrieve Table and function from a procedure even in a dynamic query.
How to write effective sql queries and how to optimize it. Few new features of sql that should be handy for every Sql developer.
In this blog, you will learn about the store procedures in SQL server.
This blog is related to create New Database with predefine table.
The idea of this blog is to share the leanings from the incidents which I have faced during my 8 years of experience with SQL Server which will help developers to write optimized SQL Query with less performance issues.
In this blog, we will discuss how to find the highest salary, the second highest salary and N number of highest salaries with different examples.
Everything on SQL Server, not only its blogs: the SQL Server page →
Mahesh Chand9 videos · 24 news posts+5.5Kpoints2
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 a blog post and earn +250 SHARP when it is approved.
Write a blog
