Author Archives: Sanmukha

Ebola Virus

Here I have written a brief theory about Ebola which scared to entire world. check it out what is it and how it spreading across. What it is? Ebola virus (EBOV or Zaire Ebola virus) is one of five known viruses within the genus Ebola virus. Out of five Ebola viruses, four including EBOV, cause […]

AngularJS

Programming world is shifting towards client side programming from server side. The emphasis is more on client side computing now a day because it makes web pages faster to load as we can avoid server side computation. By this we can also avoid server overhead and make pages more responsive to user. And to achieve […]

Page Methods in ASP.NET

We cannot call the server side code directly into client side. The server side code will execute at server and client code at client. However by using some .Net techniques we can call server side code from JavaScript by using AJAX methods or ASP.NET AJAX Extensions. There are two ways to achieve this work one […]

Important Date Function In Sql Server 2008

Here are the some of important date function which i have worked out last week in order to write some Sp’s for my project. Start and End of Today SELECT DATEADD(DD,DATEDIFF(DD,0, GETDATE()),0) as [Start Of Day] DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE())+1,0)) as [End Of Day] Start and End of Week SELECT DATEADD(WK, DATEDIFF(WK,0,GETDATE()),0) as [Start Of Week] DATEADD(s,-1,DATEADD(WK, […]

Import the data from Excel to Database in sql server 2008

Simple ways to import data from excel to database using import and export wizard of sql server. Step 1: Right Click on the respective database onto which you want to import the data from excel. In our case the name of the database is Demo. Step 2: Click on the Import Data option and you’ll […]

Generating Scripts in Sql Server 2008 R2

In this article i would like to share how to generate script file in sql server 2008 r2. Hope it will help mostly to freshers. In order to see the full and clear image click on the respected images. Step 1: Right click on the database from which you want to generate the script. You’ll […]

Difference between stored procedure and function

I find some of the difference between SP and function in sql server 1) Procedure can return zero or n values whereas function can return one value which is mandatory. 2) Procedures can have input, output parameters for it whereas functions can have only input parameters. 3) Procedure allows select as well as DML statement […]