How to Insert Value into an Identity Column

In database tables, normally identity columns are used as primary keys that automatically generates numeric values for every new inserted row.For this identity (AutoNumber) column, you are not allow to insert your own value. So what if you really want to insert your own value into the column?A very easy way to do this. I will show you how to do this.Firstly, create a table Sample by using the script below into your database.CREATE TABLE Sample (Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,Name VARCHAR(50) NOT NULL )GONormally if...

How to Call Remote Web Services from Client Side JavaScript

Web Services is a collection of universally available functions, which allows different applications from different sources to share among each other without time-consuming custom coding by using the XML, SOAP, WSDL and UDDI open standards across the Internet. You can go to here for more detail explanation on it.Recently, I have been doing some research into how to call a web service from client side JavaScript. ASP .NET AJAX enables you to call a web service from the browser by using client script, namely the page can call...

Displaying Date and time in VB Script with ASP Classic

To display the Date and Time in your ASP page with certain format is very simple indeed. Take a look at the examples as below:<%=time()%> - Get current time - e.g. 9:52:30 AM<%=date()%> - Get current date - e.g. 7/11/2008<%=now()%> - Get current date and time - e.g. 7/11/2008 9:54:03 AM<%=FormatDateTime(now,0)%> - e.g. 7/11/2008 9:55:41 AM<%=FormatDateTime(now,1)%> - e.g. Friday, July 11, 2008<%=FormatDateTime(now,2)%> - e.g. 7/11/2008<%=FormatDateTime(now,3)%> - e.g. 9:57:49 AM<%=FormatDateTime(now,4)%>...