You can search for a particular column that present in the list of database tables in sql server.
SCHEMA_NAME(SCHEMA_ID) + '.' + TBL.NAME AS TableName,
COL.NAME AS ColumnName
FROM SYS.TABLES AS TBL
INNER JOIN SYS.COLUMNS COL
ON TBL.OBJECT_ID = COL.OBJECT_ID
WHERE COL.NAME LIKE '%ENTER COLUMN NAME%'
ORDER BY 1
Query to search for particular column from sql database was last modified: October 10th, 2017 by Justin Antony
simple SSRS report
New -> Project -> Report Server Project -> Right click on Shared DataSet -> Add New Data Source
Right click on Report Folder -> Add New Item
In the Report Data Tool Bar -> Right Click on the Data Sources -> Select the shared Data Source which we created already
Right Click on the Data Set -> Add DataSet -> Define your query here
Drag and Drop a table
Pick the Data fields from dataset and place it on the table.
Align and format the Table Accordingly
Add header to your Report.
Save and Run the Report.
How to create a simple report ? was last modified: October 1st, 2017 by Justin Antony
To troubleshoot an SSIS Package we use the breakpoints.
Right click on any task in control flow and then select Edit Breakpoint, This will display a Breakpoint window. choose when the execution to be paused(OnPreExecute, OnPostExecute, OnError events). This will be helpful to see the values of a variable at runtime using the output window.
What is a SSIS breakpoint and how to configure it? was last modified: October 1st, 2017 by Justin Antony
Its a set of T-SQL statements combined to perform a single task. There should be only one select statement at the end of the procedure. This select statement will be return as an output.
What is a Stored Procedure? was last modified: October 1st, 2017 by Justin Antony