Blogspot - smsaxena.blogspot.in - Shailendra Saxena
General Information:
Latest News:
ASP.NET Ajax framework failed to load client side framework 12 Oct 2012 | 07:26 pm
ASP.NET Ajax framework failed to load client side framework I face below errors at a same time. ASP.Net Ajax framework failed to load client side framework Microsoft JScript runtime error: 'Sys' is ...
Basic LINQ Query 4 Oct 2012 | 08:31 am
LINQ Queries Normal 0 false false false EN-US X-NONE X-NONE Basic LINQ Query Operators From (Specify the Data Source) In LINQ query first step is to specify the data source that you want to...
LINQ Data Providers 3 Oct 2012 | 07:12 pm
Normal 0 false false false EN-US X-NONE X-NONE LINQ Data Providers The Following lists the core data types LINQ supports in the .Net Framework Provider Description LINQ to Objects The LIN...
Sql Server Function Returns date in YYYYMMDD Format 16 Aug 2012 | 09:00 pm
Create FUNCTION [dbo].[fn_YMDDate] ( @dateParam varchar(10) ) RETURNS Varchar(10) AS BEGIN DECLARE @Return Varchar(10) Declare @YYYY varchar(4) Declare @MM varchar(2) Declare @DD varchar(2) De...
WCF Tutorial -Contracts 25 Jul 2012 | 02:18 pm
Normal 0 false false false EN-US X-NONE X-NONE WCF-Contracts WCF (Windows Foundation Communication) is a platform can be used to build service oriented applications. We can send data as asyn...
SQL Server 2012 : New TSQL Features 22 May 2012 | 03:03 am
New T-SQL Features in SQL Server 2012 /* 1. IIF Function*/ DECLARE @a int = 10; DECLARE @b int = 40; SELECT IIF ( @a > @b, 'TRUE', 'FALSE' ) AS Result; /* 2. CHoose Function*/ SELECT CHOOSE (...
Alter table Change Data Type in SQL Server 21 May 2012 | 05:52 pm
Hi, Following are the few inportnat queries whih is needed when one need to alter table. 1. Alter table and change data type. alter table tbldelegates ALTER COLUMN de_lastname VARCHAR(50) 2. alter ...
Searching text in Stored procedures 7 May 2012 | 06:13 pm
SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE '%ms_redo%' AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)
Collation issue : Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation. 24 Mar 2012 | 08:29 pm
Hi, I faces issue Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation. My application is developed for English and Chinese ...
How to Restore SQL Server 2005 Suspect Database 8 Feb 2012 | 10:32 pm
EXEC sp_resetstatus 'yourDBname'; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb('yourDBname') ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('yourDBname', REPAI...
