aspx Tutorial

NET Articles,jQuery demo, asp.net with jQuery, online tutorial,Jquery, SilverLight, Javascript, asp.net,JSON, MVC,.NET Articles,demo, Web Services,
Advertise Here

Toolbar

Get our toolbar!

Advertize



{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, November 6, 2012
Here Aamir Hasan has demonstrate how to change TCP/IP port for SQL Server 2008 and SQL Server 2012 More
{#advanced_dlg.about_title}
by Aamir Hasan   on Friday, September 23, 2011
The following script demonstrates how to declare variables and initialized values in one statement in SQL Server 2008. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Monday, July 18, 2011
SQL Server 2008 R2 Service Pack 1 has released, SQL Server 2008 R2 issues has been fixed in this released. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Thursday, January 13, 2011
In this example, you will see how to find the size of table from a database. SQL server gives you build in system store procedure named SP_SPACEUSED. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Thursday, December 30, 2010
A unique identity in each row in a table is called Primary key... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Friday, November 5, 2010
yesterday, some one asked me , how to get the file size of all databases in MS SQL 2008 using SQL query, So i have decided to write a query in this blog to help to all those developers who don't know. T-SQL Script SELECT DB_NAME(DATABASE_ID) AS [DATABASE NAME] , CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE] FROM SYS.MASTER_FILES Output
{#advanced_dlg.about_title}
by Aamir Hasan   on Wednesday, November 3, 2010
In this example, i have told you how to get top 5 random records using T-SQL query. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, November 2, 2010
How to get All store procedure list from a database in MS SQL 2005/2008... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, September 14, 2010
Yesterday some one ask me, how can i count a vowels from a string in MS SQL 2008.Here is the following SQL function to return count of vowels from a given input string. User defined function CREATE FUNCTION COUNT_VOWEL ( @STRING NVARCHAR(MAX) ) RETURNS INT AS BEGIN DECLARE @I INT DECLARE @COUNT INT SET @COUNT = 0 SET @I = 1 DECLARE @ANS NVARCHAR(MAX) DECLARE @VOWEL NVARCHAR(6) SET @VOWEL = 'AEIOU' WHILE @I <= LEN(@STRING) BEGIN SET @ANS = SUBSTRING(@STRING, @I, 1) IF @ANS = 'A' OR @ANS = 'I' OR @ANS = 'O' OR @ANS = 'U' BEGIN SET @COUNT = @COUNT + 1 END SET @I = @I + 1 END RETURN @COUNT END     Queries SELECT DBO.COUNT_VOWEL('AAMIR HASAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('MAHWISH HASAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('SABA KHAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('BILL GATE') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('CYNDY KRYSTYN') AS [VOWELS(S)] Output Download You can download source code from Here.
{#advanced_dlg.about_title}
by Aamir Hasan   on Saturday, September 11, 2010
In this tutorila i will tells you, how to create a database in ms sql 2008.Let's start Syntax CREATE DATABASE [DATABASE NAME]   A) Creating a database Following example creates a database CREATE DATABASE [ASPXTUTORIAL]   B) Creating a database and locating on different drives   CREATE DATABASE [aspxtutorial] ON PRIMARY  ( NAME = N'aspxtutorial', FILENAME = N'D:\database\aspxtutorial.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB )     LOG ON  ( NAME = N'aspxtutorial_log', FILENAME = N'E:\database\aspxtutorial_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5