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:
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:
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:
To
use cursor in sql
server
that syntax will be like as shown below
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.
To prevent SQL injection attacks we need to use
parameterized queries to pass values from code behind to database like as shown
below
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.
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:
Introduction:
Here I will explain how to remove duplicate records from a table in SQL server or delete duplicate rows or records in sql
server or removing duplicate records using sql server or sql server delete
duplicate records or rows from table
Description:
Introduction:
Here I will explain how to insert multiple rows into table with single
insert query in sql
server or sql
server insert multiple records in table with one insert statement with
example.
Description:
To
insert multiple rows into table with single insert query in sql
server
we can follow different methods like as shown below
Introduction:
Here I will explain how to get total records count of union query in sql
server 2008
or sql
server query to get total records of union statement with example.
Description:
Introduction:
Here I will explain difference between UNION and UNION ALL in SQL server. Union operator will return unique records from tables and Union All in SQL server will return all the records from the tables including duplicate values also.
Description:
Introduction:
Here I will explain difference between cursor and while loop in sql
server with example or explain cursor vs while loop with example in sql
server. Cursors in sql
server allow you to fetch a set of data, loop through each record,
and modify the values as necessary; then, you can easily assign these values to
variables and perform processing on these values. While loop also same as
cursor to fetch set of data and process each row in sql
server.
Description:
Introduction:
Here I will explain how to remove index from table in sql
server 2008
or drop index from table in sql
server. To remove index
from table we use drop index statement in sql
server.
Description:
To
create index on column in sql
server
that syntax will be like as shown below
Description:
To
install northwind and pubs sample databases in sql
server 2008 you need to follow below steps
Introduction:
Here I will explain how to replace multiple spaces in string with
single space in sql
server or sql
server replace multiple spaces with one space in string or sql
server remove extra multiple spaces from string without using any
while loop.
Description:
To
replace multiple spaces in string with single space in sql
server we
need to write the query like this
Introduction:
Here I will explain how to change identity column seed value in SQL
server 2008 or reseed identity column seed value of table in SQL
server or how to change identity column value in SQL
server.
Description: