2009-12-24 10:25
GPRS setting for all mobile including ChineseAirtel LiveProfile Neme: LiveHomepage: http://live.airtelworld.comUsername: blankPassword: blankAPN: airtelfun.comProxy and Server Adress or IP:… Read More
Blog Directory > Friends & Family Blogs > Community Blogs > DotnetHorizon community Blog >
Dotnethorizon Blog
dotnethorizon.blogspot.com
Tags:
server
access point
statements set nocount
leave blankpassword leave
prevent extra result
server database table
tree
extra result
port
set nocount
This is very helpful blog for new .NET Developer Created by Jagannath Karmakar.
2009-11-24 10:33
Logical and Visual Trees XAML is natural for representing a user interface because of its hierarchical nature. In WPF, user interfaces are constructed from a tree of objects known as a logi… Read More
2009-11-24 10:28
Basic WCF Concept and Terminologies Windows Communication Foundation was official released with .NET 3.0 a couple of months ago. For those people who're doing connected, distributed syst… Read More
2009-10-16 11:58
SQL Alias Read More
2009-08-04 07:33
SQL Server 2005 Audit Log Using Triggers Once a database row has changed how do you retrieve the original data? There are many ways to do this, but for the application I'm working on I deci… Read More
2009-06-23 07:08
How to Share Printer in Windows XPFollow this step-by-step instructions to share printer in Windows XP.1) Go to Start and click Control Panel. Control Panel Window will appear, then double c… Read More
2009-02-06 05:46
Asp.net Questions Posted by Bhaumik 3:19 PM 1 comments »Que:- What is the sequence in which ASP.NET events are processed ?Ans:- Following is the sequence in which the events occur :… Read More
2009-01-29 06:17
What is Normalization? Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, s… Read More
2008-11-07 05:43
Using SqlBulkCopy to Import Excel Spreadsheet Data into SQL ServerLet's take an Excel Workbook with a worksheet, called Data, that contains 1000 rows of nonsense data broken into 2 columns… Read More
2008-07-15 11:50
SELECT [Name] as DatabaseName from master.dbo.sysdatabasesWHERE ISNULL(HAS_DBACCESS ([Name]),0)=1ORDER BY [Name] Read More
2008-07-15 11:40
Use this script in order to backup a database :/*Author : Suprotim AgarwalCreation Date: Jan 2, 2008*/CREATE PROCEDURE [dbo].[usersp_BackUpDB]@DBNAME nvarchar(50),@PATH nvarchar(200),@BCKUPN… Read More
2008-07-15 11:06
What is an application server?As defined in Wikipedia, an application server is a software engine that delivers applications to client computers or devices. The application server runs your… Read More
2008-06-27 14:24
Shortcut Function Shortcut Function ALT+BREAK Cancel a query CTRL+SHIFT+F2 Clear all bookmarks ALT+F1 Database object information CTRL+SHIFT+INSERT Insert a template ALT+F4 Exit CTRL… Read More
2008-06-27 07:28
select * from newemployee em where2=(select count(distinct sal) from newemployee e where e.sal Read More
2008-06-26 13:45
The syntax in the previous answer (where count(*) > 1) is very questionable. suppose you think that you have duplicate employee numbers. there's no need to count them to find out which va… Read More
2008-06-26 11:08
with t as (select row_number()over(partition by asid,imagepath order by asid) as rnum from amz_image) delete from t where rnum>1 Read More
2008-05-14 11:22
The first time when a browser request a page, server establishes a session and creates a session Id. Server returns this ID to the browser as part of the 'Response'. This ID is not displayed… Read More
2008-05-13 13:32
This is very common request recently - How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us s… Read More
2008-05-13 13:14
There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server… Read More
2008-05-13 10:20
hi Read More
Subscribe to Dotnethorizon
Get updates delivered right to your inbox!