Skip to content

AuthorCode

  • Examples
    • HTML 5
    • jquery Demo
  • Forum
    • General Programming
      • C#
      • VB.Net
      • Windows Forms
    • Web Development
      • ASP.Net
      • HTML, JavaScript and CSS
      • HTML5
    • Internet and Web Apps
      • WordPress and bbPress
    • Database
      • Sql Server
  • Programming
    • PHP
    • Visual Basic .Net
    • C#
    • VB 6
    • VB Script
  • Tech blogs
    • Wrodpress and bbpress
    • Internet & Web apps
    • Misc
    • Social Media
  • Tutorials
    • SQL Server Tutorial
    • HTML5
    • VBScript
    • Android Development
  • Web Development
    • AngularJS
    • Angular
    • ASP.Net
    • HTML and CSS
    • HTML5

Category: Tutorials

Get Sql Database Restore Progress by SQL

Get Sql Database Restore Progress by SQL

Some time when we Restore a large SQL backup file it takes a long time and SQL Popup window not show the actual progress of database restore process.
Continue reading “Get Sql Database Restore Progress by SQL”

Author AnkurPosted on August 16, 2014April 22, 2015Categories SQL Server Tutorial

See table: Type mapping between Entity framework and SqlClient types

When you use the ADO.Net Entity Data Model wizard to creating the model from the SQL Server database, wizard maps the SQL Server types according to following table: Continue reading “See table: Type mapping between Entity framework and SqlClient types”

Author Hirendra SisodiyaPosted on April 2, 2014Categories MVC, SQL Server TutorialTags ADO.Net Entity framework, MVC

List of Sql Server versions

The following is the list of the SQL Server version. With the help of the following list you can know that what service packs are installed on SQL Server on your machine. Continue reading “List of Sql Server versions”

Author Hirendra SisodiyaPosted on March 16, 2013August 4, 2016Categories SQL Server TutorialTags Sql server

CASCADING referential integrity in sql server

Cascading Referential integrity applies to the DELETE and UPDATE statements only because they cause changes to existing rows.
There are two actions that can take place for either operation: Continue reading “CASCADING referential integrity in sql server”

Author PavanPosted on August 31, 2012August 31, 2012Categories SQL Server TutorialTags Sql server

Using Cross Joins

We can use Cross Join with WHERE clause and Without WHERE clause, When we use the Cross Join without WHERE clause,produces the Cartesian results from the tables. The resultset contains records that are multiplication of record number from both the tables. Continue reading “Using Cross Joins”

Author Hirendra SisodiyaPosted on August 17, 2012Categories SQL Server TutorialTags Sql server, Sql Server tutorial

Create Android Applcation with DroidDraw

Several month ago I started learning the Android development with Eclipse.Google also recommend the Eclipse IDE for android development. I have created several android application with Eclipse. Continue reading “Create Android Applcation with DroidDraw”

Author Hirendra SisodiyaPosted on July 30, 2012June 27, 2016Categories Android DevelopmentTags DroidDraw1 Comment on Create Android Applcation with DroidDraw

What are the difference between DDL, DML and DCL commands?

DDL

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: Continue reading “What are the difference between DDL, DML and DCL commands?”

Author PavanPosted on July 23, 2012July 23, 2012Categories SQL Server TutorialTags Database, Sql server

System Databases in SQL Server

 
SQL server installation create some system databases automatically, you can see these database in your SQL server management studio: Continue reading “System Databases in SQL Server”

Author Hirendra SisodiyaPosted on July 11, 2012Categories SQL Server TutorialTags Sql server, Sql Server tutorial

Using COALESCE in SQL Select Query

 
COALESCE function returns the first nonnull expression among its arguments. you can use the COALESCE function like as: Continue reading “Using COALESCE in SQL Select Query”

Author Hirendra SisodiyaPosted on July 6, 2012Categories SQL Server TutorialTags Sql server, Sql Server tutorial

About Sql Server 2005

 
Microsoft SQL Server is a relational database management system developed by Microsoft. SQL Server 2005 was released in October 2005. It is the successor of the Microsoft SQL Server 2000. Continue reading “About Sql Server 2005”

Author Hirendra SisodiyaPosted on July 3, 2012July 3, 2012Categories SQL Server TutorialTags Sql server, Sql Server tutorial

Posts navigation

Page 1 Page 2 … Page 6 Next page
    • Examples
      • HTML 5
      • jquery Demo
    • Forum
      • General Programming
        • C#
        • VB.Net
        • Windows Forms
      • Web Development
        • ASP.Net
        • HTML, JavaScript and CSS
        • HTML5
      • Internet and Web Apps
        • WordPress and bbPress
      • Database
        • Sql Server
    • Programming
      • PHP
      • Visual Basic .Net
      • C#
      • VB 6
      • VB Script
    • Tech blogs
      • Wrodpress and bbpress
      • Internet & Web apps
      • Misc
      • Social Media
    • Tutorials
      • SQL Server Tutorial
      • HTML5
      • VBScript
      • Android Development
    • Web Development
      • AngularJS
      • Angular
      • ASP.Net
      • HTML and CSS
      • HTML5
    All rights reserved@authorcode.com