Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
There are plenty of tools to compare database schemas. But why using them while SQL Server provides everything for you through System Views (check my blog How to check the schema of your Database through queries )? This blog shows you how to do that....
In my previous post, How to check the schema of your database through queries , I talked about how to check the schema of the database. In this post, we are going to talk about how to use that to build a Search Engine for the Database, to search in all...
How to convert rows into columns? We're going to see how to do that using query, and there is the "Pivot" function in SQL Server 2005. The easiest way is when you know the columns which are fixed. But most of the times, you want to do that in general...
One nice thing is to be able to check and to query the schema of your database through writing simple queries and not through code. For example, if you want to change a table structure or delete it, you want to find all the SPs and Views that use this...
More Posts
