SQL Server – List of all the Error codes or messages

SQL, SQL-Advanced, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Contains one row for each system error or warning that can be returned by Microsoft SQL Server. SQL Server displays the error description on the user’s screen. You can get the List of all the Error codes or messages as USE master GO SELECT * FROM sysmessages You will get the five columns as Error – Unique error number Severity – Severity level of the error Dlevel – For internal use only Description – Explanation of the error with placeholders

» Read more
, ,

Exporting Your LinkedIn Connections or Contacts

Others, Varinder Sandhu

How do I export my LinkedIn connections? You can easily export your Linked connections or contacts into CSV (Comma Separated Values) files. You can later import this CSV into any other email program. Click Connections at the top of your contact Menu The connections screen open, at the button of screen you will get the Export Connections button Once you click on Export Connections button, you will the following screen You can choose your Export as you need like CSV

» Read more
, ,

SQL SERVER – The Self Join

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

A self-join is joining a table to itself. This is done by using table name aliases to give each instance of the table a separate name. Self Join is very useful when you want to compare values in a column to other values in the same column. Self join and its example is very common question in the interview. Let us take a look to example

» Read more
, ,

SQL Server – SQL Scripts to find and Kill all the Blocked Process in a database

SQL, SQL-Advanced, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

SQL Server database administrators frequently need in especially development and test environments to find and kill all the blocked process. Following scripts are useful in that scenario. Script – 1 — Find All the Blocked Processes SELECT spid, status, loginame=SUBSTRING(loginame,1,12), hostname=SUBSTRING(hostname,1, 12), blk = CONVERT(char(3), blocked), dbname=SUBSTRING(DB_NAME(dbid),1, 10), cmd, waittype FROM master.dbo.sysprocesses WHERE spid IN (SELECT blocked FROM master.dbo.sysprocesses)   Script 2 — Kill all the Blocked Processes of a Database DECLARE @DatabaseName nvarchar(50) — Set the Database Name SET

» Read more
, , ,

SQL Server Denali – New Logical Functions

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, SQL-Tips and Tricks, Varinder Sandhu

There are two new Logical functions are introduced in Denali. Let‘s have a look IFF CHOOSE IFF It Returns one of two values, depending on whether the Boolean expression evaluates to true or false. IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. That is, the true_value is returned if the Boolean expression

» Read more
, , ,

SQL Server – Ranking Functions – RANK, DENSE_RANK, ROW_NUMBER, NTILE

SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic. There are four functions RANK DENSE_RANK ROW_NUMBER NTILE RANK   Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. DENSE_RANK Returns the rank of

» Read more
, , , , ,

ASP.Net – Introducing LINQ Data Providers

ASP.Net, LINQ, Varinder Sandhu

The LINQ language extensions allow you to query data in a consistent manner. However, LINQ also includes additions to the .NET Framework itself for working with specific types of data such as relational databases, XML, and objects.These additions allow you to connect to this data, query against it, and insert, update, and delete items within the data all by using strongly typed objects. The following lists the core data types ( LINQ Data Providers )LINQ supports in the .NET Framework: LINQ to

» Read more
, ,

ASP.Net – Introducing LINQ

ASP.Net, LINQ, Varinder Sandhu

LINQ stands on Language Integrated Query. LINQ changes the way you access and query data. Before LINQ was created, most queries were expressed as text that was executed against a database. This SQL text was often specific to the underlying technology of the database being queried. LINQ elevates the process of querying for data to actual language constructs and keywords. This has two primary advantages: First, it provides type checking of your query code at compile time; this means that

» Read more
, ,

How to Backup & Archive All Your Facebook Data

Others, Varinder Sandhu

One of most useful feature of Facebook that allow you to download your complete profiles as a backup. This Backup includes all your messages, Wall Posts, photos, status updates and profile information. All you need to do is follow the guide below to get your complete Facebook profile backup ( Facebook Data ) Go to Accounts setting Click on “Download a Copy” Click on “Start My Archive” Go to given URL or Link (as you received in your email) Enter

» Read more
,

Joes 2 Pros – SQL Query Techniques for Microsoft SQL Server 2008, Volume 2

SQL, SQL-Tips and Tricks, Varinder Sandhu

This book has been authored by Rick A. Morelan. If you are a SQL Developer, you must read the series of this book. Highlights of the Book The Contents of the 2th Volume of the SQL Queries Joes 2 Pros Data information and Tables Query Options Null, Expressions, and Identity Fields Aggregating Data Aggregation Strategies Top Records Ranking Functions Multiple Query Operators Common Table Expressions (CTE) Data Recursion Using Sub queries Table Data Actions The Merge Statement The Output Clause

» Read more

SQL Server 2008 – Object Explorer Details and SQL Server Object Search

SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

My one friend calls me and asks where I find the Object detail in SQL Server 2008. This is very simple but may be some people are in the same situation and finding the Object Explorer Details in SQL Server 2008. That‘s why here sharing Object Explorer Details and SQL Server Object Search. SQL Server Object Search is useful for developer to find the some specific object in the database or across SQL Instance. Object Explorer Details, a component of

» Read more
, , ,

SQL Server – PARSE() and TRY_PARSE() conversion functions

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, SQL-Tips and Tricks, Varinder Sandhu

PARSE() and TRY_PARSE() are new conversion function introduced in SQL Server Denali. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns error. Also, we can also specify the CULTURE, during this conversion.  CULTURE, means a language which will used by SQL Server to interpret data. If

» Read more
, , ,
1 … 14 15 16 17 18 … 26