Passing a Table to A Stored Procedure
In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.
Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
Introduction to MDX Scripting in Microsoft SQL Server 2005
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.
Using Indexes to Bypass Locks
One of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
Custom Log Shipping
This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.
The T-SQL Quiz
Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.
Configure SQL Server Service Broker for Sending Stored Procedures
Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Finance Padang Layanan Mobil Telpn/wa (08218171891)
Jl. Sawahan No.55 Blok A-B, Sawahan, Padang Timur, Padang City, West Sumatra 25171
BCA Finance Medan Layanan Motor Telpn/wa (08218171891)
Telpn/wa (08218171891) Ruko Bisnis Center, Jl. Ring Road No.A10 11, RW.AJB 525, Tj. Rejo,...
BCA KCP Labuan Bajo WhatsApp 08388331786
WhatsApp 08388331786.Kawasan Komersial Marina, GF A6, Labuan Bajo, Kec. Komodo, Kabupaten Manggarai Barat, Nusa...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers