If you need to query all People from Person table with FirstName start with A, you can easily query like below, What if you want to list all the people from person table with first name start with A and…
debug mode……
debugging the learning
Blog Archives
SQL Server Tip : . Where to use SQURE Bracket around table name?
Have you ever thought, what if your table name 1. Is exactly as of SQL Server keyword 2. Is having space in between like Student Fav Actor If you go ahead and query against table Student Fav Actor like below,…
Output clause in SQL Server
Level: Beginners [level 100] Output clause gives access to Inserted, updated or deleted rows of table. In SQL Server 2005 this was possible only through Triggers. Note: In all explanation, I am going to use School Database. You can…
SQL Server: WAITFOR Statement
WAITFOR statement used to delay execution of T-SQL command for a specified period of time. This can be used to block the execution of batch statement, stored procedure and T SQL commands for a specified time. There are two parameters…
Posted in SQL Server
String Concatenation and Scope Resolution Operator in SQL Server 2008 R2
Target Audience: Beginners SQL Server 2008 R2 comes with String Concatenation Operator. String Concatenation operator is denoted by symbol plus ‘+’. Output we will get, String concatenation operator can concatenate string with real time data of any type also. In…
Posted in SQL Server
Microsoft Sql Server, Error : 10061
I tried to connect SQLTEST instance of SQL Server and got below error This is very common error and can be caused due to many reasons. The way I solved it 1. Go to Start 2. Type Run 3. Type…
Tracking Change Data Capture in SQL Server 2008
A very important feature of SQL Server 2008 is that we can enable CDC [Change Data capture] on database or table. We can track the database had CDC enabled by querying IS_CDC_ENABLED column In above query School is name of…
Posted in SQL Server
Data Compression in SQL Server 2008
SQL Server 2008 automatically compress data stored in database. SQL server does Lossless data compression. SQL server uses Dictionary based compression algorithm. Row Level Data Compression For Row level Data Compression SQL Server does not use explicitly any standard compression…
Posted in SQL Server
Create a SQL Login user in SQL Server 2008
This article will give a walkthrough on creating a SQL Login user. Step 1 Login to SQL Server 2008 instance using windows authentication Step 2 Right click on server instance name and select properties. Step 3 Property window will be…
Posted in SQL Server
