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 […]
2023-09-29 (first published: 2023-09-18)
1,266 reads
Csv files must frequently be joined. It would be fantastic if we could connect CSV files using the power of SQL. This script accomplishes that.
2023-09-18 (first published: 2023-08-28)
1,495 reads
Very often there is a need to create test data manually. This script will provide a mix of names that will make more sense rather than randomly generating meaningless names.
2023-09-11 (first published: 2023-08-24)
596 reads
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
801 reads
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.
2023-07-28
272 reads
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2023-07-18 (first published: 2010-05-13)
1,775 reads
2023-07-18 (first published: 2010-03-18)
2,022 reads
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
1,387 reads
2023-07-18 (first published: 2009-03-13)
2,053 reads
2023-07-18 (first published: 2012-12-04)
1,573 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Comments posted to this topic are about the item LOGON Trigger Count
Comments posted to this topic are about the item Invisible Downtime
Comments posted to this topic are about the item Empowering Lakehouse Users – Data...
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers