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”
Category: SQL Server Tutorial
Microsoft SQL Server Tutorials For Beginners, free microsoft sql server tutorial, Authorcode SQL Server tutorial covers the basic concepts of the SQL server with the examples. You can learn the SQL server basic and advanced techniques and how to use sql queries from this 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”
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”
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”
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”
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?”
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”
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”
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”
Using Aliases in SQL Server
You can use some alias for table in the select query for better readability of the query, Aliases of the table are very useful when you are using complex query with multiple lines. Aliases of the tables in the Sql server are also called as a correlation name or range variable. Continue reading “Using Aliases in SQL Server”