SQL Journey

Journey of SQL Server & Microsoft Business Intelligence

Post List

List of all published posts:

SQL Server – Send Mail Using SP_Send_DBMail

SQL Server – Configure Database Mail to Send Email Using Gmail or Live Account

SQL Server – Date Formats

SQL Server – Track Database Size Growth Trend

SQL Server – Search Text in Stored Procedure

SSIS – Error: Could not get a list of SSIS packages from the project

SSIS – Create New Excel File Dynamically to Export Data

SQL Server – Resolve Collation Conflict with Temp Table

SQL Server – List of Tables Used in Stored Procedure

SQL Server: Allow Only Alpha Numeric Characters to a Column

SQL Server: Kill process running xp_cmdshell

SQL Server: Running VB Script From TSQL

SQL Server: SET vs SELECT in Variable Assignment

SQL Server: Remove Non-Alphanumeric Characters from a Column

SQL Server: Keyboard Shortcuts – Part 1

Fixing Error: 8134 (Devided By Zero Error Encountered) in SQL Server

Finding Nth highest number in SQL Server

CHECK constraint with User Defined Function in SQL Server

Generate Report with Alternate Order of an Attribute (say Gender) in SQL Server

SQL Server Reporting Tool – SqlAnswersQuery

My Windows is 32-bit or 64-bit Operating System?

Insert Excel Data into a SQL Server table using OPENROWSET

Fixing Error Message 1807 could not obtain exclusive lock on database ‘model’ in SQL Server

UNIQUE Key Constraint with Multiple NULL values in SQL Server

Insert or Copy Data into Table

Condition based Update in SQL Server

Check existence of Table or Database before creating it in SQL Server

Get List Of Files From a Windows Directory to SQL Server

Insert Data into table with two columns, one is Identity column and another is RowVersion

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: