I am working on a database using SQL Server 2012. There is a table named Order has an auto Identity Column named OrderId datatype is int .I noticed that the sequence of the identity is just not right. It has jumped with 1000.After research about this issue, I found that...
The ASP.NET membership feature provides secure credential storage for application users.We will use the following:Web Page Named Login.aspx and another Web Page named CreateUser.aspxLogin Control.Create User Wizard Control.Steps:1- Configure Forms Authentication in Web.config FileTo configure forms authentication, set the <authentication> element's mode attribute to "Forms" and then configure your application's...
I got this unusual exception while working on an ASP.NET project:"Adding the specified count to the semaphore would cause it to exceed its maximum count error".I thought it is something related to SQL Server Database Connection String.After using Query Profiler I was able to run SQL queries directly without any...
DataTable Object has a Select Method which acts like Where in SQL Server. So if you want to write filter query you write the column name directly without Where and the filter expression you want.I made a simple example that creates a DataTable and fill it with some data and...
Let is say that we have the following Date 2007-04-05 10:13:14.109 and we want to get Year, Month and Day out of this date.There is a function named DATEPART() that can be used to archive this.DECLARE @MyDate AS DATETIME SET @MyDate = '2007-04-05 10:13:14.109' SELECT DATEPART(DAY, @MyDate) AS MyDay, DATEPART(MONTH, @MyDate) AS MyMonth, DATEPART(YEAR,...
Joins are used to combine the data from two tables, with the result being a new, temporary table.The temporary table is created based on column(s) that the two tables share, which represent meaningful column(s) of comparison.The goal is to extract meaningful data from the resulting temporary table.Joins are performed based...
The following method using sys. schema and views such as sys.databases and sys.tables.As we know that the old style sysobjects and sysdatabases and those catalog views have been deprecated since SQL Server.private static bool CheckDatabaseExists(string connectionString, string databaseName) { string sqlQuery; bool result = false; try ...
I was modifying an existing table using SQL Server Management Studio, but I got this error message on saving:Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created...
If you want to restrict other developers from using your Stored Procedures that returns a huge amount of data which affects server performance and Application Performance weather it is a Windows or Web Application.You can use the following idea when you create Stored Procedures:-- ============================================= -- Author: ...
XML is a platform-independent data representation format based originally on SGML. Since its popularization, it is becoming used as a data storage format. It has its own type system, based on the XML Schema Definition language (XSD). Both XML and XSD are W3C standards at the Recommendation level. An XML...
© Copyright 2026 by Nile Bits, LLC. All rights reserved ®. The brand and logo are trademarks of their respective owners, Nile Bits, LLC.
Made with in USA
| Cookie | Duration | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
