Masar Ivica


SQLServerCentral Article

Generating a Bar Code

SQL Server is asked to do many tasks, including scheduling processes, transferring data using DTS in an ETL process, sending mail, updating other systems, generating reports and more. However this one might a bit unsual: using SQL Server and T-SQL to generate a bar code. Ivaca Masar brings us this unique look at how you can stretch the limits of T-SQL.

You rated this post out of 5. Change rating

2005-02-08

13,824 reads

Blogs

Plan your 2026

By

If you don't have a plan, you'll accomplish it. That's not a good thing.

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...

Read the latest Blogs

Forums

advice on diving into devops for managing BI projects

By stan

hi , i know this is a sql server forum but i think my...

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

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