Code Simplified – Viral Sarvaiya

Code Simplified – Viral Sarvaiya, Web Developer Friends, dot net Developer, Sql Server Developer

Blog Stats
- 96,898 hits
Facebook Like
Use full links
My Stackoverflow Feeds
- Horizonal bar chart connect with trend line in silverlight telerik chart control March 30, 2013
  We are using silverlight4 telerik controls. we want to create horizontal bar chart with connected line of each bar at top like below image. how can we achieve this in it. we can achieve this in vertical bar chart. but in horizontal bar chart we cannot do.
  Viral Sarvaiya
- data-stretch True/false in kendo UI for Map and Chart in same View March 20, 2013
  we are Using kendo UI for IOS application. I have a problem in data-stretch. I have one data-role="view" with data-stretch="true". in that view i have 2 DIV tag, 1st Div with id="googleMap" which display Google Map 2nd Div with id="dashboard" which displays 2 chart and 2 tabular format data. if i use data-stretch= […]
  Viral Sarvaiya
- change file security permission for azure website February 12, 2013
  I have one wordpress website custom template website and i have uploaded that website in window azure website, in Window azure, i create new custom website with database, with following scale option. I have uploaded all files with FTP. Now i have to change file permission of all file to read only but i have not getting any option. How can i change file permi […]
  Viral Sarvaiya
- How to solve Memory leakage in windows multiple threading application December 1, 2010
  Actually I am working on real-time application with multiple threads. While I am running my application memory is 65 Mb and if I open a child MDI form then memory increases to 85mb but if I close the child window then memory will still remains at 85mb. I have used Dispose and I've already tried with GC.Collect(), but none of these solve my problems, so […]
  Viral Sarvaiya
- Answer by Viral Sarvaiya for Import data from excel to sql server C# Application November 26, 2012
  http://www.sqlservercentral.com/articles/Excel/64838/ hope this link will helps you..
  Viral Sarvaiya
- Answer by Viral Sarvaiya for JavaScript in StringBuilder September 28, 2012
  StringBuilder Sb = new StringBuilder(); Sb.Append("alert('Finished');"); Page.ClientScript.RegisterStartupScript(this.GetType(), "", Sb.ToString(), true);
  Viral Sarvaiya
- Answer by Viral Sarvaiya for SQL column showing -1 if column is nothing inserted September 26, 2012
  make that column null-able and don't set default value for that column and in asp.net page check if there are null then replace that to bank or "none"
  Viral Sarvaiya
- Answer by Viral Sarvaiya for SQL Server Empty Result September 17, 2012
  alternet way is from code, you can check count of DataSet. DsData.Tables[0].Rows.count > 0
  Viral Sarvaiya
- Answer by Viral Sarvaiya for HttpContext.Current.Request.UserHostAddress is null October 6, 2011
  to avoid this problem you can parse the HTTP_X_FORWARDED_FOR for the last entery IP. ip=Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ; if (!string.IsNullOrEmpty(ip)) { string[] ipRange = ip.Split(','); int le = ipRange.Length - 1; string trueIP = ipRange[le]; } else { ip=Request.ServerVariables["REMOTE_ADDR"]; } Hope this wil […]
  Viral Sarvaiya
- Answer by Viral Sarvaiya for While downloading a file need to show progressing September 3, 2012
  http://www.dreamincode.net/forums/topic/115491-download-file-asynchronously-with-progressbar/
  Viral Sarvaiya
Visual Studio Achievements

Viral’s Blogs

RSS - Posts
RSS - Comments
Recent Posts
- Convert data from Generic List to DataTable.
- Find Difference between 2 dates in Year, month, day, hour, minute, second and millisecond.
- Delete multiple Procedure/Table/Trigger form sqlserver database
- Handling Window services thru C#
- String.Split – by Multiple Character Delimiter in C#.Net
- Find Foreign Keys in Sql Server
- Search Particular Text used in Data of All Tables of database in Sql Server
- Search Particular Text used in Stored Procedure in Sql Server
- Difference Between LINQ to SQL and Entity Framework
- Comparison/Difference of IPv4 and IPv6
Top Rated
Categories
- .Net (29)
- ASP.NET (113)
- asp.net feature (13)
- C# (2)
- General (16)
- Javascript (20)
- Jquery (1)
- LINQ (5)
- Report (1)
- RIA WCF (6)
- Silverlight (17)
- Sql Server (39)
- Visual Studio (8)
- WCF Services (5)
- Window Service (2)
- WPF (7)
Archives
- May 2013 (2)
- December 2012 (1)
- November 2012 (1)
- October 2012 (2)
- September 2012 (2)
- August 2012 (1)
- July 2012 (3)
- June 2012 (1)
- May 2012 (3)
- April 2012 (1)
- March 2012 (1)
- February 2012 (2)
- January 2012 (4)
- December 2011 (4)
- October 2011 (1)
- September 2011 (2)
- August 2011 (2)
- June 2011 (2)
- May 2011 (5)
- April 2011 (2)
- February 2011 (2)
- January 2011 (3)
- December 2010 (3)
- November 2010 (2)
- October 2010 (9)
- September 2010 (8)
- August 2010 (6)
- July 2010 (4)
- June 2010 (5)
- May 2010 (6)
- April 2010 (5)
- March 2010 (3)
- February 2010 (5)
- January 2010 (3)
- December 2009 (6)
- November 2009 (9)
- October 2009 (13)
- September 2009 (10)
- August 2009 (5)
- July 2009 (24)
- June 2009 (2)
- March 2009 (9)
- February 2009 (1)

Stack Overflow
Google Buzz
Twitter
Viral Twitter
- Convert data from Generic List to DataTable. nblo.gs/L2Wn7-- 2 weeks ago
- Find Difference between 2 dates in Year, month, day, hour, minute, second and millisecond. nblo.gs/KSGIQ-- 2 weeks ago
- Delete multiple Procedure/Table/Trigger form sqlserver database nblo.gs/FWTqt-- 5 months ago
- Handling Window service thru C# nblo.gs/F5NYO-- 6 months ago
- String.Split – by Multiple Character Delimiter in C#.Net nblo.gs/E8Dcx-- 6 months ago
Follow @viralsarvaiya
Follow Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 44 other followers
Beyond Relational
Top Posts
- Difference between ExecuteQuery And Execute NonQuery
- Interop type cannot be embedded. Use the applicable interface instead
- Convert Text in to Image using C#
- Multilanguage Application in WPF
- Background Image in PDF File with ItextSharp in Asp.Net
- Text to speech in asp.net with C#
- Detect browser F5 / refresh and X / Close in javascript
- DataTable to CSV File and CSV file to Dataset in asp.net
- Ways to check whether a trigger exists in SQL Server
- Get CheckBoxList values using Javascript
Top Clicks
- oratransplant.nl/2007/10/…
- viralsarvaiya.wordpress.c…
- petermcg.wordpress.com/20…
- somewebguy.wordpress.com/…
- petermcg.wordpress.com/20…
- tbs-apps.com/lsacreator
- 15seconds.com/issue/02010…
- dotnetbyexample.blogspot.…
- dnzone.com/go?234
- codeprojectdownload.com/a…
- neorack.com/?p=10290
- c-sharpcorner.com/UploadF…
Tags

.net Ajax ASP.NET Bitmap C# Cookies custom paging Datagrid Datalist dataset datatable date Excel Gridview HTML image image resize Import Excel file Javascript linq PDF Pl/Sql RIA Silverlight SQL SQL Query Sql Server sql server 2005 Stored procedure textbox time Transact SQL T-SQL T SQL URL validation Visual Studio 2010 WCF WCF and silverlight WCF RIA WCF RIA Services WCF Services Web Service Windows Communication Foundation Windows Presentation Foundation WPF
Blogroll
- .NET Media Handler Pro — Encoding Detail: Media Handler Pro is an .NET video encoding and video publishing tool for converting videos and audios from any format to another format, extract audio, grab thumbnails, split video into small clips and post watermark on videos in real time using .NET app 0
- Currency Conversion this page show you the currency conversion example and other many examples of the java script and more other 0
- java scripts This page gives you access to all of the java scripts 0
- Wordpress.com 0
- Wordpress.org 0
Tags

.Net ASP.NET asp.net feature C# General Javascript Jquery LINQ Report RIA WCF Silverlight Sql Server Visual Studio WCF Services Window Service WPF

Posts Tagged ‘SQL Index’

RESEED/Reset Table Identity Value in sql server

Posted by Viral Sarvaiya on January 6, 2012

DBCC CHECKIDENT can reset the identity value of the table,

For example if table has 500 reords and not we want to delete all records or want to start data from 600 then this command will help us.

DBCC CHECKIDENT (Table_name, reseed, 0)

DBCC CHECKIDENT (Table_name, reseed, 600)

Most of our identity we start with 1 so must have to take care that identity set to 0.

If identity is set below values that currently are in table, it will violate the uniqueness constraint as soon as the values start to duplicate and will generate error.

Enjoy…

Posted in Sql Server | Tagged: Identity, RESEED, Reset, SQL, SQL Index, SQL Performance, SQL Query, SQL Scripts, SQL Security, Sql Server, SQL Tips and Tricks, T SQL | Leave a Comment »

Follow “Code Simplified - Viral Sarvaiya”

%d bloggers like this:

	Edison on The “CreateRiaClientFile…
	Edison on The “CreateRiaClientFile…
	Fareed on Detect browser F5 / refresh an…
	Viral Sarvaiya on Get CheckBoxList values using…
	JEEGNESH on Get CheckBoxList values using…

Code Simplified – Viral Sarvaiya