All Sql Server-2005 Solutions on Gang of Coders

Total of 254 Sql Server-2005 Solutions

Check if table exists in SQL Server

Sql ServerTsqlSql Server-2005Sql Server-2000

SQL Server equivalent to Oracle's NULLS FIRST?

SqlSql ServerSql Server-2005Tsql

Pass table as parameter into sql server UDF

SqlSql ServerSql Server-2005ParametersUser Defined-Functions

Is there any difference between IS NULL and =NULL

SqlSql ServerSql Server-2005

How to select date without time in SQL

SqlSql ServerSql Server-2005

SET versus SELECT when assigning variables?

SqlSql ServerSql Server-2005TsqlSql Server-2008

Sql Server 2005 how to change dbo login name

Sql ServerSql Server-2005SecurityActive Directory

Nested stored procedures containing TRY CATCH ROLLBACK pattern?

Sql Server-2005Linq to-SqlStored ProceduresTransactions

Return value from exec(@sql)

SqlSql ServerSql Server-2005Tsql

How to select rows for a specific date, ignoring time in SQL Server

SqlSql Server-2005

Drop primary key using script in SQL Server database

Sql ServerSql Server-2008Sql Server-2005

What is the difference between a primary key and a surrogate key?

SqlSql ServerSql Server-2008Sql Server-2005Sql Server-2012

How to choose returned column name in a SELECT FOR XML query?

SqlSql ServerXmlSql Server-2005

How to find slowest queries

Sql ServerSql Server-2005Profiling

SQL query to find Missing sequence numbers

Sql Server-2005Gaps and-Islands

IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

SqlSql ServerSql Server-2005Tsql

Convert SQL Server result set into string

SqlSql ServerSql Server-2005Tsql

"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP

PhpSql ServerSql Server-2005FreetdsUnixodbc

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

SqlSql ServerSql Server-2005Tsql

Determine what user created objects in SQL Server

SqlSql Server-2005Tsql

Unable to create index because of duplicate that doesn't exist?

Sql Server-2005TsqlIndexingUnique Index

What is difference between datetime and timestamp

Sql Server-2005

SQL providerName in web.config

asp.netSql Server-2005Connection String

SQL Server GUID sort algorithm. Why?

Sql ServerSql Server-2005Sql Server-2008Sorting

How can I force a query to not use a index on a given table?

SqlSql Server-2005Indexing

SQL Server compare results of two queries that should be identical

Sql ServerSql Server-2005

SQL Server 2005 - Export table programmatically (run a .sql file to rebuild it)

SqlSql ServerSql Server-2005Database Table

How can I determine the status of a job?

SqlSql Server-2005TsqlStored Procedures

Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"

SqlSql ServerSql Server-2005OptimizationSql Execution-Plan

CASE IN statement with multiple values

SqlSql ServerSql Server-2005

The tail of the log for the database "DBName" has not been backed up

C#SqlSql Server-2005Sharepoint

Database Deployment Strategies (SQL Server)

C#asp.netSql Server-2005SvnVisual Studio-2005

Integer division in sql server

Sql Server-2005

What is the equivalent datatype of SQL Server's Numeric in C#

C#Sql Server-2005

How do you kill all current connections to a SQL Server 2005 database?

Sql ServerSql Server-2005

How to return multiple values in one column (T-SQL)?

SqlSql ServerSql Server-2005Tsql

Can I save an 'Object' in a SQL Server database?

C#Sql ServerSql Server-2005ado.net

Fastest way to update 120 Million records

SqlSql ServerSql Server-2005

Extreme wait-time when taking a SQL Server database offline

DatabaseSql Server-2005Performance

How to get calendar Quarter from a date in TSQL

SqlSql ServerTsqlSql Server-2005

SQL Server 2005: T-SQL to temporarily disable a trigger

Sql ServerSql Server-2005Tsql

SQL Server error on update command - "A severe error occurred on the current command"

Sql ServerSql Server-2005Tsql

Why can't I put a constraint on nvarchar(max)?

Sql ServerSql Server-2005

How to insert a blob into a database using sql server management studio

SqlSql ServerSql Server-2005Blob

SQL Query to find the last day of the month

Sql ServerSql Server-2005DateDatetime

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

SqlSql ServerSql Server-2005Foreign Keys

Create a date from day month and year with T-SQL

SqlSql ServerSql Server-2005Tsql

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints

SqlSql ServerDatabaseSql Server-2005Custom Data-Type

How do I drop a foreign key constraint only if it exists in sql server?

SqlSql ServerSql Server-2005Tsql

Check if a string contains a substring in SQL Server 2005, using a stored procedure

Sql ServerStringTsqlStored ProceduresSql Server-2005

How do I use an INSERT statement's OUTPUT clause to get the identity value?

SqlSql Server-2005Insert

"Prevent saving changes that require the table to be re-created" negative effects

Sql ServerSql Server-2008Database DesignSql Server-2005

What is the maximum characters for the NVARCHAR(MAX)?

Sql ServerSql Server-2008Sql Server-2005

How can I solve a connection pool problem between ASP.NET and SQL Server?

.Netasp.netSql ServerSql Server-2005

How do I check if a Sql server string is null or empty

Sql Server-2005

Select top 10 records for each category

SqlSql ServerSql Server-2005Greatest N-per-Group

SQL Server query to find all permissions/access for all users in a database

Sql ServerSql Server-2005Sql Server-2008

What are the main performance differences between varchar and nvarchar SQL Server data types?

Sql ServerSql Server-2005StorageVarcharNvarchar

sql query to return differences between two tables

SqlSql ServerSql Server-2008Sql Server-2005

Use variable with TOP in select statement in SQL Server without making it dynamic

SqlSql ServerSql Server-2005Tsql

Convert Month Number to Month Name Function in SQL

SqlSql ServerTsqlSql Server-2005

Turn off constraints temporarily (MS SQL)

SqlSql ServerSql Server-2005ConstraintsEntity Relationship

How can a LEFT OUTER JOIN return more records than exist in the left table?

SqlSql ServerSql Server-2005Tsql

How to update two tables in one statement in SQL Server 2005?

SqlSql ServerSql Server-2005Tsql

Extracting hours from a DateTime (SQL Server 2005)

SqlTsqlDatetimeSql Server-2005Hour

The multi-part identifier could not be bound

SqlSql ServerSql Server-2005

How to get Time from DateTime format in SQL?

Sql ServerTsqlSql Server-2005Datetime

SQL Server - transactions roll back on error?

SqlSql ServerSql Server-2005Transactions

Referring to a Column Alias in a WHERE Clause

SqlSql ServerTsqlSql Server-2005

Best way to do nested case statement logic in SQL Server

SqlSql ServerSql Server-2005SelectNested

Convert a string to int using sql query

SqlSql Server-2005

Difference between a User and a Login in SQL Server

SqlSql ServerSql Server-2005

Sql Server string to date conversion

Sql ServerTsqlDatetimeSql Server-2005String to-Datetime

How important is the order of columns in indexes?

SqlSql ServerSql Server-2005TsqlIndexing

SQL Server String or binary data would be truncated

Sql ServerTsqlSql Server-2005MigrationData Migration

SQL Server Restore Error - Access is Denied

Sql ServerSql Server-2005BackupRestore

nvarchar(max) vs NText

Sql ServerSql Server-2005Sql Server-2008TextNvarchar

How to check which locks are held on a table

SqlSql ServerDatabasePerformanceSql Server-2005

Add a column with a default value to an existing table in SQL Server

SqlSql ServerSql Server-2005Sql Server-2000

How do I check if a SQL Server text column is empty?

Sql ServerSql Server-2005SqldatatypesNotnullEmptydatatext

What good are SQL Server schemas?

Sql Server-2005SchemaTheory

Difference between database and schema

Sql ServerDatabaseSql Server-2005Database Schema

Measure the time it takes to execute a t-sql query

PerformanceSql Server-2005

What is the difference between a stored procedure and a view?

SqlSql Server-2005Stored ProceduresViews

Better techniques for trimming leading zeros in SQL Server?

SqlSql ServerSql Server-2005TsqlString

How to delete all rows from all tables in a SQL Server database?

Sql Server-2005

How can I change my default database in SQL Server without using MS SQL Server Management Studio?

Sql ServerSql Server-2005SsmsDefault Database

Sql Server equivalent of a COUNTIF aggregate function

SqlSql Server-2005

How to find current transaction level?

SqlSql ServerSql Server-2008Sql Server-2005Isolation Level

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

Sql ServerSql Server-2005Database Connectivity

SQL update query using joins

SqlSql ServerTsqlSql Server-2005Sql Update

When restoring a backup, how do I disconnect all active connections?

Sql ServerSql Server-2005BackupRestoreDisconnect

How to identify all stored procedures referring a particular table

SqlTsqlSql Server-2005

Check if a temporary table exists and delete if it exists before creating a temporary table

Sql ServerSql Server-2005Temp TablesAlter Table

How to change identity column values programmatically?

Sql ServerSql Server-2005TsqlIdentitySql Server-2005-Express

SQL query to group by day

SqlSql ServerSql Server-2005Group By

Alter table add multiple columns ms sql

Sql Server-2005

Enable SQL Server Broker taking too long

Sql Server-2005Service Broker

Get top 1 row of each group

SqlSql ServerTsqlSql Server-2005Greatest N-per-Group

SQL Server, convert a named instance to default instance?

Sql ServerSql Server-2005Named Instance

How do you copy a record in a SQL table but swap out the unique id of the new row?

SqlSql ServerSql Server-2005Tsql

What does collation mean?

SqlSql Server-2005TsqlMysql

SQL statement to select all rows from previous day

SqlSql ServerSql Server-2005

Real life example, when to use OUTER / CROSS APPLY in SQL

SqlSql ServerSql Server-2008Sql Server-2005

Insert all values of a table into another table in SQL

SqlSql ServerSql Server-2005

T-SQL: Opposite to string concatenation - how to split string into multiple records

Sql ServerSql Server-2005Tsql

How to detect if a stored procedure already exists

SqlSql Server-2005Stored Procedures

Base64 encoding in SQL Server 2005 T-SQL

Sql Server-2005TsqlEncodingBase64

Can I create a One-Time-Use Function in a Script or Stored Procedure?

SqlSql ServerSql Server-2005TsqlScripting

Entity Framework and SQL Server View

Entity FrameworkSql Server-2005.Net 3.5Primary KeySql View

Difference between FOR and AFTER triggers?

SqlSql Server-2005Triggers

Login failed for user 'DOMAIN\MACHINENAME$'

.NetSql ServerSql Server-2005Web ApplicationsIis 6

How to strip HTML tags from a string in SQL Server?

HtmlSqlSql ServerStringSql Server-2005

Getting result of dynamic SQL into a variable for sql-server

SqlSql ServerSql Server-2005TsqlDynamic Sql

Parse usable Street Address, City, State, Zip from a string

StringParsingSql Server-2005Street Address

How can I get the actual stored procedure line number from an error message?

SqlSql Server-2005

how to increment integer Columns value by 1 in SQL

SqlSql Server-2005Sql Update

SQL Server IN vs. EXISTS Performance

Sql ServerSql Server-2005ExistsQuery PerformanceSql In

How much size "Null" value takes in SQL Server

Sql ServerTsqlSql Server-2005Null

How to change column order in a table using sql query in sql server 2005?

SqlSql Server-2005

WITH (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SqlSql ServerSql Server-2005

How to change a table name using an SQL query?

SqlSql ServerSql Server-2005

Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

Sql ServerTsqlSql Server-2005Insert

How to print VARCHAR(MAX) using Print Statement?

SqlSql ServerSql Server-2005TsqlSql Server-2008

Querying data by joining two tables in two database on different servers

SqlSql ServerDatabaseSql Server-2005Sql Server-2008

How do I query if a database schema exists

Sql Server-2005Schema

Datatype for storing ip address in SQL Server

Sql ServerTsqlSql Server-2005TypesIp Address

Convert varchar to uniqueidentifier in SQL Server

SqlSql Server-2005Uniqueidentifier

SQL Server - where is "sys.functions"?

SqlSql ServerSql Server-2005Stored Functions

Execution sequence of Group By, Having and Where clause in SQL Server?

SqlSql ServerSql Server-2005

varbinary to string on SQL Server

SqlSql ServerSql Server-2005Tsql

Using SQL Server 2008 and SQL Server 2005 and date time

Sql Server-2005Entity FrameworkSql Server-2008DatetimeDatetime2

Is the LIKE operator case-sensitive with SQL Server?

SqlSql Server-2005VarcharSql Like

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

Sql ServerSql Server-2005TsqlTruncateForeign Keys

Get the week start date and week end date from week number

SqlSql ServerDateSql Server-2005Week Number

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio

SqlSql Server-2005

Selecting COUNT(*) with DISTINCT

SqlSql ServerSql Server-2005Tsql

What is "Audit Logout" in SQL Server Profiler?

C#LinqSql Server-2005Linq to-SqlSql Server-Profiler

conditional unique constraint

SqlSql ServerSql Server-2005

How to insert table values from one database to another database?

SqlSql Server-2005IntegrationAppend

Unable to begin a distributed transaction

Sql ServerSql Server-2005MsdtcDistributed Transactions

What's the best way to select the minimum value from several columns?

SqlSql ServerTsqlSql Server-2005Min

SQL Server table creation date query

SqlSql ServerTsqlSql Server-2005

Use a LIKE statement on SQL Server XML Datatype

SqlSql ServerXmlSql Server-2005

How do I fetch multiple columns for use in a cursor loop?

TsqlSql Server-2005

How to query for Xml values and attributes from table in SQL Server?

Sql ServerXmlSql Server-2005Sql Server-2008-R2Sqlxml

How to determine total number of open/active connections in ms sql server 2005

Sql ServerDatabaseSql Server-2005Connection

What is the point of "Initial Catalog" in a SQL Server connection string?

Sql ServerDatabaseSql Server-2005Connection StringDatabase Connection

WHERE clause on SQL Server "Text" data type

Sql ServerSql Server-2005Tsql

Declare Variable for a Query String

SqlSql ServerSql Server-2005TsqlDynamic Sql

How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?

Sql ServerSql Server-2005

Why use the INCLUDE clause when creating an index?

Sql ServerSql Server-2008Sql Server-2005Indexing

Find stored procedure by name

SqlDatabaseSql Server-2005Ssms

Received an invalid column length from the bcp client for colid 6

C#.NetSql ServerDatabaseSql Server-2005

MultipleActiveResultSets=True or multiple connections?

C#.NetSql ServerSql Server-2005ado.net

Disadvantages of MARS (Multiple Active Result Sets)?

Sql Server-2005Sql Server-Mars

Is it necessary to use # for creating temp tables in SQL server?

SqlSql ServerSql Server-2008Sql Server-2005

SQL Server ORDER BY date and nulls last

Sql ServerSql Server-2005Tsql

Simple DateTime sql query

SqlSql ServerSql Server-2005TsqlSql Server-2008

Rounding SQL DateTime to midnight

SqlSql ServerSql Server-2005Getdate

How do you specify a different port number in SQL Management Studio?

Sql ServerSql Server-2005Ssms

How to export data from SQL Server 2005 to MySQL

MysqlSql ServerCsvSql Server-2005Bcp

How to parse string into date?

TsqlSql Server-2005

SQL Server 2005 implementation of MySQL REPLACE INTO?

MysqlSql ServerSql Server-2005

Watching variables in SSIS during debug

SqlSql Server-2005DebuggingSsisWatch

SELECT FOR UPDATE with SQL Server

SqlSql ServerSql Server-2005TsqlRead Committed-Snapshot

Export table data from one SQL Server to another

SqlSql ServerSql Server-2005Export

Does T-SQL have an aggregate function to concatenate strings?

Sql ServerSql Server-2005TsqlGroup ByAggregate Functions

SQL Identity (autonumber) is Incremented Even with a Transaction Rollback

.NetSqlSql Server-2005TransactionsIdentity Column

Select info from table where row has max date

SqlSql Server-2005Greatest N-per-Group

How to avoid the "divide by zero" error in SQL?

SqlSql ServerSql Server-2005Sql Server-2008

Diagnosing Deadlocks in SQL Server 2005

Sql ServerSql Server-2005Deadlock

How do I check if a nonclustered index exists in SQL Server 2005

Sql Server-2005Non Clustered-Index

Alter a SQL server function to accept new optional parameter

SqlSql Server-2005

Index Key Column VS Index Included Column

Sql Server-2005Tsql

How do I view the SSIS packages in SQL Server Management Studio?

Sql Server-2005SsisSsms

Can I add a not null column without DEFAULT value

SqlSql ServerSql Server-2005Tsql

How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

Sql Server-2005TsqlCollation

Search for a string in all tables, rows and columns of a DB

SqlSql Server-2005

How do I find the data directory for a SQL Server instance?

SqlSql ServerSql Server-2008Sql Server-2005Sql Server-2008-R2

SQL Server Invalid Column name after adding new column

SqlSql ServerSql Server-2008TsqlSql Server-2005

How to find sum of multiple columns in a table in SQL Server 2005?

SqlSql ServerSql Server-2005

What is the best way to create and populate a numbers table?

Sql ServerSql Server-2005

How can I convert ticks to a date format?

C#asp.netSql ServerSql Server-2005

Insert results of a stored procedure into a temporary table

SqlSql ServerSql Server-2005TsqlStored Procedures

How to SELECT FROM stored procedure

SqlSql ServerSql Server-2005Stored Procedures

Insert multiple values using INSERT INTO (SQL Server 2005)

SqlSql ServerSql Server-2005Tsql

List rows after specific date

SqlSql ServerSql Server-2008Sql Server-2005

SQL query, store result of SELECT in local variable

Sql Server-2005

Unique Key Violation in SQL Server - Is it safe to assume Error 2627?

Sql Server-2005Unique Constraint

T-SQL Substring - Last 3 Characters

SqlSql ServerSql Server-2005Tsql

Passing an array of parameters to a stored procedure

SqlSql Server-2005Stored Procedures

Insert Picture into SQL Server 2005 Image Field using only SQL

SqlSql ServerSql Server-2005Image

how to insert datetime into the SQL Database table?

.NetSqlSql ServerSql Server-2005C# 3.0

How to compare two dates to find time difference in SQL Server 2005, date manipulation

SqlSql Server-2005DateDatediff

SQL query to select dates between two dates

SqlSql ServerTsqlDatetimeSql Server-2005

Datetime in where clause

SqlSql ServerDatetimeSql Server-2005Filter

Find non-ASCII characters in varchar columns using SQL Server

Sql ServerTsqlSql Server-2005Non Ascii-Characters

Most recent record in a left join

SqlSql ServerSql Server-2005

Are there any disadvantages to always using nvarchar(MAX)?

SqlSql ServerSql Server-2005

How to rollback or commit a transaction in SQL Server

SqlSql ServerSql Server-2008Sql Server-2005

Advantages of SQL Server 2008 over SQL Server 2005?

Sql Server-2005Sql Server-2008Comparison

How can I do an UPDATE statement with JOIN in SQL Server?

SqlSql ServerTsqlSql Server-2005Sql Update

What represents a double in sql server?

C#SqlSql ServerSql Server-2005Tsql

Compare dates in T-SQL, ignoring the time part

SqlSql ServerSql Server-2005Tsql

Can an INNER JOIN offer better performance than EXISTS

SqlSql ServerSql Server-2005PerformanceTsql

EXISTS vs JOIN and use of EXISTS clause

SqlSql ServerSql Server-2005Sql Server-2008

How do you drop a default value from a column in a table?

Sql Server-2005Tsql

Simulating group_concat MySQL function in Microsoft SQL Server 2005?

SqlSql ServerSql Server-2005String Aggregation

Size of VARBINARY field in SQL Server 2005

SqlSql ServerSql Server-2005Clr

How do I change the owner of a SQL Server database?

Sql ServerSql Server-2005Permissions

Truncate Table Within Transaction

SqlSql ServerSql Server-2005TransactionsTruncate

Check whether a table contains rows or not sql server 2005

Sql Server-2005

SQL Query to add a new column after an existing column in SQL Server 2005

SqlSql ServerSql Server-2005

Decimal values in SQL for dividing results

Sql ServerSql Server-2005

How to upsert (update or insert) in SQL Server 2005

Sql Server-2005

Is a Primary Key necessary in SQL Server?

SqlSql ServerSql Server-2005

SQL Server: how to write an alter index statement to add a column to the unique index?

Sql Server-2005IndexingAlter

Parameter Sniffing (or Spoofing) in SQL Server

Sql ServerTsqlSql Server-2005Parameter Spoofing

Dynamic SELECT TOP @var In SQL Server

SqlSql Server-2005

How to export SQL Server 2005 query to CSV

Sql ServerSql Server-2005BcpSqlcmd

Why is it considered bad practice to use cursors in SQL Server?

Sql ServerSql Server-2005Database Cursor

How to store directory / hierarchy / tree structure in the database?

Sql ServerSql Server-2005Database DesignTree Structure

Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

Sql Server-2005UnicodeSsisTypesNon Unicode

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

Sql ServerSql Server-2005TsqlUser Defined-Functions

How do parameterized queries help against SQL injection?

C#.NetSqlSql Server-2005Parameterized Query

How to insert multiple records and get the identity value?

SqlSql ServerSql Server-2005

Column name or number of supplied values does not match table definition

SqlSql ServerSql Server-2005Tsql

Can there be constraints with the same name in a DB?

SqlSql ServerSql Server-2005TsqlConstraints

Convert Xml to Table SQL Server

SqlXmlSql Server-2008TsqlSql Server-2005

How get the T-SQL code to find duplicates?

Sql Server-2005TsqlSsms

UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'

Sql Server-2005

Generate a resultset of incrementing dates in TSQL

SqlSql ServerDatabaseSql Server-2005Tsql

When using Trusted_Connection=true and SQL Server authentication, will this affect performance?

C#.Netasp.netSql Server-2005ado.net

Add a row number to result set of a SQL query

SqlSql ServerSql Server-2005

How to get SQL Profiler to monitor trigger execution

Sql ServerSql Server-2005Sql Server-Profiler

How to get difference between two rows for a column field?

SqlSql ServerTsqlSql Server-2005

How can I create a SQL unique constraint based on 2 columns?

Sql ServerSql Server-2005Sql Server-2008ConstraintsUnique Constraint

Increment Row Number on Group

SqlSql ServerSql Server-2005

SQL Server 2005 drop column with constraints

Sql ServerSql Server-2005

SQL GROUP BY CASE statement with aggregate function

SqlSql ServerSql Server-2005Group By

How to get number of rows inserted by a transaction

Sql ServerSql Server-2005

How to get first character of a string in SQL?

SqlSql ServerSql Server-2005

Execute Stored Procedure from a Function

SqlSql ServerSql Server-2005Stored ProceduresUser Defined-Functions

Convert SSMS .rpt output file to .txt/.csv

Sql ServerSql Server-2005Character EncodingSsmsRpt

How do I avoid character encoding when using "FOR XML PATH"?

XmlSql Server-2005EncodingFor Xml-Path

Create a one to many relationship using SQL Server

SqlSql ServerSql Server-2005

Is it possible to force row level locking in SQL Server?

Sql ServerSql Server-2005Sql Server-2008Rowlocking

Foreign key relationship with composite primary keys in SQL Server 2005

Sql Server-2005Foreign Key-RelationshipComposite Primary-Key

What's the fastest way to bulk insert a lot of data in SQL Server (C# client)

C#SqlSql ServerSql Server-2005

Rename SQL Server Schema

SqlSql ServerSql Server-2005Schema

Delete duplicate records from a SQL table without a primary key

SqlSql Server-2005TsqlDuplicate Removal

adding a column description

SqlSql ServerSql Server-2005

How to use alias column name in where clause in SQL Server

Sql Server-2005