aspfordeveloper.blogspot.com
ASP Developer: Read client side IP Address
http://aspfordeveloper.blogspot.com/2009/07/read-client-side-ip-address.html
Monday, July 20, 2009. Read client side IP Address. Server side code for ASP Classic- - - -. Ip address=Request.Servervariables("REMOTE HOST"). End server side code - - - - - - - - -. Subscribe to: Post Comments (Atom). Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Read client side IP Address. C# DOT NET for Developers.
sqlserverfordeveloper.blogspot.com
Sql Server Blog: June 2012
http://sqlserverfordeveloper.blogspot.com/2012_06_01_archive.html
Deleting All Keys or constraints from database. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Friday, June 22, 2012. Deleting All Keys or constraints from database. Sql NVARCHAR(500) DECLARE @Cursor CURSOR. Cursor = CURSOR FAST FORWARD FOR. SELECT DISTINCT sql = 'ALTER TABLE [' tc2.TABLE NAME '] DROP [' rc1.CONSTRAINT NAME ']'. FROM INFORMATION SCHEMA.REFERENTIAL CONSTRAINTS rc1.
sqlserverfordeveloper.blogspot.com
Sql Server Blog: October 2009
http://sqlserverfordeveloper.blogspot.com/2009_10_01_archive.html
Search string in any column in a table. Counting rows in a table for improving performance. Searching in a column of any table by a substring. Select desired rows from table by IN Keyword. Select top two rows from SQL server database table. Insert rows/records from one table to another tabl. How to select Duplicate Rows from a table. Create Serial Number Column using SQL Server. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. View my complete profile. EXEC sp Fi...
aspfordeveloper.blogspot.com
ASP Developer: 04/01/2008 - 05/01/2008
http://aspfordeveloper.blogspot.com/2008_04_01_archive.html
Wednesday, April 2, 2008. How to select Duplicate Rows from a table. Select email,count(*) from finaldatabase Amit group by email having count(*) 1. Insert rows/records from one table to another table. Insert into tbl logo Info event (ImageURL link,ImageURL Show, Image Name,Image Title, Image Profile) select ImageURL link,ImageURL Show,Image Name,Image Title,Image Profile from tbl logo Info where ImageID='16'. Select two random rows from SQL server database table. Tuesday, April 1, 2008. InstantASP is an...
aspfordeveloper.blogspot.com
ASP Developer: Session Object properties in ASP
http://aspfordeveloper.blogspot.com/2009/04/session-object-in-asp-is-great-tool-for.html
Thursday, April 2, 2009. Session Object properties in ASP. The Session Object in ASP is a great tool for the modern web site. It allows you to keep information specific to each of your site's visitors. Information like username,password, etc. MySessionID = Session.SessionID. Set Session Timeout time. Session.Timeout = 240. Subscribe to: Post Comments (Atom). Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Type conversion in ASP. Session Object properties in ASP.
sqlserverfordeveloper.blogspot.com
Sql Server Blog: November 2009
http://sqlserverfordeveloper.blogspot.com/2009_11_01_archive.html
Using Replace function to update whole column data. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Sunday, November 1, 2009. Using Replace function to update whole column data in a table. Below is the table "tbl interview" with the "description" column and we are updating "script src=" text with the blank " text. Update tbl Interview set description=Replace(description,'script src=',' ).
sqlserverfordeveloper.blogspot.com
Sql Server Blog: November 2012
http://sqlserverfordeveloper.blogspot.com/2012_11_01_archive.html
Query to search table name in SP, Trigger and View. C# DOT NET for Developers. Remove all XML tags from a string. Read client side IP Address. Project Lead, HCL Technologies Ltd. Noida. View my complete profile. Thursday, November 8, 2012. Query to search table name in SP, Trigger and Views. SELECT DISTINCT so.name,so.xtype. INNER JOIN sysobjects so ON sc.id=so.id. WHERE sc.TEXT LIKE '%tablename%'. Subscribe to: Posts (Atom).
aspfordeveloper.blogspot.com
ASP Developer: 03/01/2009 - 04/01/2009
http://aspfordeveloper.blogspot.com/2009_03_01_archive.html
Tuesday, March 17, 2009. Useful Functions in Classic ASP. 1 Mid function to trim text for specific length. For 1 to 5 letter triming. Strtext=mid("text want to trim",1,5). 2 Replace function with Syntax. Xyz=replace(Amit pal, " ", "G"). 3 Find Server name by server variables. StrServerURL = "http:/ " Request.ServerVariables("SERVER NAME"). 4 Split Fuction Syntax. Current day=split(current date,"/"). 5 Trim function for trimimg blank spaces. Rsopen sqlQuery,ObjConn,3. ASP Source Code for sending email.
aspfordeveloper.blogspot.com
ASP Developer: Current date format in ASP
http://aspfordeveloper.blogspot.com/2009/04/current-date-format-in-asp.html
Thursday, April 2, 2009. Current date format in ASP. The Format Date Time function takes two arguments: a date and (optional) an integer from 0 through 4. The meanings of these numbers are as follows:. 0 - This is the default setting. A short date DD/MM/YYYY will be used. 1 - A long date defined by the computer's regional settings. 2 - A short date defined by the regional settings. 3 - (time)A time using the time format defined by the regional settings. 1 = Friday, October 21, 2005. 3 = 12:00:00 AM.