Monday, April 7, 2014

Don’t you see print statement appearing while running stored procedure script as below?

The missing Go statement with yellow back ground is the cause of it.

CREATE PROCEDURE [dbo].[spGetEmployees]
@EmpId INT
AS
BEGIN
SET NOCOUNT ON

SELECT
E.EmpName,
        E.Designation,
        E.Salary
FROM
Employee
        WHERE Q.EmpId = @EmpId
END
GO

PRINT '[dbo].[spGetEmployees] is Created'
GO

Get data with column names from SQL Result set

Use copy with header and then press Ctrl +V in an excel.You will get column names too along with data.

Wednesday, July 31, 2013

Login to TFS Server or Other Server Automatically with out providing credentials daily

This is very interesting and useful.
Please follow below steps.
  1. Go to Control Panel  , Go to UserAccounts 
  2. Click on Credentials Manager
  3. You will find "Windows Credentials" section.
  4. Click on "Add a Windows credential" link.
  5. Enter the valid IP address and credentials and click on OK.
  6. From next time , you will login by default and need not enter credentials.

Tuesday, June 11, 2013

SQL Tips and Tricks


  1. Use Keyboard shortcuts in Tools->options for generating regular results sets like sp_helptext and sp_help.
  2. When you see ant procedure breaking the If condition logic even the business logic is fine , the best and foremost thing you need to do is to verify the DataType of the variable used in If condition.Remember if you mistakenly used bit for variable x and doing the comparison of integer say x>5 it always go to else condition.The reason the Bit contains 1 values in true case and 0 value in false case.

Tuesday, August 21, 2012

Make a ASP.LABEL MultiLine(Wrap text in Label)

Please use below code which makes MultiLine text box appear as Label ans suits the need.


 <asp:TextBox ID="txt1" runat="server" Text="RamanaRamanaRamanaRamanaRamanaRamanaRamanaRamanaRa"
        Wrap="true" Rows="2" ReadOnly="true" Width="208px" TextMode="MultiLine" BorderStyle="None"
        BorderWidth="0" Style="overflowhidden;resize:none;background-colortransparent;" />

Saturday, August 18, 2012

Jago Investor

This books helps you understand the finances better.
Its best for indians to start in the journey of achieving financial literacy.
Manish and Nandish did great job.

Code Complete 2 Book

I found this book suggested by all geeks as best one.
It has core principles of software building which helps to become a better programmer irrespective of the language you code.
I added this book in my reading list.