ITDevSpace - Development Tips & Tricks

This is happening when you install IIS after .Net 2.0 Framework. Just reinstall Asp.Net. c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i

Click here to see improved version of this script using try/catch syntax USE [MyDatabase] GO PRINT ' DROP PROCEDURE [usp_mysproc] ' GO if exists ( select * from dbo.sysobjects where id = object_id(N' [dbo].[usp_mysproc] ') and OBJECTPROPERTY(id, N' IsProcedure ') = 1) drop procedure [dbo].[usp_mysproc] GO PRINT ' CREATE PROCEDURE [usp_mysproc] ' GO CREATE PROCEDURE [dbo].[usp_mysproc] AS BEGIN TRAN DECLARE @errorNo int , @ rowCount int , @errorStr varchar (4000) DELETE FROM Table 1 Where SampleDate < getdate() SELECT @errorNo = @@ERROR, @ rowCount = @@ ROWCOUNT IF @errorNo <> 0 BEGIN SET @errorStr = ' Error deleting old load records "load_Master" ' GOTO ErrHandler END COMMIT RETURN 0 ErrHandler: ROLLBACK DECLARE @procName sysname SELECT @procName = object_name( @@procid ), @errorStr = ISNULL( @errorStr, ' Unknown error ' ) IF @errorNo <> 0 BEGIN

Returns information about the members of a role in the current database. exec sp_helprolemember Returns information about user permissions for an object in the current database. exec sp_helprotect [ Table / View / Procedure ] Returns information about the roles in the current database. exec sp_helprole For more info check Microsoft MSDN page.

This statement deletes data from Table1. This is useful if you have a join with multiple tables or multiple columns. DELETE Table 1 FROM Table 1 t1 JOIN Table 2 t2 ON t1.Id1 = t2.Id1 AND t1.Id2 = t2.Id2

CASE Column 1 WHEN 1 THEN Column 2*1 WHEN 2 THEN Column 2*2 ELSE Column 2 END as MyColumn, -- or CASE WHEN max ( Column 1) = 1 THEN Column 2*1 WHEN max ( Column 1) = 2 THEN Column 2*2 ELSE Column 2 END as MyColumn,

GP - price/volume graph G - graph templates HP - historical prices CFTC - commodity futures traders commitment BLP - bloomberg launchpad IAM - user information FLDS - field finder FPRP - field info (older) ALT-D - terminal defaults ALT-L - list bloomberg keys PRTL - Client Services Portal (submit a query, technical docs) CACS - Corporate Action Calendar POSH - Bloomberg Marketplace (cars etc..)

This sample shows how to copy data from table A to table B based on multiple join columns. INSERT INTO B( Value 1, Value 2) SELECT DISTINCT Value 1, Value 2 FROM A t1 WHERE NOT EXISTS ( SELECT 1 FROM B t2 WHERE t1. Value 1 = t2. Value 1 AND t1. Value 2 = t2. Value 2)

Sample table with identity column. CREATE TABLE [dbo].[ Table 1]( [Id] int IDENTITY (1,1) NOT NULL , [ Value ] [ varchar ](10) NOT NULL , CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) C# code than inserts data to database and gets generated id back. class TestInsertDao : AdoDaoSupport { private string insertSql = @" INSERT INTO Table1(Value) VALUES(@Value) SET @Id = SCOPE_IDENTITY() "; public TestInsertDao(IDbProvider dbProvider) { this .DbProvider = dbProvider; } public int Insert( string value ) { IDbParameters parameters = CreateDbParameters(); parameters.Add(" Value ", DbType.String).Value = value ; parameters.AddOut(" Id ", DbType.Int32); AdoTemplate.ExecuteNonQuery(CommandType.Text, deleteSql, parameters); return ( int )parameters[" @Id "].Value; } } To get more info on C# spring setup refer to this post Using Spring.NET to load data to DataTable

This is a short form 32 characters GUID System.Guid.NewGuid().ToString("N")

Run one of these queries to check if there are any SPIDs with Blocked Status or High CPU time. It also shows the hostname, loginname, logintime info. SELECT * FROM sys.sysprocesses -- or this one Sp_who 2 Run this command to get the SQL for a SPID DBCC INPUTBUFFER (<SPID>) Run this command to get more info about the lock EXEC SP_LOCK <SPID>

class MyClass { private readonly Dictionary< string , object > data = new Dictionary< string , object >(); public object this [ string index] { set { data[index] = value ; } get { return data[index]; } } public static void Main() { MyClass me = new MyClass(); me[" test "] = " sample value "; Console.WriteLine(me[" test "]); } }

public class MyClass { public static void UseParams(params int[] list) { for ( int i = 0 ; i < list.Length ; i++ ) { Console.Write(string.format("{0},",list[i])); } } public static void Main() { UseParams(1); //1, UseParams(1,2,3); //1,2,3, } }

Directory separator character can be found in Path class. Console.WriteLine("Path.AltDirectorySeparatorChar={0}", Path.AltDirectorySeparatorChar) Console.WriteLine("Path.DirectorySeparatorChar={0}", Path.DirectorySeparatorChar) Console.WriteLine("Path.PathSeparator={0}", Path.PathSeparator) Console.WriteLine("Path.VolumeSeparatorChar={0}", Path.VolumeSeparatorChar) ' Path.AltDirectorySeparatorChar=/ ' Path.DirectorySeparatorChar=\ ' Path.PathSeparator=; ' Path.VolumeSeparatorChar=:

To find the application directory (were exe file is) during runtime use this: AppDomain.CurrentDomain.BaseDirectory

SctottGu's Blog about the new ASP.NET 3.5 Charting Control

This is a very useful tool for Windows XP that enables to you open command line window from context menu. Just right click on any folder and select Open Command Window Here . You can download it from the PowerToys Windows XP page. This works only for x86 system, to add context menu item to x64 machine follow these steps .

I think this page has a decent discussion about pros and cons of both technologies.

- Add referece to log4net.dll file - Add log4net configuration to App.config file  <? xml version="1.0" encoding="utf-8" ?> < configuration > < configSections > < section name = "log4net" type = "log4net.Config.Log4NetConfigurationSectionHandler,log4net" /> </ configSections > < log4net > < appender name = "RollingFileAppender" type = "log4net.Appender.RollingFileAppender" > < param name = "File" value = "Log\\MyProject.log" /> < param name = "AppendToFile" value = "true" /> < param name = "RollingStyle" value = "Size" /> < param name = "MaxSizeRollBackups" value = "10" /> < param name = "MaximumFileSize" value = "500KB" /> < param name = "StaticLogFileName"

Assuming that you have 2 projects in your solution MySolution + MyProject + MyProjectTest Add the following line to AssemblyInfo.cs in MyProject [assembly: InternalsVisibleTo("MyProjectTest")] This will allow you to access internal classes from MyProjectTest(unittests) project