Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Querying Microsoft SQL Server

I am a technology enthusiast and software developer by profession. I am developing .Net/database based enterprise applications from past 3 years.

My skills includes C# ,ASP.NET,SQL Server 2008 and MVC . My areas of interests are database development and application software development using Microsoft Technologies.

Archives: September 2012

Basics of Triggers in SQL Server

Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers:  A trigger is a procedural code like stored procedure that is automatically executed on certain actions (like insert, de...

Read more

0 comments, 190 reads

Posted in Querying Microsoft SQL Server on 29 September 2012

Basics of Indexes in SQL Server

Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in last of book an index is provided that has some titles and page numbers. You don’t need ...

Read more

0 comments, 134 reads

Posted in Querying Microsoft SQL Server on 29 September 2012

Connection String from Visual Studio

Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect with data source.You can connect your project with ...

Read more

0 comments, 119 reads

Posted in Querying Microsoft SQL Server on 22 September 2012

Data Types in SQL Server

Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63  to 2^63-1) It takes 8 B...

Read more

0 comments, 71 reads

Posted in Querying Microsoft SQL Server on 22 September 2012

Functions in SQL Server

 Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL statements for reuse.SQL Server pro...

Read more

0 comments, 101 reads

Posted in Querying Microsoft SQL Server on 22 September 2012

Error Handling in T-SQL

 Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A group of statements  encl...

Read more

0 comments, 133 reads

Posted in Querying Microsoft SQL Server on 22 September 2012

Defining Variables

Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your variables. A variable is known as lo...

Read more

0 comments, 169 reads

Posted in Querying Microsoft SQL Server on 19 September 2012