Create comma seperated text values for In SQL Query from excel file Problem : You are provided with excel containing First Name. You want to […]
Category: SQL Server Articles
Database Design Steps
Two important steps for Database Design are : Finding entities and relationships between them Finding business rules that define how data will be stored Consider […]
Overview of XML Support in SQL Server versions
XML Support in SQL Server versions SQL Server 2000 OpenXML – XML Decomposition to Relational Select … FORXML – Relational Composition to XML Server side […]
How XML can be stored in relational database ?
How XML can be stored in relational database ? There are three ways XML can be stored in relational database. 1. XML can stored as […]
SQL Questions : What is normalization ?
What is normalization ? Normalization is a method to seperate data into multiple tables and relate these multiple tables. Some benefits of normalized database : […]
What is SSRS ?
What is SSRS ? SSRS stands for SQL Server Reporting Services . SSRS is server based reporting platform. It provides reporting functionality from different datasourses. […]
SQL Server : Table Variables
1. What are table variables Table variables – A special data type that can be used to store a result set for later processing. Its primary […]
- .NET Interview Questions
- Product Management
- Product Management Interview Questions
- Product Owner Interview Questions
- Program Management
- Project Management
- Project Management Articles
- Project Management Interview Questions
- SQL Server Articles
- Technical Program Management
- Technical Program Management - Interview Questions
- TechnicalProgramManagement
- TPM Interview Questions
SQL Server 2005 Enhancements
New features in SQL 2005 in brief: SQL Server 2005 as .NET runtime host: enhancing security, reliability, and performance Writing procedures, functions, and triggers in […]
SQL Linked Server
Linked Server Creation Through Linked Server, you can connect to any other database or SQL Server database in other server and retrieve or modify the […]
Types of Joins in SQL
Types of Joins Inner Join Left Outer Join Right Outer Join Full Outer Join Cross Join When you join tables, the type of join that […]