SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

Avoiding prefix 'sp_' in the name of user stored procedure

Avoiding prefix 'sp_' in the name of user stored procedure in SQL Server
Venkatesan Jayakantham May 10, 2012
Find the execution time of a stored procedure

Find the execution time of a stored procedure in SQL Server
Venkatesan Jayakantham May 10, 2012
Capturing Information of SQL server Configurations

In this blog we are going to learn how to capture the details of configurations in sql server.
Lajapathy Arun May 09, 2012
Getting Information of Supporting Languages in SQL Server

In this blog we are going to learn how to capture information about Supporting Languages in SQL Server.
Lajapathy Arun May 09, 2012
Getting SQL Script of database object using sys.syscomments in SQL Server

Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database
Lajapathy Arun May 09, 2012
List of Object Type available in SQL Server

In this blog we are going to learn what are all the Object Type available in SQL Server.
Lajapathy Arun May 09, 2012
Getting SQL Script of database object of used Database using sys. sql_modules in SQL Server

Get the SQL Script of database object using sys. sql_modules in SQL Server
Lajapathy Arun May 09, 2012
Adding and removing the default constraint on a table

Adding and removing the default constraint on a table.
Vikrant More May 06, 2012
How to get list of all Triggers with table name in MS-SQL

Which trigger belongs to wich table and schema
Anil Kumar May 04, 2012
Get Recent records from the table

Get Recent records from the table
Venkatesan Jayakantham May 04, 2012
Analysis Services version '10.50.1600.1'

Cannot connect to Analysis Services version '10.50.1600.1'.
Venkatesan Jayakantham May 04, 2012
Quoting the Input String with the Specified Character

Quoting the input string with the specified character.
Venkatesan Jayakantham May 04, 2012
Listing Down Server Directories in SQL Server

Listing down Server directories in SQL Server.
Venkatesan Jayakantham May 04, 2012
Error in executing xp_cmdshell Command

Error in executing xp_cmdshell command.
Venkatesan Jayakantham May 04, 2012
Error in Executing OpenRowset or OpenDatasource Queries

Error in executing OpenRowset or OpenDatasource queries.
Venkatesan Jayakantham May 04, 2012
Installing AdventureWorks Database for SQL Server 2008R2 Version

Installing AdventureWorks database for SQL Server 2008R2 version
Venkatesan Jayakantham May 04, 2012
Deployment issue in SQL Server Analysis Services

Deployment issue in SQL Server Analysis Services.
Venkatesan Jayakantham May 04, 2012
Adventure Works Deployment Issue in SQL Server Analysis Services

Here we will see, Adventure Works deployment issue in SQL Server Analysis Services.
Venkatesan Jayakantham May 04, 2012
Connecting SQL Server Analysis Services Engine

Connecting SQL Server analysis services engine.
Venkatesan Jayakantham May 04, 2012
Issue with Datetime in SQL Server and C# code

Issue with Datetime in SQL Server and C# code
Venkatesan Jayakantham May 03, 2012

341 - 360 of 498