How To Select Random Records In SQL Server

Hi Guys in this tutorial i will let you know, How To Select Random Records In SQL Server.This is very needful when we have to select some records from our database but randomly.We can achieve this by a function in SQL Server. NEWID: NEWID() generates the GUID in random order.Also The value returned by NEWID() is different

How to get URL & Querystring Value Using jQuery

How to get URL & Querystring Value Using jQuery In this tutorial i will let you know guys, How to get URL & Querystring Value Using jQuery.This is very useful when we have to process a request by querystring value. Example: URL = http://www.hightechnology.in/project.aspx?projectid=1 Read Querystring Value: function GetQueryStringParams(sParam) { var sPageURL = window.location.search.substring(1); var sURLVariables

How To Capture Screenshot and Add In Word, Excel 2013

How To Capture Screenshot and Add In Word, Excel 2013 Hi guys, in this tutorial i will let you know that how can you How To Capture Screenshot and Add In Word, Excel 2013.Here we are not using any other application.Microsoft office 2013 provides this functionality inside it.I found it very good feature, When you try

Date and Time Conversions Using SQL Server

Date and Time Conversions Using SQL Server Hi guys, in this tutorial i will let you know Date and Time Conversions Using SQL Server.Microsoft SQL Server provides various options to format a date/time string.The most common is the current date/time using getdate().It provides the current date and time according the server providing the date and time. If a

How To Change The Privacy Of a Video In Youtube

How To Change The Privacy Of a Video In Youtube In this tutorial i will explain you How To Change The Privacy Of a Video In Youtube.This feature of youtube is basically to set the privacy of video, To whom you and how you want to show the video(Public, Private, Unlisted).If you already set the privacy

Bind Datalist In Asp.Net C# Conditionally

Bind Datalist In Asp.Net C# Conditionally Hi guys, in this tutorial i will explain you how to Bind Datalist In Asp.Net C# Conditionally.This happens to me when recentlly i am working on a project, and i have to show a image on datalist based on the condition.Let me explain details to you:We have to bind the

SQL Server Reset Identity Increment For All Tables

SQL Server Reset Identity Increment For All Tables In this tutorial i will let you know how to reset identity increment in SQL Server All Tables of a Database at once or you can say SQL Server Reset Identity Increment For All Tables. We are doing this with the help of MSforeachtable stored procedure, which is a undocumented,