Gang Of Coders
Home
About Us
Contact Us
All Sql Server-2008 Solutions on Gang of Coders
Total of 383 Sql Server-2008 Solutions
How to check if a column exists in a SQL Server table
Sql Server
Sql Server-2008
Tsql
Sql Server-2012
Sql Server-2016
How can I delete using INNER JOIN with SQL Server?
Sql
Sql Server
Sql Server-2008
Inner Join
Sql Delete
How can I get column names from a table in SQL Server?
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation
Sql Server-2008
Save
Ssms
Menuitem
Reset identity seed after deleting records in SQL Server
Sql
Sql Server
Database
Sql Server-2008
Azure Sql-Database
Rename column SQL Server 2008
Sql
Sql Server
Sql Server-2008
Alter Table
How to turn IDENTITY_INSERT on and off using SQL Server 2008?
Sql
Sql Server-2008
UPDATE and REPLACE part of a string
Sql
Sql Server
String
Sql Server-2008
Replace
How to delete duplicate rows in SQL Server?
Sql
Sql Server-2008
Duplicates
Sql Delete
Why use the INCLUDE clause when creating an index?
Sql Server
Sql Server-2008
Sql Server-2005
Indexing
Efficiently convert rows to columns in sql server
Sql
Sql Server
Sql Server-2008
Pivot
How to set a default value for an existing column
Sql Server
Sql Server-2008
Tsql
Default Value
How to avoid the "divide by zero" error in SQL?
Sql
Sql Server
Sql Server-2005
Sql Server-2008
Select statement to find duplicates on certain fields
Sql
Sql Server
Tsql
Sql Server-2008
SQL Server - Return value after INSERT
Sql
Sql Server
Sql Server-2008
How can I select the first day of a month in SQL?
Sql
Sql Server
Tsql
Sql Server-2008
Datetime
How do I find a stored procedure containing <text>?
Sql Server
Sql Server-2008
Tsql
Stored Procedures
Connect different Windows User in SQL Server Management Studio (2005 or later)
Sql
Sql Server-2008
How do I see active SQL Server connections?
Sql
Sql Server
Sql Server-2008
SQL Server Insert if not exists
Sql
Sql Server
Sql Server-2008
Stored Procedures
SET versus SELECT when assigning variables?
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Entity Framework: There is already an open DataReader associated with this Command
Linq
Entity Framework
Sql Server-2008
How can I truncate a datetime in SQL Server?
Sql Server
Sql Server-2008
Datetime
Truncate
SQL Server SELECT INTO @variable?
Sql
Sql Server
Tsql
Sql Server-2008
SQL Server add auto increment primary key to existing table
Sql Server
Sql Server-2008
Primary Key
Alter Table
How do I move a table into a schema in T-SQL
Sql Server
Sql Server-2008
Tsql
Schema
Sql Server-2016
Can I use multiple "with"?
Sql
Tsql
Sql Server-2008
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
Sql
Sql Server
Tsql
Sql Server-2008
Sql Server-2008-R2
SQL Server principal "dbo" does not exist,
Sql Server-2008
Unique constraint on multiple columns
Sql Server
Sql Server-2008
Ssms
How can I group by date time column without taking time into consideration
Sql
Sql Server
Tsql
Sql Server-2008
"Prevent saving changes that require the table to be re-created" negative effects
Sql Server
Sql Server-2008
Database Design
Sql Server-2005
Check if a row exists, otherwise insert
Sql
Sql Server
Sql Server-2008
Tsql
What is the maximum characters for the NVARCHAR(MAX)?
Sql Server
Sql Server-2008
Sql Server-2005
How to update Identity Column in SQL Server?
Sql
Sql Server
Tsql
Sql Server-2008
SQL Server Configuration Manager not found
Sql Server
Sql Server-2008
Sql Server-2012
Sql Server-Config-Manager
How to write UPDATE SQL with Table alias in SQL Server 2008?
Sql
Sql Server
Sql Server-2008
Sql Update
Alias
SQL Server. How to refresh the intellisense?
Sql Server
Sql Server-2008
Ssms
SQL Server Management Studio, how to get execution time down to milliseconds
Sql Server
Ssms
Sql Server-2008
How to drop all tables in a SQL Server database?
Sql Server
Sql Server-2008
Ssms
Sp Msforeachtable
SQL Server query to find all permissions/access for all users in a database
Sql Server
Sql Server-2005
Sql Server-2008
How to restore to a different database in SQL Server?
Sql Server-2008
Backup
Restore
How to create a table from select query result in SQL Server 2008
Sql
Sql Server
Sql Server-2008
Add primary key to existing table
Sql
Sql Server
Sql Server-2008
Constraints
Primary Key
sql query to return differences between two tables
Sql
Sql Server
Sql Server-2008
Sql Server-2005
How do you view ALL text from an ntext or nvarchar(max) in SSMS?
Sql Server
Sql Server-2008
Tsql
Ssms
How to get a float result by dividing two integer values using T-SQL?
Sql Server
Sql Server-2008
Division
Rounding
How to connect to local instance of SQL Server 2008 Express
Sql Server-2008
Ssms
Changing the maximum length of a varchar column?
Sql
Sql Server
Sql Server-2008
Tsql
Varchar
How to wait for 2 seconds?
Sql Server
Sql Server-2008
Tsql
How to get cumulative sum
Sql Server
Sql Server-2008
Modify table: How to change 'Allow Nulls' attribute from not null to allow null
Sql
Sql Server
Sql Server-2008
How to change column datatype in SQL Server database without losing data?
Sql Server
Sql Server-2008
Alter
How do I do multiple CASE WHEN conditions using SQL Server 2008?
Sql
Sql Server-2008
is of a type that is invalid for use as a key column in an index
Sql
Sql Server-2008
How to check date of last change in stored procedure or function in SQL server
Sql Server-2008
Stored Procedures
Sql Server-2008-R2
Sql Function
How to alter SQL in "Edit Top 200 Rows" in SSMS 2008
Sql Server
Ssms
Sql Server-2008
How to group time by hour or by 10 minutes
Sql
Sql Server-2008
Tsql
Group By
Multi-statement Table Valued Function vs Inline Table Valued Function
Sql
Sql Server
Sql Server-2008
Tsql
User Defined-Functions
OPTION (RECOMPILE) is Always Faster; Why?
Sql
Sql Server
Sql Server-2008
Compilation
Query Hints
Saving results with headers in SQL Server Management Studio
Sql
Sql Server-2008
Excel
Ssms
Export to-Excel
Alter column, add default constraint
Sql Server
Sql Server-2008
Tsql
Alter Table
Alter Column
nvarchar(max) vs NText
Sql Server
Sql Server-2005
Sql Server-2008
Text
Nvarchar
How to create composite primary key in SQL Server 2008
Sql
Sql Server-2008
How to Select Every Row Where Column Value is NOT Distinct
Sql
Sql Server
Sql Server-2008
Copy data into another table
Sql
Sql Server
Sql Server-2008
How to check existence of user-define table type in SQL Server 2008?
Sql
Sql Server
Sql Server-2008
Tsql
User Defined-Types
How to find server name of SQL Server Management Studio
Visual Studio-2010
Sql Server-2008
Ssms
Select SQL Server database size
Sql
Sql Server
Sql Server-2008
Sql Server-2008-R2
How to select the last record of a table in SQL?
Sql
Sql Server
Sql Server-2008
Format of the initialization string does not conform to specification starting at index 0
C#
asp.net
Sql Server-2008
CROSS JOIN vs INNER JOIN in SQL
Sql
Sql Server
Sql Server-2008
Tsql
Cross Join
Enable 'xp_cmdshell' SQL Server
Sql Server-2008
A transport-level error has occurred when receiving results from the server
Sql Server-2008
Why is SQL Server 2008 Management Studio Intellisense not working?
Sql Server-2008
Intellisense
SQL Server SELECT LAST N Rows
Sql
Sql Server
Performance
Sql Server-2008
How to generate a range of numbers between two numbers?
Sql
Sql Server
Tsql
Sql Server-2008
How to find current transaction level?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
Isolation Level
Read data from SqlDataReader
C#
asp.net
Sql Server-2008
Sqldatareader
How to drop column with constraint?
Sql Server
Sql Server-2008
GRANT EXECUTE to all stored procedures
Sql
Sql Server
Tsql
Sql Server-2008
Permissions
Remove Trailing Spaces and Update in Columns in SQL Server
Sql
Sql Server-2008
Trailing
How can I find out what FOREIGN KEY constraint references a table in SQL Server?
Sql
Sql Server
Sql Server-2008
T-SQL split string
Sql
Sql Server
Tsql
Sql Server-2008
Split
SQL "between" not inclusive
Sql
Sql Server
Sql Server-2008
Tsql
Date
Compare DATETIME and DATE ignoring time portion
Sql
Sql Server
Tsql
Sql Server-2008
Datetime Conversion
SQL-Server: Error - Exclusive access could not be obtained because the database is in use
Sql
Sql Server
Sql Server-2008
Cannot open backup device. Operating System error 5
Sql Server-2008
Backup
Access Denied
Permission Denied
How to split a comma-separated value to columns
Sql Server
Sql Server-2008
Csv
Sql query to insert datetime in SQL Server
Sql
Sql Server-2008
Datetime
SQL Server equivalent to MySQL enum data type?
Sql
Sql Server
Tsql
Sql Server-2008
Types
How to report an error from a SQL Server user-defined function
Sql
Sql Server
Tsql
Sql Server-2008
User Defined-Functions
Export query result to .csv file in SQL Server 2008
Sql Server-2008
SQL SERVER: Get total days between two dates
Sql
Sql Server
Sql Server-2008
Date
Which are more performant, CTE or temporary tables?
Sql Server
Performance
Sql Server-2008
Temp Tables
Common Table-Expression
optional parameters in SQL Server stored proc?
Sql Server-2008
Stored Procedures
Optional Parameters
How do I create a SQL table under a different schema?
Sql
Sql Server-2008
Ssms
How to delete large data of table in SQL without log?
Sql Server
Sql Server-2008
Sql Optimization
A connection was successfully established with the server, but then an error occurred during the pre-login handshake
.Net
Sql Server
Sql Server-2008
ado.net
Database Connection
How to convert float to varchar in SQL Server
Sql Server-2008
How to check SQL Server version
Sql Server-2008
Version
How do I declare and assign a variable on a single line in SQL
Sql
Sql Server-2008
Variables
SQL Server Management Studio SSMS tries to "save to file" instead of execute on F5
Sql Server-2008
Ssms
Lock Escalation - What's happening here?
Sql
Sql Server
Sql Server-2008
How can I create a unique constraint on my column (SQL Server 2008 R2)?
Sql
Sql Server
Sql Server-2008
Unique Constraint
INSERT INTO vs SELECT INTO
Sql Server
Tsql
Sql Server-2008
How can I schedule a job to run a SQL query daily?
Sql
Sql Server
Database
Sql Server-2008
Sql Job
Real life example, when to use OUTER / CROSS APPLY in SQL
Sql
Sql Server
Sql Server-2008
Sql Server-2005
SQL Server - Create a copy of a database table and place it in the same database?
Sql
Sql Server-2008
Tsql
Sql Server-2008-R2
Unpivot with column name
Sql
Sql Server
Sql Server-2008
Tsql
Unpivot
Split function equivalent in T-SQL?
Sql
Sql Server
Tsql
Sql Server-2008
Database Diagram Support Objects cannot be Installed ... no valid owner
Sql Server
Sql Server-2008
Database Diagramming
Unable to login to SQL Server + SQL Server Authentication + Error: 18456
Sql Server
Sql Server-2008
Delete all the records
Tsql
Sql Server-2008
Sql Delete
Sql Truncate
ALTER DATABASE failed because a lock could not be placed on database
Sql
Sql Server-2008
Ssms
Do while loop in SQL Server 2008
Sql Server
Sql Server-2008
Loops
While Loop
Do While
SQL Joins Vs SQL Subqueries (Performance)?
Sql
Performance
Sql Server-2008
Subquery
Join
Converting Select results into Insert script - SQL Server
Sql
Sql Server
Sql Server-2008
Ssms
SQL Server: Maximum character length of object names
Sql Server
Sql Server-2008
Tsql
Is the NOLOCK (Sql Server hint) bad practice?
Sql
Sql Server
Tsql
Sql Server-2008
Nolock
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server
Sql Server-2008
Excel
Oledb
How to print VARCHAR(MAX) using Print Statement?
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Multiple INSERT statements vs. single INSERT with multiple VALUES
Sql
Sql Server
Performance
Sql Server-2008
Tsql
SQL Server Management Studio won't let me add an index to a table
Sql Server
Sql Server-2008
Sql Server-2012
Ssms
Sql Server-2014
T-SQL datetime rounded to nearest minute and nearest hours with using functions
Sql
Sql Server
Tsql
Sql Server-2008
Is there a way to access the "previous row" value in a SELECT statement?
Sql
Sql Server
Sql Server-2008
How do I change db schema to dbo
Sql
Sql Server
Database
Sql Server-2008
Schema
Querying data by joining two tables in two database on different servers
Sql
Sql Server
Database
Sql Server-2005
Sql Server-2008
The transaction log for the database is full
Sql
Sql Server
Sql Server-2008
Dynamics Crm
Is having an 'OR' in an INNER JOIN condition a bad idea?
Sql
Sql Server
Sql Server-2008
Tsql
Inner Join
GROUP BY to combine/concat a column
Sql
Sql Server
Sql Server-2008
Group By
SQL Add foreign key to existing column
Sql Server-2008
Foreign Key-Relationship
Generate random int value from 3 to 6
Sql
Sql Server
Sql Server-2008
Using SQL Server 2008 and SQL Server 2005 and date time
Sql Server-2005
Entity Framework
Sql Server-2008
Datetime
Datetime2
Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
Sql Server
Sql Server-2008
Code Reuse
How to take last four characters from a varchar?
Sql
Sql Server-2008
Tsql
Which SQL query is faster? Filter on Join criteria or Where clause?
Sql
Sql Server
Tsql
Sql Server-2008
Generate MD5 hash string with T-SQL
Sql Server
Tsql
Sql Server-2008
How do I find duplicates across multiple columns?
Sql
Sql Server
Sql Server-2008
Duplicates
How to kill/stop a long SQL query immediately?
Sql
Sql Server
Sql Server-2008
Backup a single table with its data from a database in sql server 2008
Sql
Sql Server
Sql Server-2008
How to enable Ad Hoc Distributed Queries
Sql
Sql Server-2008
How to add Active Directory user group as login in SQL Server
Sql Server
Sql Server-2008
Security
Authentication
How to force a SQL Server 2008 database to go Offline
Sql
Sql Server
Tsql
Sql Server-2008
Add a column to a table with a default value equal to the value of an existing column
Sql
Sql Server-2008
I cannot start SQL Server browser
Sql Server
Sql Server-2008
64 Bit
SQL Server 2008: how do I grant privileges to a username?
Sql
Sql Server
Sql Server-2008
Ssms
Arithmetic overflow error converting numeric to data type numeric
Sql
Sql Server-2008
How to print GETDATE() in SQL Server with milliseconds in time?
Sql
Sql Server
Sql Server-2008
Datetime
Getdate
Is there StartsWith or Contains in t sql with variables?
Sql
Sql Server-2008
Tsql
COALESCE Function in TSQL
Sql
Sql Server
Sql Server-2008
Tsql
How to find the port for MS SQL Server 2008?
Sql Server
Sql Server-2008
Replace Default Null Values Returned From Left Outer Join
Mysql
Sql
Sql Server
Tsql
Sql Server-2008
How to edit one specific row in Microsoft SQL Server Management Studio 2008?
Sql Server-2008
Ssms
Restrict varchar() column to specific values?
Sql
Sql Server-2008
Ssms
How do I use the CONCAT function in SQL Server 2008 R2?
Sql Server
Sql Server-2008
Tsql
Current executing procedure name
Sql Server
Sql Server-2008
Tsql
Stored Procedures
How can I automate the "generate scripts" task in SQL Server Management Studio 2008?
Sql Server
Visual Studio-2008
Automation
Ssms
Sql Server-2008
Add column to SQL Server
Sql Server-2008
Stored procedure slow when called from web, fast from Management Studio
asp.net
Sql Server-2008
Stored Procedures
Using RegEx in SQL Server
Sql Server
Regex
Sql Server-2008
Tsql
WHERE Clause to find all records in a specific month
Sql
Sql Server-2008
A dependent property in a ReferentialConstraint is mapped to a store-generated column
C#
Sql Server-2008
Linq to-Sql
Entity Framework-4
Why use the SQL Server 2008 geography data type?
Sql Server-2008
Geolocation
Geocoding
How to find SQL Server running port?
Sql Server
Sql Server-2008
Connection String
How to find third or nᵗʰ maximum salary from salary table?
Sql
Sql Server
Sql Server-2008
What's the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
Sql Server
Sql Server-2008
Latitude Longitude
Spatial
Storing DateTime (UTC) vs. storing DateTimeOffset
Sql
Sql Server
Tsql
Sql Server-2008
Datetimeoffset
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
Sql
Sql Server
Tsql
Sql Server-2008
Full Text-Search
TSQL - How to use GO inside of a BEGIN .. END block?
Sql
Sql Server
Tsql
Sql Server-2008
Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)
Sql Server
Sql Server-2008
Sql Server-2012
How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
Sql Server
Sql Server-2008
Ssms
SQL NVARCHAR and VARCHAR Limits
Sql
Sql Server
Sql Server-2008
Variables
String Concatenation
SQL Server : GROUP BY clause to get comma-separated values
Sql
Sql Server-2008
Get first day of week in SQL Server
Sql Server
Tsql
Sql Server-2008
Date
How do I grant myself admin access to a local SQL Server instance?
Sql
Sql Server
Sql Server-2008
Ssms
Sqlcmd
SQL Server: Invalid Column Name
Sql
Sql Server
Sql Server-2008
Stored Procedures
Could not obtain information about Windows NT group/user
Sql Server
Sql Server-2008
Sharepoint
How can I have multiple common table expressions in a single SELECT statement?
Sql
Sql Server
Sql Server-2008
Tsql
Common Table-Expression
Remove trailing zeros from decimal in SQL Server
Sql
Tsql
Sql Server-2008
Formatting
Decimal
MS SQL compare dates?
Sql Server
Tsql
Sql Server-2008
Date
Listing information about all database files in SQL Server
Sql Server
Sql Server-2008
Tsql
Database Management
Confused about UPDLOCK, HOLDLOCK
Sql Server
Tsql
Sql Server-2008
Concurrency
Locking
The EXECUTE permission is denied on the user-defined table types?
asp.net
Security
Sql Server-2008
Stored Procedures
User Defined-Types
Clustered vs Non-Clustered
Sql
Performance
Sql Server-2008
Indexing
Script entire database SQL-Server
Sql
Sql Server
Sql Server-2008
Is there a way to persist a variable across a go?
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Sql Server-2000
How to catch SqlException caused by deadlock?
.Net
Sql Server-2008
Deadlock
Try Catch
Sqlexception
T-SQL and the WHERE LIKE %Parameter% clause
Sql
Sql Server-2008
Tsql
SQL Server - copy stored procedures from one db to another
Sql
Sql Server-2008
Copy
Procedures
SQL Server database restore error: specified cast is not valid. (SqlManagerUI)
Sql Server
Sql Server-2008
Database Restore
What does "select 1 from" do?
Sql Server-2008
Find all columns of a certain type in all tables in a SQL Server database
Sql
Sql Server-2008
FULL OUTER JOIN vs. FULL JOIN
Sql
Sql Server-2008
Tsql
Join
Is it necessary to use # for creating temp tables in SQL server?
Sql
Sql Server
Sql Server-2008
Sql Server-2005
TSQL: How to convert local time to UTC? (SQL Server 2008)
Sql Server
Tsql
Sql Server-2008
Timezone
Utc
Simple DateTime sql query
Sql
Sql Server
Sql Server-2005
Tsql
Sql Server-2008
Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
asp.net
Linq to-Sql
Sql Server-2008
How to get the size of a varchar[n] field in one SQL statement?
Sql
Sql Server-2008
Varchar
Understanding PIVOT function in T-SQL
Sql Server
Sql Server-2008
Tsql
Pivot
How to declare an array inside MS SQL Server Stored Procedure?
Sql Server-2008
Stored Procedures
Returning Month Name in SQL Server Query
Sql
Sql Server-2008
Type Conversion
Improve SQL Server query performance on large tables
Sql
Sql Server
Sql Server-2008
How to make a view column NOT NULL
Sql
Sql Server-2008
Nullable
Sql View
Do clustered indexes have to be unique?
Sql
Database
Tsql
Sql Server-2008
Clustered Index
Database design: Calculating the Account Balance
Sql Server
Database
Sql Server-2008
Database Design
When increasing the size of VARCHAR column on a large table could there be any problems?
Sql Server
Sql Server-2008
Varchar
Alter Column
Delete statement in SQL is very slow
Sql
Sql Server
Sql Server-2008
Database Optimization
Getting the current date in SQL Server?
Sql
Sql Server
Sql Server-2008
Datetime
Current Time
Perform insert for each row taken from a select?
Sql
Sql Server-2008
Tsql
Insert
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column
Sql Server
Sql Server-2008
Ssis
Etl
SQL Server 2008 Empty String vs. Space
Sql Server
Sql Server-2008
Tsql
String Length
Datalength
Can you explain the use of sys.sp_addextendedproperty in the following code?
Sql Server
Tsql
Sql Server-2008
Extended Properties
How to store images using Entity Framework Code First CTP 5?
.Net
Entity Framework
Sql Server-2008
Ef Code-First
Why not use varchar(max)?
Sql
Tsql
Sql Server-2008
Varcharmax
Transfer data from one database to another database
Sql
Sql Server
Sql Server-2008
Performance of bcp/BULK INSERT vs. Table-Valued Parameters
Performance
Sql Server-2008
Bulkinsert
Table Valued-Parameters
how to extract only the year from the date in sql server 2008?
Sql
Sql Server-2008
Datetime
Extract
varchar(max) everywhere?
Sql Server-2008
Varchar
Creating new database from a backup of another Database on the same server?
Sql
Database
Sql Server-2008
Disable Transaction Log
Sql Server
Sql Server-2008
Error - The transaction associated with the current connection has completed but has not been disposed
C#
.Net
Sql Server-2008
C# 4.0
exec failed because the name not a valid identifier?
Sql
Sql Server
Sql Server-2008
Select a Column in SQL not in Group By
Sql
Sql Server-2008
Tsql
Greatest N-per-Group
How do I return the SQL data types from my query?
Sql
Sql Server
Tsql
Sql Server-2008
How to create a function in SQL Server
Sql Server-2008
How to display two digits after decimal point in SQL Server
Sql Server
Sql Server-2008
Sqldatatypes
Comma separated results in SQL
Sql Server
Sql Server-2008
Tsql
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
Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column 'Id', table 'FileStore'; column does not allow nulls
C#
Entity Framework
Sql Server-2008
Entity Framework-6
How to install SQL Server Management Studio 2008 component only
Sql Server-2008
Visual Studio-2010
SQL Server: combining multiple rows into one row
Sql Server
Sql Server-2008
Tsql
List rows after specific date
Sql
Sql Server
Sql Server-2008
Sql Server-2005
SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE
Sql
Sql Server-2008
How to add hours to current date in SQL Server?
Sql Server-2008
Conditional WHERE clause in SQL Server
Sql
Sql Server
Sql Server-2008
Tsql
Where Clause
Can't see the triggers that I created in SQL Server Management Studio 2008
Sql Server
Sql Server-2008
Should I set max pool size in database connection string? What happens if I don't?
Sql
Sql Server-2008
Connection String
Connection Pooling
How eliminate the tab space in the column in SQL Server 2008
Sql Server-2008
SQL Server 2008- Get table constraints
Sql
Sql Server
Sql Server-2008
Constraints
Get 2 Digit Number For The Month
Sql
Sql Server
Sql Server-2008
Tsql
Get Table and Index storage size in sql server
Sql
Sql Server
Sql Server-2008
Indexing
How to use table variable in a dynamic sql statement?
Sql
Sql Server
Sql Server-2008
Dynamic Sql
Table Variable
TransactSQL to run another TransactSQL script
Sql
Sql Server
Tsql
Sql Server-2008
Understanding the differences between CUBE and ROLLUP
Sql
Sql Server
Sql Server-2008
Tsql
Use one CTE many times
Sql
Sql Server
Sql Server-2008
Common Table-Expression
How to retrieve field names from temporary table (SQL Server 2008)
Sql
Sql Server
Sql Server-2008
Temp Tables
How to execute Table valued function
Sql
Sql Server
Sql Server-2008
Tsql
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation
Sql Server-2008
SQL Query with NOT LIKE IN
Sql
Sql Server-2008
Tsql
Best way to copy a database (SQL Server 2008)
Sql Server
Sql Server-2008
Can I Comma Delimit Multiple Rows Into One Column?
Sql
Sql Server
Sql Server-2008
Tsql
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)
Sql
Sql Server-2008
Sql Server-Express
How to Generate Scripts For All Triggers in Database Using Microsoft SQL Server Management Studio
Sql
Sql Server-2008
Triggers
SQL MERGE statement to update data
Sql Server-2008
Tsql
Query to check whether a column is nullable
Sql Server
Sql Server-2008
Nullable
Finding even or odd ID values
Sql
Sql Server-2008
How to subtract 30 days from the current date using SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
Sql
Sql Server
Database Design
Sql Server-2008
Query to check index on a table
Sql
Sql Server-2008
Indexing
Import and Export Wizard with Identity Column
Sql Server
Sql Server-2008
Sql Server-2008-R2
SQL Server: Cannot insert an explicit value into a timestamp column
Sql
Sql Server-2008
Insert
Timestamp
How to rollback or commit a transaction in SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2005
how to know status of currently running jobs
Sql Server
Sql Server-2008
Tsql
Sql Agent
Advantages of SQL Server 2008 over SQL Server 2005?
Sql Server-2005
Sql Server-2008
Comparison
How can I alter this computed column in SQL Server 2008?
Sql
Sql Server-2008
Edit
Alter
Calculated Columns
How to re-seed a table identity in SQL Server 2008 and undo it all safely?
Sql Server-2008
Seed
How to add a new schema to sql server 2008?
Sql Server
Sql Server-2008
Where are SQL Server connection attempts logged?
Sql Server-2008
Logging
Database Connection
EXISTS vs JOIN and use of EXISTS clause
Sql
Sql Server
Sql Server-2005
Sql Server-2008
New Line Issue when copying data from SQL Server 2012 to Excel
Sql
Sql Server-2008
Excel
Copy Paste
Sql Server-2012
How to import a bak file into SQL Server Express
Sql Server
Sql Server-2008
Database Backups
Database Restore
Convert varchar into datetime in SQL Server
Sql
Sql Server
Sql Server-2008
Tsql
Type Conversion
How can I move a table to another filegroup in MS SQL Server?
Sql Server
Sql Server-2008
Filegroup
How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
Sql
Sql Server
Sql Server-2008
Datetime
Datetimeoffset
Stored Procedures Vs. Views
Sql
Sql Server-2008
Stored Procedures
Comparison
Views
How to Troubleshoot Intermittent SQL Timeout Errors
.Net
Sql
Sql Server
Sql Server-2008
Timeout
How do I import a sql data file into SQL Server?
Sql
Sql Server-2008
SQL Server find and replace specific word in all rows of specific column
Sql
Sql Server
Sql Server-2008
How Can I Log and Find the Most Expensive Queries?
Sql Server
Sql Server-2008
Profiling
Pros & Cons of TRUNCATE vs DELETE FROM
Sql Server
Sql Server-2008
Tsql
Sql Delete
Truncate
Binding empty list or null value to table valued parameter on a stored procedure (.NET)
.Net
Sql Server-2008
Stored Procedures
Table Valued-Parameters
Text was truncated or one or more characters had no match in the target code page When importing from Excel file
Sql Server-2008
Excel
Ssis
Codepages
Import From-Excel
How to check if datetime happens to be Saturday or Sunday in SQL Server 2008
Sql Server-2008
Convert Time DataType into AM PM Format:
Sql Server
Sql Server-2008
Select
Time
What kind of datatype should one use to store hashes?
Sql
Sql Server
Sql Server-2008
Tsql
SQL Server Case Statement when IS NULL
Sql
Sql Server
Sql Server-2008
How can I tell if a database table is being accessed anymore? Want something like a "SELECT trigger"
Sql Server
Database Design
Sql Server-2008
Clustered Index
nvarchar(max) still being truncated
Sql
Sql Server-2008
Dynamic Sql
Common Table Expression, why semicolon?
Sql
Sql Server
Tsql
Sql Server-2008
Common Table-Expression
How to group by month using SQL Server?
Sql
Sql Server-2008
Datediff
Update int column in table with unique incrementing values
Sql
Sql Server
Sql Server-2008
Import Excel spreadsheet columns into SQL Server database
Sql Server
Excel
Sql Server-2008
Import
Etl
How do I swap column values in sql server 2008?
Sql
Sql Server
Sql Server-2008
Using merge..output to get mapping between source.id and target.id
Sql Server
Sql Server-2008
Merge
combining Date and Time fields to DateTime, SQL Server 2008
Sql
Sql Server-2008
DateTimeOffset.Now in T-SQL
Sql
Sql Server
Tsql
Sql Server-2008
Datetime
Convert Xml to Table SQL Server
Sql
Xml
Sql Server-2008
Tsql
Sql Server-2005
SQL Server: check whether a Trigger is Enabled or Disabled?
Sql Server
Sql Server-2008
Tsql
Triggers
Using IF ELSE statement based on Count to execute different Insert statements
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2008-R2
SqlServer: Login failed for user
Sql Server
Sql Server-2008
Jdbc
How would one use Lucene.NET to help implement search on a site like Stack Overflow?
Sql Server-2008
Search
Lucene
lucene.net
Auto-increment primary key in SQL tables
Sql Server-2008
Ssms
How to: Create trigger for auto update modified date with SQL Server 2008
Sql Server
Sql Server-2008
Date
Triggers
Get MAX value of a BIT column
Sql
Sql Server
Tsql
Sql Server-2008
Stored Procedures
Getting error while running 50 MB script on SQL Server 2008 R2
Sql Server-2008
Sql Server-2008-R2
Remote Procedure call failed with sql server 2008 R2
Sql Server
Sql Server-2008
Sql Server-2008-R2
Convert Date format into DD/MMM/YYYY format in SQL Server
Sql
Sql Server
Sql Server-2008
Sql Server-2012
How can I create a SQL unique constraint based on 2 columns?
Sql Server
Sql Server-2005
Sql Server-2008
Constraints
Unique Constraint
HTTP Error 500.22 - Internal Server Error (An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.)
asp.net
Sql Server-2008
Iis
.Net 3.5
Windows 7
Win32Exception (0x80004005): The wait operation timed out
Sql Server-2008
asp.net Webpages
Restoring database from .mdf and .ldf files of SQL Server 2008
Sql Server-2008
Database Restore
SQL Server 2008: TOP 10 and distinct together
Sql
Sql Server
Sql Server-2008
'datetime2' error when using entity framework in VS 2010 .net 4.0
C#
Sql Server
Entity Framework
Sql Server-2008
T-SQL How to grant role to user
Sql Server
Sql Server-2008
Tsql
Temporarily disable all foreign key constraints
Sql Server
Sql Server-2008
Ssis
Constraints
Dropping and recreating databases in Microsoft SQL Server
Sql Server
Sql Server-2008
What is the syntax meaning of RAISERROR()
Sql
Sql Server
Database
Sql Server-2008
Sql Server-2008-R2
SQL Server - In clause with a declared variable
Sql
Sql Server-2008
In Clause
Is it possible to force row level locking in SQL Server?
Sql Server
Sql Server-2005
Sql Server-2008
Rowlocking
Composite Primary Key On Table Variable In Stored Procedure
Sql
Sql Server
Sql Server-2008
Stored Procedures
Primary Key
I want to show all tables that have specified column name
Sql
Sql Server-2008
Conditional logic in PostDeployment.sql script using SQLCMD
Sql
Database
Sql Server-2008
Sqlcmd
Generate Dates between date ranges
Sql
Sql Server
Tsql
Sql Server-2008
Range
What is the default transaction isolation level for SQL Server with ADO.NET?
Sql Server-2008
Transactions
ado.net
Unique key vs. unique index on SQL Server 2008
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2008-R2
How to execute a stored procedure inside a select query
Sql
Sql Server
Sql Server-2008
Stored Procedures
What do these Copy Only Backup options mean?
Sql Server
Database
Sql Server-2008
How many characters in varchar(max)?
Sql Server-2008
Size
Varchar
SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?
Sql Server
Tsql
Sql Server-2008
User Defined-Functions
User Defined-Types
How to delete rows in tables that contain foreign keys to other tables
Sql
Sql Server
Sql Server-2008
Checking an input param if not Null and using it in where in SQL Server
Sql Server
Sql Server-2008
Null
Where Clause
Coalesce
Client Statistics table (Microsoft SQL Server Management Studio)
Sql
Sql Server
Sql Server-2008
Ssms
Does the size used with NVARCHAR matter?
Sql Server-2008
Generate insert script for selected records?
Sql
Database
Sql Server-2008
Why can't I use an alias for an aggregate in a having clause?
Sql
Sql Server-2008
Is there a way to SELECT and UPDATE rows at the same time?
Sql
Sql Server
Tsql
Sql Server-2008
Create SQL INSERT Script with values gathered from table
Sql
Sql Server-2008
Check for file exists or not in sql server?
Sql
Sql Server
Sql Server-2008
3 Digit currency code to currency symbol
C#
.Net
Sql Server-2008
Currency
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
What is the difference between ";" and "GO" in T-SQL?
Sql
Sql Server
Sql Server-2008
Tsql
How to do pagination in SQL Server 2008
Sql
Sql Server-2008
Pagination
Why does SQL Server keep creating a DF constraint?
Sql
Sql Server
Sql Server-2008
Check if a parameter is null or empty in a stored procedure
Sql
Sql Server-2008
Stored Procedures
Parameters
Null
Set IDENTITY_INSERT ON is not working
Sql Server
Sql Server-2008
Tsql
Time part of a DateTime Field in SQL
Sql
Sql Server
Sql Server-2008
Tsql
Datetime
How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?
Sql Server
Ssms
Sql Server-2008
Using a database table as a queue
Sql
Database
Sql Server-2008
Queue
SQL Server GUID sort algorithm. Why?
Sql Server
Sql Server-2005
Sql Server-2008
Sorting
Invalid use side-effecting operator Insert within a function
Sql
Sql Server
Sql Server-2008
Using comparison operators in SELECT clause of T-SQL query
Sql
Sql Server
Sql Server-2008
Tsql
Comparison Operators
How do I connect to a SQL Server 2008 database using JDBC?
Java
Sql Server
Sql Server-2008
Jdbc
SQL Server Query: Fast with Literal but Slow with Variable
Sql Server
Performance
Sql Server-2008
unable to drop and create database in sql server
Sql
Sql Server-2008
Tsql
What is the use of SYNONYM?
Sql Server-2008
Entity Framework/Linq to SQL: Skip & Take
C#
.Net
Linq to-Sql
Sql Server-2008
Entity Framework-4
Assign a login to a user created without login (SQL Server)
Sql Server
Sql Server-2008
ALTER TABLE on dependent column
Sql Server-2008
Alter Table
Alter Column
How to add time to DateTime in SQL
Sql
Sql Server-2008
Datetime
Cannot Resolve Collation Conflict
Sql
Sql Server
Sql Server-2008
Sql Server-2012
Collation
T-SQL split string based on delimiter
Sql
Sql Server
Sql Server-2008
Tsql
Sql Server-2008-R2
How to change a column without dropping a table in SQL 2008
Sql Server
Sql Server-2008
Column Types
In SQL Server, how can I find everywhere a column is referenced?
Sql Server
Sql Server-2008
Get stored procedure parameters by either C# or SQL?
C#
Sql
Sql Server-2008
Stored Procedures
Parameters
Adding an INDEX to a CTE
Sql Server-2008
Common Table-Expression
Can't change table design in SQL Server 2008
Sql
Sql Server
Sql Server-2008
Count records for every month in a year
Sql
Sql Server
Sql Server-2008
Handling inheritance with overriding efficiently
Sql
Sql Server
Sql Server-2008
Tree
formula for computed column based on different table's column
Sql
Sql Server-2008
Calculated Columns
Reporting Services permissions on SQL Server R2 SSRS
Sql Server-2008
Ssrs 2008
Sql Server-2008-R2
SQL Server: should I use information_schema tables over sys tables?
Sql
Sql Server
Sql Server-2008
Stored Procedures
Metadata
Return row of every n'th record
Tsql
Sql Server-2008
Opening a SQL Server .bak file (Not restoring!)
Sql Server
Sql Server-2008
Backup
Restore
how to rename column name with T-SQL
Sql Server-2008
Tsql
Invalid object name SQL Server 2008 R2 - Stored procedure
Sql Server-2008
Select Top and Last rows in a table (SQL server)
Sql Server-2008
Encrypt connection string in app.config
C#
Sql Server-2008
App Config
Add unique constraint in SQL Server 2008 GUI?
Sql
Sql Server
Ssms
Sql Server-2008
Update Top 1 record in table sql server
Sql Server
Sql Server-2008
SQL Server 2008 R2 Stuck in Single User Mode
Sql
Sql Server
Database
Sql Server-2008
Database Deployment