TheSYSOBJECTStable houses a couple dozen columns of data since it must hold information about virtually everything added to the server over time. Therefore, to find a list of user-created tables (thus ignorings
Introduction If you’ve been developing in SQL Server for any length of time, you’ve no doubt hit this scenario: You have an existing, working query that produces results your customers or business owners say are correct. Now, you’re asked to change something, or perhaps you find out yo...
In this post, we are going to learn how to find out if the table is used in a Stored Procedure. we have multiple ways to do that. This System Stored Procedure will return you list of table/views used by the Stored procedure/View. You can pass the view name or Stored Procedure as p...
between the source table (oracle) and the destination table (sql server 2012). Just 1 source and destination table at first, eventually I'll have to do this with 120 tables. Any st...
how to find the square bracket character "[" or "]" in a query ? How to Fix Runtime Error 3197 in Microsoft Access 2010? How to get Access 16.0 Object Library How to get Current Login User ID in MS Access 2010 ? How to get list of source tables of a query in Access VBA ...
How to find which login/user has modified the record in a table in SQL server 2008. How to find which user has DBO right How to fix 'Error converting data type varchar to bigint.'? How to fix an error:"Cannot resolve the collation conflict between "Latin1_General_CI_AI" and..."?
The table below shows sales data for a company. There’s a lot of data in this table, so to start analyzing it and trying to find information on how sales are doing, we’re going to need to do some initial aggregations – using pivot tables!
I have done Oracle DBA, But new to Sql Server , User level knowledge is there, in my organization i got one inherited database from previous Developer he created database in that i see many tables with same name slight changes and almost same data it seems, i want to delete unnecessary...
Connect to SQL Server to the world database just created: Figure 17. Connection to SQL Server If everything is OK, you will be able to see the SQL Server databases: Figure 18. SQL Server databases in SSMA In MySql Metadata Explorer pane, select the tables that you want to export and ...
Read more on finding other SQL Server objectsList Foreign Keys referencing tables in SQL ServerWhat are the triggers in SQL ServerHow to find all identity columns in SQL ServerHow to find default values of all SQL Server columnsHow to find computed columns on a SQL Server table...