How to choose and set up payment options in AspxCommerce
How to choose and set up payment options in AspxCommerce .Net eCommerce software
Difference between Function (UDF) and Stored Procedure on MSSQL
Difference between Function (UDF) and Stored Procedure on MSSQL
Functions
1- Can be used with Select statement
2- Not returning output parameter but returns Table variables
3- You can join UDF
4- Can not be used to change server configuration
5- Can not be used with XML FOR clause
6- Can not have transaction within function
7- Can be used in Select list
8- Versioning (grouped) Not Allowed
9- Schema Binding Allowed
10- GETDATE() or other non-deterministic functions Not Allowed
11- SET OPTION Allowed
12- Temp Object Not supported
Stored Procedure
1- Have to use EXEC or EXECUTE
2- Return output parameter
3- Can create table but won’t return Table Variables but possible in MSSQL 2008/2008 R2
4- You can not join SP
5- Can be used to change server configuration
6- Can be used with XML FOR Clause
7- Can have transaction within SP
8- You can not use in SELECT list
9- Compiled, can remember execution plan
10- Schema Binding Not Allowed
11- GETDATE() or other non-deterministic functions Allowed
12- SET OPTION Not Allowed
13- Temp Object Accessible – You can use the temp tables inside the procedure
Reference
How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2
How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2
Script
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = ‘DROP PROCEDURE [dbo].[' + RTRIM(@name) +']‘
EXEC (@SQL)
PRINT ‘Dropped Procedure: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP VIEW [dbo].[' + RTRIM(@name) +']‘
EXEC (@SQL)
PRINT ‘Dropped View: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP FUNCTION [dbo].[' + RTRIM(@name) +']‘
EXEC (@SQL)
PRINT ‘Dropped Function: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)
WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@constraint) +']‘
EXEC (@SQL)
PRINT ‘Dropped FK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)
END
GO
/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@constraint)+']‘
EXEC (@SQL)
PRINT ‘Dropped PK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)
END
GO
/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP TABLE [dbo].[' + RTRIM(@name) +']‘
EXEC (@SQL)
PRINT ‘Dropped Table: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
Reference
The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5
The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5
You are trying to jump start an existing ASP.NET site on a new IIS 7.5 server under Windows 7/7.5 or under Windows 2008 R2, and you are getting this error message: The problem is in IIS 7.5 DefaultAppPool settings.
Windows 2008 Server with IIS 7.0/7.5 runs DefaultAppPool using Network Service user:
Windows 7.0/7.5 and Windows 2008 Server R2 with IIS 7.5 run the same pool under a different user – ApplicationPoolIdentity:
All you need to do is to change that setting on your machine.
Use IIS Admin – Application Pools.
1- Right mouse click on DefaultAppPool row,
2- Select Advanced Settings,
3- A first setting under Process Model group is Identity,
4- Select it and using a drop down list change Built-in account from ApplicationPoolIdentity to NetworkService.
Now check your application log in, it will work
Hope this will work
httpRuntime Element in web.config
Configures ASP.NET HTTP runtime settings. This section can be declared at the machine, site, application, and subdirectory levels.
<httpRuntime useFullyQualifiedRedirectUrl="true|false"
maxRequestLength="size in kbytes"
executionTimeout="seconds"
minFreeThreads="number of threads"
minFreeLocalRequestFreeThreads="number of threads"
appRequestQueueLimit="number of requests"
versionHeader="version string"/>
Example
The following example specifies HTTP runtime parameters for an ASP.NET application.
<configuration>
<system.web>
<httpRuntime maxRequestLength="4000"
useFullyQualifiedRedirectUrl="true"
executionTimeout="45"
versionHeader="1.1.4128"/>
</system.web>
</configuration>
References:
http://msdn.microsoft.com/en-us/library/e1f13641(vs.71).aspx
eCommerce platform
A new open source “Flexible and easy eCommerce platform” offers a complete ecommerce solution that allows you to run your fully functional online store in minutes.
AspxCommerce is easy to learn, use and comes enhanced with abundant features for web designers, developers and merchants alike. Merchants can enjoy complete flexibility and control over the look, content and functionality of their online store, AspxCommerce is available on ColePlex
http://aspxcommerce.codeplex.com/
Download AspxCommerce
for features visit demo link http://demo.aspxcommerce.com/
to know much more please visit
http://www.aspxcommerce.com/
Intro
Demo
SageFrame is now available for ASP.NET 4.0 also
SageFrame is now available for ASP.NET 4.0 also, interested developers and site owners now can directly download from CodePlex. http://sageframe.codeplex.com/releases/view/70057 How to install full guide is available Installation on Windows XP Installation on Windows 7 For details just visit http://www.sageframe.com For the Support just visit http://www.sageframe.com/Community/Forum.aspx http://www.sageframe.com/Blog.aspx
SageFrame Full Version Released!!
SageFrame Full Version Released!!
SageFrame 1.1 full version with new features and explorations. You’ll surely love the way it works.
Download from
http://sageframe.codeplex.com/
For detail visit
http://www.sageframe.com/
Caching helps us to achieve three important aspects of QoS
Caching helps us to achieve three important aspects of QoS (Quality Of Service):
Performance – Caching improves application performance by minimizing data retrieval and formatting operations.
Scalability – Since caching minimizes data retrieval and formatting operations, it reduces the load on server resources thus increasing the scalability of the application.
Availability – Since the application uses data from a cache, the application will survive failures in other systems and databases.
4 comments