Lab Sql

I create a view like this SELECT dbo.BaharInOut.BCode, dbo.Bahar.BName FROM dbo.B… Read more Detect Sql-view Structure

EDIT: Database names have been modified for simplicity I'm trying to get some dynamic sql in pl… Read more Sql Update With Dynamic Column Names

I know that so far (until MSSQL 2005 at least), system databases are master, model, msdb and tempdb… Read more Sql Server: How To Tell If A Database Is A System Database?

I have a type which I'd like to change but I don't know who else is using it. How can I che… Read more How To Check Which Function Uses A Type?

I have a small problem. I am working with some manual testers who are untrained in programming/data… Read more Creating A Site To Query A Database Of Tables

I'm aware of this topic ( Find a specific column in an unknown table in a database? ) and my pr… Read more Find A Specific Column Entry In An Unknown Table In A Database?