Dot Net World
C# | Asp.Net | MVC | SQL Server | jQuery | Java Script | Angular | .Net Core | Microservices
Pages
(Move to ...)
About Me
.Net Core
Angular
Asp.Net
C#
Design Patterns
Java Script
Microservices
Sql Server
▼
Showing posts with label
Database
.
Show all posts
Showing posts with label
Database
.
Show all posts
Tuesday, October 6, 2015
SQL : Sql Query Execution Order
›
Most programming languages executes set of statements from Top to Bottom but SQL Server executes set of statements in a logical order whic...
Thursday, February 7, 2013
Simple script to backup all SQL Server databases
›
Working as developer or DBA, we often required to take the backup of database . This is not a big deal if you have a handful of databases, ...
Tuesday, December 25, 2012
Return SQL Query Result as XML in SQL Server- AUTO Mode
›
In previous post Return SQL Query Result as XML in SQL Server , I explained For XML clause for getting the query result as XML . I also e...
Monday, December 24, 2012
Return SQL Query Result as XML in SQL Server
›
SQL Server gives you option to retrieve data as XML by supporting For XML clause, which you can use as a part of your query. For XML ...
Thursday, December 6, 2012
Select random records from database (MySQL, Oracle, MS SQL)
›
Sometimes we need to select random records from a table in our database. For example, if you created online test application then every ti...
›
Home
View web version
^ Scroll to Top
