Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

SQL Server Remove (Delete) Duplicate Records from Table using Query

Apr 22, 2015 0 comments
Introduction:

Here will explain how to remove duplicate records or rows from a table in SQL Server or delete duplicate records from table in SQL Server.

Description:

In previous articles I explained take database backup in sql server, covert rows to columns in sql server without using pivot tablesubstring function in SQL serverReplace function in SQL Serverhow to delete duplicate records from datatable in asp.net. Now I will explain how to delete duplicate records from a datatable in SQL server. 

During work with one application I got requirement like get the unique records from datatable in sql server. Actually our datatable does not contain any primary key column because of that it contains duplicate records that would be like this

Take Database Backup in SQL Server 2008 using Query or Management Studio

Apr 21, 2015 0 comments
Introduction:

Here I will explain how to write query to take database backup in
sql server or take backup of database using sql server management studio. To take database backup in sql server we need to write query like “BACKUP DATABASE DatabaseName to Disk…etc” or directly from management studio we can take backup  in sql server.
Description:                           
In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to write query to take database backup or take database backup from sql server management studio 2008.

SQL Server Encryptbypassphrase and Decryptbypassphrase Functions with Example

Apr 20, 2015 1 comments
Introduction:

Here I will explain what is
 encryptbypassphrase and decryptbypassphrase functions in sql server. By using these functions we can encrypt or decrypt string or text or password column in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.
Description:                           
In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain use of encryptbypassphrase and decryptbypassphrase functions with example in sql server.

Encrypt and Decrypt String (Password) in SQL Server 2008

0 comments
Introduction:

Here I will explain how to do encryption and decryption of string or text or password in
sql server using encryptbypassphrase and decryptbypassphrase functions in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.
Description:                           

SQL Server interview Questions and Answers for Experienced &Freshers

Apr 1, 2015 0 comments
Here I will explain sql server interview questions and answers for experienced and freshers or interview questions and answers in sql server for freshers and experienced people with examples.

Please check below of sql server interview questions and answers for experienced and freshers

What is SQL Injection and How do you Prevent it in Asp.net using C#, VB.NET

1 comments
Introduction:

Here I will explain what is sql injection attacks and how to prevent it in
asp.net website with example and how to prevent SQL injection attacks in asp.net using c#, vb.net with example. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous post I explained jQuery scroll to particular position of div when click on link, SQL Server remove duplicate records from table, SQL Server insert multiple rows with single insert statement,
how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain what is sql injection attack in asp.net website with example.

What is Cursor in SQL Server with Example

0 comments
Introduction:

Here I will explain what is cursor in
sql server with example or simple cursor example in sql server and how to declare and use cursor in sql server. Cursor in sql server is used to retrieve set of data from table, loop through each record row by row, and modify the values based on requirements.
Description:
In previous articles I explained While loop example in sql server, nested while loop example in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain cursor in sql server with example.

To use cursor in sql server that syntax will be like as shown below

SQL Server Return All Records When a Query Parameter is Blank or Null or Empty

Mar 24, 2015 2 comments
Introduction:

Here I will explain how to return all the records when a query parameter is blank or empty or null in
sql server or query get all the records from database when input parameter is null or blank or empty in sql server. We need to write a condition to check whether query parameter is blank or not in sql server based on that we can return all records or matched records.
Description:

Install SQL Server 2008 r2 on Windows 8.1 Step By Step Process with Images

Jan 29, 2015 0 comments
Introduction

Here I will explain how to install
SQL Server 2008 R2 on windows 8.1 with step by step process guide using images or install Microsoft SQL Server 2008 R2 management studio on windows 8.1.

Description:
  
In previous articles I explained install northiwind pub database in sql server, install crystal reports in visual studio 2010,
SQL injection attack example in asp.net,  SQL Server insert multiple rows with one insert statement and many articles relating to SQL Server, jQuery, JavaScript and asp.net. Now I will explain how to install SQL Server 2008 R2 on windows 8.1 with step by step process guide using images.

SQL Server 2008 r2 - It is not a Valid Login or You do not have Permission to Install on Windows 8.1

1 comments
Introduction:

Here I will explain how to solve “it is not a valid login or you do not have permission to install sql server 2008 r2 problem on windows 8.1. Actually I got this problem while installing SQL Server 2008 r2 on windows 8.1 and I realized this problem occurred because of system name and login name both are same.


Now I will explain how to solve the problem of it is not a valid login or you do not have permission to install sql server 2008 r2 while installing on windows 8.1 like as shown below
  

SQL Bulk copy from DataTable or DataSet in ASP.NET, C#

Jan 24, 2015 1 comments
Introduction:

Today in this post I will show you how to copy multiple data into database table at a time. I am sure you have wrote single INSERT statement to insert a single row to database. Or you have used a for loop or a foreach loop to run multiple insert query. But apart form all these in this post I will show you how to insert data into database table in bulk at a time.

Drop or Remove Foreign Key Constraint in SQL Server 2008

Nov 3, 2014 1 comments
Introduction:

Here I will explain how to create or remove / drop foreign key constraint in
sql server.  Foreign key constraint in one table point to primary key in another table in sql serverand foreign key constraint is used to prevent the actions that would destroy the links between two tables.
Description:
In previous articles I explained Primary key constraint in sql server, foreign key constraint in sql server, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to remove foreign key constraint in sql server.

SQL Server Convert Table Data to XML Format using XML PATH, XML AUTO or XML RAW

Oct 20, 2014 4 comments
Introduction:

Here I will explain how to convert table data to xml format in
sql server or get table data in xml format in sql server. We can convert sql server table data in xml format by using XML AUTO or XML PATH or XML RAW.
Description:
In previous articles I explained SQL Server Get Data in XML format  group by columns, Reading XML data file using SQL query, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server.

SQL Server - Get Data in XML Format Based on Group by Columns in SQL Server with Example

Oct 19, 2014 0 comments
Introduction:

Here in
sql server I will explain how to get data in xml format based on group by columns in sql server with example or sql server group columns and show in xml format.
Description:
In previous articles I explained cursor example in sql server, While loop example in sql server, nested while loop example in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain cursor how to get data in xml format based on group by columns in sql server with example.

SQL Server Cursor Example | Simple (Basic) Cursor Example in SQL Server

Aug 10, 2014 1 comments
Introduction:

Here I will explain cursor in
sql server with example or simple cursor example in sql server and how to use cursor in sql server. Cursor in sql server is used to retrieve set of data from table, loop through each record row by row, and modify the values based on requirements.
Description:
In previous articles I explained While loop example in sql server, nested while loop example in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain cursor in sql server with example.

To use cursor in sql server that syntax will be like as shown below

Asp.net Preventing SQL Injection Attacks using Parameterized Queries

Aug 3, 2014 0 comments
Introduction:

Here I will explain how to prevent
SQL injection attacks in asp.net website with example using c#, vb.net. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous posts I explained
SQL injection example in Asp.net, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain how to prevent SQL injection attacks in asp.net website with example using c#, vb.net.

To prevent SQL injection attacks we need to use parameterized queries to pass values from code behind to database like as shown below

SQL Injection Attack Example in Asp.net using C#, VB.NET

1 comments
Introduction:

Here I will explain what are sql injection attacks in
asp.net website with example and how to prevent SQL injection attacks in asp.net using c#, vb.net with example. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous post I explained jQuery scroll to particular position of div when click on link, SQL Server remove duplicate records from table, SQL Server insert multiple rows with single insert statement,
how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain what is sql injection attack in asp.net website with example.

Generate Script in SQL Server 2008 to Export Database

Jul 31, 2014 1 comments
Introduction:

Here I will explain how to generate script in
sql server 2008 to export database or Export database in sql server with script.
Description:

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.