SQL Server Archives - Page 188 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to expressor Datascript Modules

July 8, 2011

With the release of expressor 3.3, expressor software has added a significant new feature to the expressor Studio tool – the ability to easily extend functionality through the incorporation of reusable script files. A developer using expressor Studio may write these scripts and add them to any number of projects,…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 7 of 31

July 7, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What are Different Types of Locks? Shared Locks: Used for operations that do not change or update data…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 5 of 31

July 5, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is an Identity? Identity (or AutoNumber) is a column that automatically generates numeric values. A start and…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 4 of 31

July 4, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is the Difference between a Function and a Stored Procedure? UDF can be used in the SQL…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 3 of 31

July 3, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is a Stored Procedure? A stored procedure is a named group of SQL statements that have been…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 2 of 31

July 2, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs 1) General Questions on SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Introduction – Day 1 of 31

July 1, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox List of all the Interview Questions and Answers Series blogs Posts covering interview questions and answers always make for interesting reading. Some people like the subject for their helpful hints and thought provoking subject, and others dislike these posts because…