Additional Articles


Technical Article

AdeptSQL Workshop released

Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.

2002-02-25

3,342 reads

Technical Article

SQL Server Beta Programs!

SQL Server is releasing two Beta products this month, a 64-bit version of SQL Server 2000 and service pack 4 for SQL Server 7.0! Note: Liberty requires that customers have access to 64-bit machines. Participating in a SQL Server Beta program can be a lot of fun, with contests, promotions, newsgroup support with members of the SQL team at Microsoft, etc. Come sign up today!

2002-02-11

3,269 reads

Technical Article

Support WebCast: How to Connect to Analysis Services over the Internet

See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.

2002-02-08

1,215 reads

SQLServerCentral Article

SQLServerCentral.com Launches its New Contest!

Is your budget tight this year? Be the user who enriches the SQL Server community the most and receive the top prize of a full version of Lumigent's Log Explorer (a $995 value!). You could also win an Apress prize pack or a T-SQL Solutions subscription. Any SQLServerCentral.com user who helps to build the SQL Server community by submitting a script, posting in the forum or posting an original FAQ is eligible.

You rated this post out of 5. Change rating

2002-02-01

26 reads

Blogs

Another Change

By

Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...

Using Prompt AI to Help Setup Data Analysis

By

I used Claude to build an application that loaded data for me. However, there...

NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware

By

End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...

Read the latest Blogs

Forums

Simplifying WHERE Condition with LIKE test on multiple columns

By Reh23

Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...

Which Table I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Table I

Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Using Python notebooks to save...

Visit the forum

Question of the Day

Which Table I

I have this code in SQL Server 2022:

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

See possible answers