Gang Of Coders
Home
About Us
Contact Us
All Sql Server-2005 Solutions on Gang of Coders
Total of 254 Sql Server-2005 Solutions
Check if table exists in SQL Server
Sql Server
Tsql
Sql Server-2005
Sql Server-2000
SQL Server equivalent to Oracle's NULLS FIRST?
Sql
Sql Server
Sql Server-2005
Tsql
Pass table as parameter into sql server UDF
Sql
Sql Server
Sql Server-2005
Parameters
User Defined-Functions
Is there any difference between IS NULL and =NULL
Sql
Sql Server
Sql Server-2005
How to select date without time in SQL
Sql
Sql Server
Sql Server-2005
SET versus SELECT when assigning variables?
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Sql Server 2005 how to change dbo login name
Sql Server
Sql Server-2005
Security
Active Directory
Nested stored procedures containing TRY CATCH ROLLBACK pattern?
Sql Server-2005
Linq to-Sql
Stored Procedures
Transactions
Return value from exec(@sql)
Sql
Sql Server
Sql Server-2005
Tsql
How to select rows for a specific date, ignoring time in SQL Server
Sql
Sql Server-2005
Drop primary key using script in SQL Server database
Sql Server
Sql Server-2008
Sql Server-2005
What is the difference between a primary key and a surrogate key?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Sql Server-2012
How to choose returned column name in a SELECT FOR XML query?
Sql
Sql Server
Xml
Sql Server-2005
How to find slowest queries
Sql Server
Sql Server-2005
Profiling
SQL query to find Missing sequence numbers
Sql Server-2005
Gaps and-Islands
IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT
Sql
Sql Server
Sql Server-2005
Tsql
Convert SQL Server result set into string
Sql
Sql Server
Sql Server-2005
Tsql
"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP
Php
Sql Server
Sql Server-2005
Freetds
Unixodbc
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
Sql
Sql Server
Sql Server-2005
Tsql
Determine what user created objects in SQL Server
Sql
Sql Server-2005
Tsql
Unable to create index because of duplicate that doesn't exist?
Sql Server-2005
Tsql
Indexing
Unique Index
What is difference between datetime and timestamp
Sql Server-2005
SQL providerName in web.config
asp.net
Sql Server-2005
Connection String
SQL Server GUID sort algorithm. Why?
Sql Server
Sql Server-2005
Sql Server-2008
Sorting
How can I force a query to not use a index on a given table?
Sql
Sql Server-2005
Indexing
SQL Server compare results of two queries that should be identical
Sql Server
Sql Server-2005
SQL Server 2005 - Export table programmatically (run a .sql file to rebuild it)
Sql
Sql Server
Sql Server-2005
Database Table
How can I determine the status of a job?
Sql
Sql Server-2005
Tsql
Stored Procedures
Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"
Sql
Sql Server
Sql Server-2005
Optimization
Sql Execution-Plan
CASE IN statement with multiple values
Sql
Sql Server
Sql Server-2005
The tail of the log for the database "DBName" has not been backed up
C#
Sql
Sql Server-2005
Sharepoint
Database Deployment Strategies (SQL Server)
C#
asp.net
Sql Server-2005
Svn
Visual 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 Server
Sql Server-2005
How to return multiple values in one column (T-SQL)?
Sql
Sql Server
Sql Server-2005
Tsql
Can I save an 'Object' in a SQL Server database?
C#
Sql Server
Sql Server-2005
ado.net
Fastest way to update 120 Million records
Sql
Sql Server
Sql Server-2005
Extreme wait-time when taking a SQL Server database offline
Database
Sql Server-2005
Performance
How to get calendar Quarter from a date in TSQL
Sql
Sql Server
Tsql
Sql Server-2005
SQL Server 2005: T-SQL to temporarily disable a trigger
Sql Server
Sql Server-2005
Tsql
SQL Server error on update command - "A severe error occurred on the current command"
Sql Server
Sql Server-2005
Tsql
Why can't I put a constraint on nvarchar(max)?
Sql Server
Sql Server-2005
How to insert a blob into a database using sql server management studio
Sql
Sql Server
Sql Server-2005
Blob
SQL Query to find the last day of the month
Sql Server
Sql Server-2005
Date
Datetime
INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server
Sql
Sql Server
Sql Server-2005
Foreign Keys
Create a date from day month and year with T-SQL
Sql
Sql Server
Sql Server-2005
Tsql
SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
Sql
Sql Server
Database
Sql Server-2005
Custom Data-Type
How do I drop a foreign key constraint only if it exists in sql server?
Sql
Sql Server
Sql Server-2005
Tsql
Check if a string contains a substring in SQL Server 2005, using a stored procedure
Sql Server
String
Tsql
Stored Procedures
Sql Server-2005
How do I use an INSERT statement's OUTPUT clause to get the identity value?
Sql
Sql Server-2005
Insert
"Prevent saving changes that require the table to be re-created" negative effects
Sql Server
Sql Server-2008
Database Design
Sql Server-2005
What is the maximum characters for the NVARCHAR(MAX)?
Sql Server
Sql Server-2008
Sql Server-2005
How can I solve a connection pool problem between ASP.NET and SQL Server?
.Net
asp.net
Sql Server
Sql 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
Sql
Sql Server
Sql Server-2005
Greatest N-per-Group
SQL Server query to find all permissions/access for all users in a database
Sql Server
Sql Server-2005
Sql Server-2008
What are the main performance differences between varchar and nvarchar SQL Server data types?
Sql Server
Sql Server-2005
Storage
Varchar
Nvarchar
sql query to return differences between two tables
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Use variable with TOP in select statement in SQL Server without making it dynamic
Sql
Sql Server
Sql Server-2005
Tsql
Convert Month Number to Month Name Function in SQL
Sql
Sql Server
Tsql
Sql Server-2005
Turn off constraints temporarily (MS SQL)
Sql
Sql Server
Sql Server-2005
Constraints
Entity Relationship
How can a LEFT OUTER JOIN return more records than exist in the left table?
Sql
Sql Server
Sql Server-2005
Tsql
How to update two tables in one statement in SQL Server 2005?
Sql
Sql Server
Sql Server-2005
Tsql
Extracting hours from a DateTime (SQL Server 2005)
Sql
Tsql
Datetime
Sql Server-2005
Hour
The multi-part identifier could not be bound
Sql
Sql Server
Sql Server-2005
How to get Time from DateTime format in SQL?
Sql Server
Tsql
Sql Server-2005
Datetime
SQL Server - transactions roll back on error?
Sql
Sql Server
Sql Server-2005
Transactions
Referring to a Column Alias in a WHERE Clause
Sql
Sql Server
Tsql
Sql Server-2005
Best way to do nested case statement logic in SQL Server
Sql
Sql Server
Sql Server-2005
Select
Nested
Convert a string to int using sql query
Sql
Sql Server-2005
Difference between a User and a Login in SQL Server
Sql
Sql Server
Sql Server-2005
Sql Server string to date conversion
Sql Server
Tsql
Datetime
Sql Server-2005
String to-Datetime
How important is the order of columns in indexes?
Sql
Sql Server
Sql Server-2005
Tsql
Indexing
SQL Server String or binary data would be truncated
Sql Server
Tsql
Sql Server-2005
Migration
Data Migration
SQL Server Restore Error - Access is Denied
Sql Server
Sql Server-2005
Backup
Restore
nvarchar(max) vs NText
Sql Server
Sql Server-2005
Sql Server-2008
Text
Nvarchar
How to check which locks are held on a table
Sql
Sql Server
Database
Performance
Sql Server-2005
Add a column with a default value to an existing table in SQL Server
Sql
Sql Server
Sql Server-2005
Sql Server-2000
How do I check if a SQL Server text column is empty?
Sql Server
Sql Server-2005
Sqldatatypes
Notnull
Emptydatatext
What good are SQL Server schemas?
Sql Server-2005
Schema
Theory
Difference between database and schema
Sql Server
Database
Sql Server-2005
Database Schema
Measure the time it takes to execute a t-sql query
Performance
Sql Server-2005
What is the difference between a stored procedure and a view?
Sql
Sql Server-2005
Stored Procedures
Views
Better techniques for trimming leading zeros in SQL Server?
Sql
Sql Server
Sql Server-2005
Tsql
String
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 Server
Sql Server-2005
Ssms
Default Database
Sql Server equivalent of a COUNTIF aggregate function
Sql
Sql Server-2005
How to find current transaction level?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Isolation Level
How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?
Sql Server
Sql Server-2005
Database Connectivity
SQL update query using joins
Sql
Sql Server
Tsql
Sql Server-2005
Sql Update
When restoring a backup, how do I disconnect all active connections?
Sql Server
Sql Server-2005
Backup
Restore
Disconnect
How to identify all stored procedures referring a particular table
Sql
Tsql
Sql Server-2005
Check if a temporary table exists and delete if it exists before creating a temporary table
Sql Server
Sql Server-2005
Temp Tables
Alter Table
How to change identity column values programmatically?
Sql Server
Sql Server-2005
Tsql
Identity
Sql Server-2005-Express
SQL query to group by day
Sql
Sql Server
Sql Server-2005
Group By
Alter table add multiple columns ms sql
Sql Server-2005
Enable SQL Server Broker taking too long
Sql Server-2005
Service Broker
Get top 1 row of each group
Sql
Sql Server
Tsql
Sql Server-2005
Greatest N-per-Group
SQL Server, convert a named instance to default instance?
Sql Server
Sql Server-2005
Named Instance
How do you copy a record in a SQL table but swap out the unique id of the new row?
Sql
Sql Server
Sql Server-2005
Tsql
What does collation mean?
Sql
Sql Server-2005
Tsql
Mysql
SQL statement to select all rows from previous day
Sql
Sql Server
Sql Server-2005
Real life example, when to use OUTER / CROSS APPLY in SQL
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Insert all values of a table into another table in SQL
Sql
Sql Server
Sql Server-2005
T-SQL: Opposite to string concatenation - how to split string into multiple records
Sql Server
Sql Server-2005
Tsql
How to detect if a stored procedure already exists
Sql
Sql Server-2005
Stored Procedures
Base64 encoding in SQL Server 2005 T-SQL
Sql Server-2005
Tsql
Encoding
Base64
Can I create a One-Time-Use Function in a Script or Stored Procedure?
Sql
Sql Server
Sql Server-2005
Tsql
Scripting
Entity Framework and SQL Server View
Entity Framework
Sql Server-2005
.Net 3.5
Primary Key
Sql View
Difference between FOR and AFTER triggers?
Sql
Sql Server-2005
Triggers
Login failed for user 'DOMAIN\MACHINENAME$'
.Net
Sql Server
Sql Server-2005
Web Applications
Iis 6
How to strip HTML tags from a string in SQL Server?
Html
Sql
Sql Server
String
Sql Server-2005
Getting result of dynamic SQL into a variable for sql-server
Sql
Sql Server
Sql Server-2005
Tsql
Dynamic Sql
Parse usable Street Address, City, State, Zip from a string
String
Parsing
Sql Server-2005
Street Address
How can I get the actual stored procedure line number from an error message?
Sql
Sql Server-2005
how to increment integer Columns value by 1 in SQL
Sql
Sql Server-2005
Sql Update
SQL Server IN vs. EXISTS Performance
Sql Server
Sql Server-2005
Exists
Query Performance
Sql In
How much size "Null" value takes in SQL Server
Sql Server
Tsql
Sql Server-2005
Null
How to change column order in a table using sql query in sql server 2005?
Sql
Sql Server-2005
WITH (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Sql
Sql Server
Sql Server-2005
How to change a table name using an SQL query?
Sql
Sql Server
Sql Server-2005
Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
Sql Server
Tsql
Sql Server-2005
Insert
How to print VARCHAR(MAX) using Print Statement?
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Querying data by joining two tables in two database on different servers
Sql
Sql Server
Database
Sql Server-2005
Sql Server-2008
How do I query if a database schema exists
Sql Server-2005
Schema
Datatype for storing ip address in SQL Server
Sql Server
Tsql
Sql Server-2005
Types
Ip Address
Convert varchar to uniqueidentifier in SQL Server
Sql
Sql Server-2005
Uniqueidentifier
SQL Server - where is "sys.functions"?
Sql
Sql Server
Sql Server-2005
Stored Functions
Execution sequence of Group By, Having and Where clause in SQL Server?
Sql
Sql Server
Sql Server-2005
varbinary to string on SQL Server
Sql
Sql Server
Sql Server-2005
Tsql
Using SQL Server 2008 and SQL Server 2005 and date time
Sql Server-2005
Entity Framework
Sql Server-2008
Datetime
Datetime2
Is the LIKE operator case-sensitive with SQL Server?
Sql
Sql Server-2005
Varchar
Sql Like
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
Sql Server
Sql Server-2005
Tsql
Truncate
Foreign Keys
Get the week start date and week end date from week number
Sql
Sql Server
Date
Sql Server-2005
Week Number
Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
Sql
Sql Server-2005
Selecting COUNT(*) with DISTINCT
Sql
Sql Server
Sql Server-2005
Tsql
What is "Audit Logout" in SQL Server Profiler?
C#
Linq
Sql Server-2005
Linq to-Sql
Sql Server-Profiler
conditional unique constraint
Sql
Sql Server
Sql Server-2005
How to insert table values from one database to another database?
Sql
Sql Server-2005
Integration
Append
Unable to begin a distributed transaction
Sql Server
Sql Server-2005
Msdtc
Distributed Transactions
What's the best way to select the minimum value from several columns?
Sql
Sql Server
Tsql
Sql Server-2005
Min
SQL Server table creation date query
Sql
Sql Server
Tsql
Sql Server-2005
Use a LIKE statement on SQL Server XML Datatype
Sql
Sql Server
Xml
Sql Server-2005
How do I fetch multiple columns for use in a cursor loop?
Tsql
Sql Server-2005
How to query for Xml values and attributes from table in SQL Server?
Sql Server
Xml
Sql Server-2005
Sql Server-2008-R2
Sqlxml
How to determine total number of open/active connections in ms sql server 2005
Sql Server
Database
Sql Server-2005
Connection
What is the point of "Initial Catalog" in a SQL Server connection string?
Sql Server
Database
Sql Server-2005
Connection String
Database Connection
WHERE clause on SQL Server "Text" data type
Sql Server
Sql Server-2005
Tsql
Declare Variable for a Query String
Sql
Sql Server
Sql Server-2005
Tsql
Dynamic Sql
How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
Sql Server
Sql Server-2005
Why use the INCLUDE clause when creating an index?
Sql Server
Sql Server-2008
Sql Server-2005
Indexing
Find stored procedure by name
Sql
Database
Sql Server-2005
Ssms
Received an invalid column length from the bcp client for colid 6
C#
.Net
Sql Server
Database
Sql Server-2005
MultipleActiveResultSets=True or multiple connections?
C#
.Net
Sql Server
Sql Server-2005
ado.net
Disadvantages of MARS (Multiple Active Result Sets)?
Sql Server-2005
Sql Server-Mars
Is it necessary to use # for creating temp tables in SQL server?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
SQL Server ORDER BY date and nulls last
Sql Server
Sql Server-2005
Tsql
Simple DateTime sql query
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Rounding SQL DateTime to midnight
Sql
Sql Server
Sql Server-2005
Getdate
How do you specify a different port number in SQL Management Studio?
Sql Server
Sql Server-2005
Ssms
How to export data from SQL Server 2005 to MySQL
Mysql
Sql Server
Csv
Sql Server-2005
Bcp
How to parse string into date?
Tsql
Sql Server-2005
SQL Server 2005 implementation of MySQL REPLACE INTO?
Mysql
Sql Server
Sql Server-2005
Watching variables in SSIS during debug
Sql
Sql Server-2005
Debugging
Ssis
Watch
SELECT FOR UPDATE with SQL Server
Sql
Sql Server
Sql Server-2005
Tsql
Read Committed-Snapshot
Export table data from one SQL Server to another
Sql
Sql Server
Sql Server-2005
Export
Does T-SQL have an aggregate function to concatenate strings?
Sql Server
Sql Server-2005
Tsql
Group By
Aggregate Functions
SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
.Net
Sql
Sql Server-2005
Transactions
Identity Column
Select info from table where row has max date
Sql
Sql Server-2005
Greatest N-per-Group
How to avoid the "divide by zero" error in SQL?
Sql
Sql Server
Sql Server-2005
Sql Server-2008
Diagnosing Deadlocks in SQL Server 2005
Sql Server
Sql Server-2005
Deadlock
How do I check if a nonclustered index exists in SQL Server 2005
Sql Server-2005
Non Clustered-Index
Alter a SQL server function to accept new optional parameter
Sql
Sql Server-2005
Index Key Column VS Index Included Column
Sql Server-2005
Tsql
How do I view the SSIS packages in SQL Server Management Studio?
Sql Server-2005
Ssis
Ssms
Can I add a not null column without DEFAULT value
Sql
Sql Server
Sql Server-2005
Tsql
How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
Sql Server-2005
Tsql
Collation
Search for a string in all tables, rows and columns of a DB
Sql
Sql Server-2005
How do I find the data directory for a SQL Server instance?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Sql Server-2008-R2
SQL Server Invalid Column name after adding new column
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2005
How to find sum of multiple columns in a table in SQL Server 2005?
Sql
Sql Server
Sql Server-2005
What is the best way to create and populate a numbers table?
Sql Server
Sql Server-2005
How can I convert ticks to a date format?
C#
asp.net
Sql Server
Sql Server-2005
Insert results of a stored procedure into a temporary table
Sql
Sql Server
Sql Server-2005
Tsql
Stored Procedures
How to SELECT FROM stored procedure
Sql
Sql Server
Sql Server-2005
Stored Procedures
Insert multiple values using INSERT INTO (SQL Server 2005)
Sql
Sql Server
Sql Server-2005
Tsql
List rows after specific date
Sql
Sql Server
Sql Server-2008
Sql 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-2005
Unique Constraint
T-SQL Substring - Last 3 Characters
Sql
Sql Server
Sql Server-2005
Tsql
Passing an array of parameters to a stored procedure
Sql
Sql Server-2005
Stored Procedures
Insert Picture into SQL Server 2005 Image Field using only SQL
Sql
Sql Server
Sql Server-2005
Image
how to insert datetime into the SQL Database table?
.Net
Sql
Sql Server
Sql Server-2005
C# 3.0
How to compare two dates to find time difference in SQL Server 2005, date manipulation
Sql
Sql Server-2005
Date
Datediff
SQL query to select dates between two dates
Sql
Sql Server
Tsql
Datetime
Sql Server-2005
Datetime in where clause
Sql
Sql Server
Datetime
Sql Server-2005
Filter
Find non-ASCII characters in varchar columns using SQL Server
Sql Server
Tsql
Sql Server-2005
Non Ascii-Characters
Most recent record in a left join
Sql
Sql Server
Sql Server-2005
Are there any disadvantages to always using nvarchar(MAX)?
Sql
Sql Server
Sql Server-2005
How to rollback or commit a transaction in SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Advantages of SQL Server 2008 over SQL Server 2005?
Sql Server-2005
Sql Server-2008
Comparison
How can I do an UPDATE statement with JOIN in SQL Server?
Sql
Sql Server
Tsql
Sql Server-2005
Sql Update
What represents a double in sql server?
C#
Sql
Sql Server
Sql Server-2005
Tsql
Compare dates in T-SQL, ignoring the time part
Sql
Sql Server
Sql Server-2005
Tsql
Can an INNER JOIN offer better performance than EXISTS
Sql
Sql Server
Sql Server-2005
Performance
Tsql
EXISTS vs JOIN and use of EXISTS clause
Sql
Sql Server
Sql Server-2005
Sql Server-2008
How do you drop a default value from a column in a table?
Sql Server-2005
Tsql
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Sql
Sql Server
Sql Server-2005
String Aggregation
Size of VARBINARY field in SQL Server 2005
Sql
Sql Server
Sql Server-2005
Clr
How do I change the owner of a SQL Server database?
Sql Server
Sql Server-2005
Permissions
Truncate Table Within Transaction
Sql
Sql Server
Sql Server-2005
Transactions
Truncate
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
Sql
Sql Server
Sql Server-2005
Decimal values in SQL for dividing results
Sql Server
Sql Server-2005
How to upsert (update or insert) in SQL Server 2005
Sql Server-2005
Is a Primary Key necessary in SQL Server?
Sql
Sql Server
Sql Server-2005
SQL Server: how to write an alter index statement to add a column to the unique index?
Sql Server-2005
Indexing
Alter
Parameter Sniffing (or Spoofing) in SQL Server
Sql Server
Tsql
Sql Server-2005
Parameter Spoofing
Dynamic SELECT TOP @var In SQL Server
Sql
Sql Server-2005
How to export SQL Server 2005 query to CSV
Sql Server
Sql Server-2005
Bcp
Sqlcmd
Why is it considered bad practice to use cursors in SQL Server?
Sql Server
Sql Server-2005
Database Cursor
How to store directory / hierarchy / tree structure in the database?
Sql Server
Sql Server-2005
Database Design
Tree Structure
Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type
Sql Server-2005
Unicode
Ssis
Types
Non Unicode
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous
Sql Server
Sql Server-2005
Tsql
User Defined-Functions
How do parameterized queries help against SQL injection?
C#
.Net
Sql
Sql Server-2005
Parameterized Query
How to insert multiple records and get the identity value?
Sql
Sql Server
Sql Server-2005
Column name or number of supplied values does not match table definition
Sql
Sql Server
Sql Server-2005
Tsql
Can there be constraints with the same name in a DB?
Sql
Sql Server
Sql Server-2005
Tsql
Constraints
Convert Xml to Table SQL Server
Sql
Xml
Sql Server-2008
Tsql
Sql Server-2005
How get the T-SQL code to find duplicates?
Sql Server-2005
Tsql
Ssms
UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
Sql Server-2005
Generate a resultset of incrementing dates in TSQL
Sql
Sql Server
Database
Sql Server-2005
Tsql
When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
C#
.Net
asp.net
Sql Server-2005
ado.net
Add a row number to result set of a SQL query
Sql
Sql Server
Sql Server-2005
How to get SQL Profiler to monitor trigger execution
Sql Server
Sql Server-2005
Sql Server-Profiler
How to get difference between two rows for a column field?
Sql
Sql Server
Tsql
Sql Server-2005
How can I create a SQL unique constraint based on 2 columns?
Sql Server
Sql Server-2005
Sql Server-2008
Constraints
Unique Constraint
Increment Row Number on Group
Sql
Sql Server
Sql Server-2005
SQL Server 2005 drop column with constraints
Sql Server
Sql Server-2005
SQL GROUP BY CASE statement with aggregate function
Sql
Sql Server
Sql Server-2005
Group By
How to get number of rows inserted by a transaction
Sql Server
Sql Server-2005
How to get first character of a string in SQL?
Sql
Sql Server
Sql Server-2005
Execute Stored Procedure from a Function
Sql
Sql Server
Sql Server-2005
Stored Procedures
User Defined-Functions
Convert SSMS .rpt output file to .txt/.csv
Sql Server
Sql Server-2005
Character Encoding
Ssms
Rpt
How do I avoid character encoding when using "FOR XML PATH"?
Xml
Sql Server-2005
Encoding
For Xml-Path
Create a one to many relationship using SQL Server
Sql
Sql Server
Sql Server-2005
Is it possible to force row level locking in SQL Server?
Sql Server
Sql Server-2005
Sql Server-2008
Rowlocking
Foreign key relationship with composite primary keys in SQL Server 2005
Sql Server-2005
Foreign Key-Relationship
Composite Primary-Key
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
C#
Sql
Sql Server
Sql Server-2005
Rename SQL Server Schema
Sql
Sql Server
Sql Server-2005
Schema
Delete duplicate records from a SQL table without a primary key
Sql
Sql Server-2005
Tsql
Duplicate Removal
adding a column description
Sql
Sql Server
Sql Server-2005
How to use alias column name in where clause in SQL Server
Sql Server-2005