Find Dependency In SQL Server

Why?
Let’s discuss one situation. There were so many tables in database and I have to change only one column of the table then how can I found this column is how many times used in any views or store procedure or any other database object. There is a ways to find this type of situation. First right click on [...]

Read Full Post »

Fetching Random Rows In SQL Server

Recently I needed to fetch random rows from a SQL server table. If you have an integer column then using RAND() function goes well. However in my case there was no number column. In such cases you can use newid() function that is provide by SQL Server.
1). Create one Temporary table like Product.

1: create table Product
[...]

Read Full Post »

SET ANSI_NULLS ON|OFF In SQL Server

When i started learing SQL Server one of the mistakes I did a few times was something like the following.

1: IF OBJECT_ID(‘Invoice’) IS NOT NULL DROP TABLE Customers
2: GO
3: CREATE TABLE Invoice(
4: InvoiceId int,
5: [...]

Read Full Post »

Debug Remote SQL Server Store Procedure In .Net

In nova days i have faced one problem that was to debug store procedure that placed on remote sql server.I have found the solution to debug remote store procedure on .net platform.I have mention all the steps below to impliments remote store procedure debugging in .NET.
 
1). Microsoft SQL Server Provide rdbgsetup.exe file .with help of this file we [...]

Read Full Post »

Text to Speech In C#

Text to Speech is very usefull in Web Application as well as in windows application.Microsoft provide Speech Object Library  that is use for this purpose.Here i have mention steps to implement text to speech in C#.
1). Add Speech Object Library reference to your Application using right click on Project & click on Add Reference.

2). After Adding [...]

Read Full Post »

Add Flash Object In WinForms

    To Add Flash into your winforms is difficult task compair to adding flash object on webpage.here i have mention the steps to add flash control into your windows application.

You need to add the Shockwave ActiveX control that will host your Flash movie to the Visual Studio toolbox.Right click the toolbox, and select Add Tab [...]

Read Full Post »

Timer In JavaScript

 Why Use Java Script Timer?
In my recent application i have done one task that After 15 sec page redirect automatically and that page display the remaining time.To done that i have use the java script timer.

Step To Achive Timer In Java Script
1). Copy belowed script after Head Tag In your ASPX file

1: <script [...]

Read Full Post »