Profile cover photo
Profile photo
Tamatam Reddy
12 followers -
I am Just a Human Being with Ethics
I am Just a Human Being with Ethics

12 followers
About
Posts

Post has attachment
How to Update the Metadata of an Object in SQL Server
SQL SERVER sp_refreshsqlmodule to Update the Metadata of an Object Whenever you modify the underlying objects (Tables, columns, datatypes etc) of any non-schema-bounded Stored Procedure, View or an User-defined Function, mostly due to customization then you...
Add a comment...

Post has attachment
How to Split a Single column into Multiple columns in SQL Server
XML Method to Split a Single column into Multiple columns in SQL Server Suppose We have a Table called Tbl_EMP with columns Emp_Id , Emp_Name where the EMP_Name have the FirstName,MiddleName and LastName combined by the delimiter "_" underscore as follows :...
Add a comment...

Post has attachment
SQL Server WHILE Loop with BREAK and CONTINUE Keywords
WHILE Loop to Insert Dynamic Date Values into the Table in SQL Server WHILE Loop statement is used to loop through the body to execute till the Condition evaluates to False. Since the WHILE condition is evaluated before entering the loop, it is possible tha...
Add a comment...

Post has attachment
How to Create a View with Schema Binding in SQL Server
Creating a View with SchemaBinding in SQL Server The SHEMABINDING is essentially takes the things that your VIEW is depend upon(Tables/other Views), and "Binds" them to that View. The significance of this is that, no one can make alteration(ALTER/DROP) to t...
Add a comment...

Post has attachment
How to Protect the Code in View or a Stored Procedure with Encryption in SQL Server
Protecting the Code in View or a Stored Procedure with Encryption in SQL Server If you wants to Protect(Not able to view) your Source Code of your View/Stored Procedure in SQL Server, you can do it by declaring the "With Encryption" option as explained belo...
Add a comment...

Post has attachment
How to Handle Runtime Errors in VBA with On Error GoTo Label
On Error GoTo Label to Handle Runtime Errors in VBA Error Handling refers to the code that is written to handle errors which occur when your application is running. These errors are normally caused by something outside your control like a missing file, data...
Add a comment...

Post has attachment
SSIS For Each Loop Container Task to Load Multiple Text Files Data to SQL Server Destination
SSIS ForEach Loop Container Task to Load Multiple Source Text Files Data to SQL Server Destination ForEach Loop Container is used repeat the tasks in a Pacakge. For example load data from each file in a directory to the destination table. Example : Suppose ...
Add a comment...

Post has attachment
How to Send a Range from an Active Sheet in an Outlook Email Body from Active Workbook with VBA
VBA Macro to Send a Range from an Active Sheet in an Outlook Email Body from Active Workbook Sub Mail_Selection_Range_Outlook_Body()     Dim Rng As Range     Dim OutlookApp As Object     Dim NewMail As Object     Set Rng = Nothing     On Error Resume Next  ...
Add a comment...

Post has attachment
How to Send Active Sheet as an Outlook Email Attachment with VBA
VBA Macro to Send Active Sheet as an Outlook Email Attachment from Active Workbook The following Macro will copy the Active sheet data from the This/Active Workbook to a New Workbook with single sheet and Save that with Active sheet name, then it will send ...
Add a comment...

Post has attachment
SQL Server Pivot Operator Syntax with Examples
SQL Server Pivot Operator The Pivoting is an operation that transforms the data from rows to a state of columns to pivot the data used for different reporting needs to summarize and analyze the data. The Pivot helps to you fit the certain amount of data in ...
Add a comment...
Wait while more posts are being loaded