Category: Varinder Sandhu

Windows 7 – MSVCR71.dll file missing error

Varinder Sandhu, Window 7

If you are facing the error like MSVCR71.dll file missing in Windows 7 then you will find the fix of issue in this post. MSVCR71.dll is Microsoft C Runtime Library files and your program require this file to run successfully. Now you have to download MSVCR71.dll file from given download link Click here to Download MSVCR71.dll Installation of MSVCR71.dll file in windows  Windows 7 (32-bit) In Windows 7 (32-bit) you just need to copy MSVCR71.dll file under → Windows\System32 Windows

» Read more
,

Oracle Client Installation

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Installation Steps: Extract the OracleClientODBC-32Bit or OracleClientODBC-64Bit zipped folder according to the Machine (32bits or 64bits). Now set 4 environment variables at client machine as System Variable. My Computer Properties >> Advanced >> Environment Variables PATH: Set the path. Put ‘;’ at the end of existing path and give the path of folder where the files are extracted. LD_LIBRARY_PATH: New environment variable is created with the path of same folder. ORACLE_HOME:New environment variable if not present with same path. TNS_ADMIN:

» Read more
, , ,

Outlook – Arrange Email in Conversation / Thread

MS Office, Outlook, Varinder Sandhu

In the Microsoft outlook default sort order or email arrangement is Date wise. But you can change the sort order on from, subject, sent date /receive date categories many others. Many of us think how can we set the outlook email arrangement in conversation or thread like Gmail. In this post we will see how to arrange or mange your outlook emails in conversation/Thread. Go to Menu Bar -> View -> Arrange By -> Click Conversation. After the above mentioned

» Read more
, , , , , ,

Outlook 2007 – Managing email messages with Rules

MS Office, Outlook, Varinder Sandhu

Microsoft Outlook provides a really useful feature as “Rules and Alerts” for managing emails messages. What is Rule? One or more automatic actions taken on e-mail messages and meeting requests that meet certain conditions, along with any exceptions to those conditions. Rules are also referred to as filters. Rules help you manage your e-mail messages by performing actions on messages that match a specific set of conditions. After you create a rule, Microsoft Outlook applies the rule when a message

» Read more
, , ,

SQL Server – How Like operator work with datetime

SQL, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Today, my one of the friend shared a very interesting fact about like operator. With the help of this post I am sharing with you all. We need to convert it to character data while comparing with the like operator. Let‘s check with example Like operator with datetime Like Operator with datetime using convert function If anybody have any suggestion please share as comment.

» Read more
, ,

SQL Server – Authentication Mode – Windows Mode and Mixed Mode

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as Windows authentication mode: Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.  Even if you choose Windows Authentication mode during SQL Server installation “sa” user is created but disable for SQL Server Authentication. But later we you can use “sa” user by enabling for SQL Server Authentication .Any window user can configure as system administrator

» Read more
, , , ,

SQL Server – How to add column dynamically in where clause

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

In this post, we will learn with example how to add the column dynamically in where clause. Example: For demo we have table as shown in the snapshot Basically we want to execute following script (i.e. Script: 1) but column name (i.e. FIRST_NAME) added dynamically in where clause. Script: 1 SELECT * FROM EMPLOYEE WHERE FIRST_NAME = 'VARINDER' Created a table and insert the column name value (i.e. FIRST_NAME) as shown in the snapshot Now we will execute the Script:

» Read more
, ,

What is Guest Post?

Blog-News, Career Development, Others, Varinder Sandhu

Lot of detail information is available on the Guest Posting and its advantages. As I received few questions about guest post and it advantage that‘s why sharing a brief post/note on Guest Post.   Guest Post “A guest post is when someone other than the owner of a blog writes content, and the owner of the blog posts this content while giving credit to the original author, sometimes just by name and sometimes with a link to the content writer’s

» Read more
, ,

SQL Server – The multi-part identifier could not be bound State – Msg 4104 – Fix

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Error Msg Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier could not be bound. Cause of this Error Msg: Case: 1 This error usually occurs when an alias is used when referencing a column in a SELECT statement and the alias used is not defined anywhere in the FROM clause. Case: 2 This error occurs if we are using the tables from the two different databases in the join statement and not using the table alias

» Read more
, ,

Oracle – Import data from CSV file using SQL Loader

Oracle, Oracle-Tips and Tricks, Oracle-Utilities, Varinder Sandhu

In this post we will see how we can transfer the data from CSV to oracle database using SQL Loader. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can use SQL Loader utility to transfer the data for high performance. Syntax: sqlldr username@server/password control=control_file.ctl sqlldr username/password@server control= control_file.ctl Exmaple: Let‘s take a CSV file named as test_data.csv First we need to create a table where we want to transfer

» Read more
, ,

Oracle – Table Row count for all tables

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Here is a simple SQL script with the help we can find the Table Row count for all tables. Yes we can find the row count using select count(*) for each table. This will be useful if you large number of tables are there in your database. Example Script: — Create a table CREATE TABLE ROW_COUNT_ALL_TABLE ( TABLE_NAME VARCHAR2(100), ROW_COUNT VARCHAR2(100) ) — PL-SQL Block to count Row Count for all tables as you specify DECLARE V_ROW_COUNT VARCHAR2(100); V_SQL_STRING VARCHAR2(1000);

» Read more
, ,
1 2 3 4 5 6 … 23