Scripts

Technical Article

Simple T-SQL implementation for running SSRS subscriptions.

I created this stored procedure to be able to run SSRS subscriptions using T-SQL code instead of adding a component in the SSIS package with the subscription id. Let's say we have a set of report subscriptions named like this: ClientReport1, ClientReport2, ClientReport3. To run them using the stored procedure, all we need is this […]

5 (1)

You rated this post out of 5. Change rating

2023-11-29 (first published: )

734 reads

Technical Article

How to Move a Table into a Schema in T-SQL

To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]

You rated this post out of 5. Change rating

2023-09-29 (first published: )

1,682 reads

Technical Article

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on the database system you are using, there might be some limited string manipulation functions available that can help you perform basic validation checks.

2.33 (3)

You rated this post out of 5. Change rating

2023-07-28

288 reads

Blogs

Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým

By

The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Read the latest Blogs

Forums

SQL Server Admin Role Alert Script

By SQLShark

Comments posted to this topic are about the item SQL Server Admin Role Alert...

Sessions and CPU Threads

By Alejandro Santana

Hello everyone, I've got a question when it comes to best practices about application...

Sum Nested Join Help

By beantownace

Hello all, I have a query where I am trying to do a left...

Visit the forum

Question of the Day

A Valid Type?

What happens when I run this code in SQL Server 2019?

DECLARE @variable CURSOR;

See possible answers