SQL is a standard language designed for managing data in relational database management system. SQL stands for Structured Query Language. SQL is a standard programming language specifically designed for storing, retrieving, managing or manipulating the data inside a relational database management system (RDBMS).
Copying SQL Databases, renaming is not as easy as it could be. Luckily the following script can make the effort much easier. Give it a try. After copying a SQL Server database I needed to create a new schema and transfer all tables and views and stored procedures from the old schema to the newly created schema. Using the following script made this task much easier.
Read More
Yes! There really are 6 ways to compare strings within .NET (I suspect other languages as well). Hopefully this will shed some light on the options.
Read More
Once you resolve the ability to save database diagrams, please note that in the next release of SSMS v18 Microsoft is deprecating database diagram feature. I don't quite understand this thinking however you can find more information in the release notes.
Read More
Before you rush to download SQL 2008 you may want to read the following KB article contained within this blog.
Read More
The following script will evaluate the table specified @TableName (you provide below), create a new table with {name}_Audit and also create insert, update and delete triggers. In my example my table was Dave_Test in scheme engis.
Read More
I had a need to mirror any changes to one Sql Server table to another Sql Server table of a different name. Read on.
Read More
Find all occurrences of the column in any object.
Read More
How to migrate data to Excel.
Read More
SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types - relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.
Read More