I have a proc which creats ##tempb but does not drop it until the next execution. my question is does SSMS keep that table in the TABLE view or someplace else. Even after a refresh i dot see it in the list view but I knows it's still there because i can select off it
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…