When you are inserting, updating, or deleting records from a table, SQL Server keeps track of the records that are changed in two different pseudo tables: INSERTED, and DELETED. These tables are normally used in DML triggers. If you use the OUTPUT clause on an INSERT, UPDATE, DELETE or MERGE statement you can expose the records that go to these pseudo tables to your application and/or T-SQL code.
2012-03-26
3,728 reads
Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.
2012-03-23
25,496 reads
SQL Server 2008 R2 brought several new features into the SSRS (SQL Server Reporting Services) arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports.
2012-03-23
4,108 reads
This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.
2012-03-22
9,936 reads
From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica.
2012-03-22
1,958 reads
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
2012-03-21
3,916 reads
SQL Saturday is hitting Dublin for the first time on March 24th.
2012-03-20 (first published: 2011-12-23)
5,626 reads
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2012-03-20
2,418 reads
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
2012-03-20
3,874 reads
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
5,921 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
While doing some housekeeping I came across a folder containing some scripts that appear...
Comments posted to this topic are about the item Why SQL Server Database Attach...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers