Alex Rivera | Logout

Questions tagged sql-server-2008

405 questions · page 2 of 9

Sort by: Newest Votes Active
19
votes
3
answers

SQL Join on Table A value within Table B range

sql sql-server sql-server-2008 t-sql
asked 2012-09-26T14:34:40.860
12
votes
2
answers

copy a SQL Server 2008 database and rename it

sql database sql-server-2008 sql-server-2012
asked 2012-09-18T22:25:43.310
28
votes
1
answers

Does SQL Server support IS DISTINCT FROM clause?

sql sql-server sql-server-2008 sql-server-2008-r2 distinct
asked 2012-09-17T09:44:44.637
89
votes
9
answers

how to extract only the year from the date in sql server 2008?

sql sql-server-2008 datetime extract
asked 2012-09-15T10:51:09.180
26
votes
3
answers

Identity insert on linked server fails

sql sql-server sql-server-2008
asked 2012-09-12T15:35:05.123
12
votes
7
answers

Drop all extended properties on SQL Server

sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2
asked 2012-09-11T11:14:56.640
26
votes
6
answers

Executing SQL Server Agent Job from a stored procedure and returning job result

sql sql-server sql-server-2008 t-sql jobs
asked 2012-09-03T13:42:10.173
9
votes
2
answers

Exporting binary file data (images) from SQL via a stored procedure

sql sql-server sql-server-2008 t-sql
asked 2012-08-30T20:00:59.240
28
votes
5
answers

SQL Agent Job - "Run As" drop down list is empty

sql sql-server-2008 proxy jobs agent
asked 2012-08-24T15:23:01.277
11
votes
3
answers

Get Excel sheet into temp table using a script

sql sql-server sql-server-2008 excel
asked 2012-08-23T11:29:01.983
10
votes
2
answers

Parameter value '33.42922222' is out of range

asp.net-mvc-3 sql-server-2008 entity-framework
asked 2012-08-22T22:34:04.433
9
votes
7
answers

Search a column name across all databases

sql-server-2008 information-schema
asked 2012-08-21T08:46:54.750
30
votes
4
answers

IIF(...) not a recognized built-in function

sql sql-server-2008 t-sql sql-server-2005 sql-server-2008-r2
asked 2012-08-20T09:18:51.327
42
votes
7
answers

Pasting from SQL Server Management Studio to Excel concatenates columns

sql-server-2008 concatenation paste
asked 2012-08-16T21:55:00.920
98
votes
8
answers

Select a Column in SQL not in Group By

sql sql-server-2008 t-sql greatest-n-per-group
asked 2012-08-16T15:54:38.413
13
votes
3
answers

SQL LIKE Statement on a DateTime Type

sql sql-server-2008 datetime
asked 2012-08-16T10:47:08.153
13
votes
4
answers

How to control nullability in SELECT INTO for literal-based columns

sql sql-server-2008 t-sql
asked 2012-08-08T19:50:37.473
22
votes
1
answers

What can I use instead of #Temp table in sql function

sql-server-2008 t-sql temp
asked 2012-08-08T06:04:12.407
28
votes
9
answers

Find Column dependency

sql-server t-sql sql-server-2008 sql-server-2008-r2
asked 2012-08-01T23:49:16.517
43
votes
5
answers

Possible to do a delete with a HAVING clause?

sql sql-server sql-server-2008
asked 2012-07-29T01:44:51.380
13
votes
3
answers

How to grant sendmail permission to sql server user?

sql sql-server sql-server-2008
asked 2012-07-26T09:26:38.553
28
votes
5
answers

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) Can someone explain me this

sql-server-2008
asked 2012-07-26T08:17:39.773
11
votes
4
answers

How can I generate CREATE TABLE script from code?

c# sql sql-server-2008
asked 2012-07-25T18:33:35.407
9
votes
3
answers

Select items like records from a column in another table

sql sql-server sql-server-2008
asked 2012-07-25T04:06:14.740
16
votes
4
answers

SQL: how to get sunday of current week

sql sql-server-2008 date
asked 2012-07-20T13:55:23.913
11
votes
3
answers

FORMAT function not working in sql server 2008 R2

sql sql-server sql-server-2008
asked 2012-07-16T06:53:23.727
33
votes
8
answers

Connecting to SQL Server Express - What is my server name?

sql sql-server sql-server-2008 sql-server-express
asked 2012-07-11T03:53:06.543
10
votes
6
answers

Change column name in SQL Server 2008

sql sql-server sql-server-2008
asked 2012-07-10T20:58:44.823
13
votes
3
answers

Can I get the results of a stored procedure into a cursor within another stored procedure in SQL

sql sql-server sql-server-2008 stored-procedures database-cursor
asked 2012-07-05T10:21:02.900
29
votes
3
answers

Select rows where column value has changed

sql sql-server-2008 t-sql select
asked 2012-06-20T20:14:37.053
39
votes
4
answers

Splitting delimited values in a SQL column into multiple rows

sql sql-server sql-server-2008 t-sql sql-server-2005
asked 2012-06-13T15:17:15.903
78
votes
3
answers

T-SQL How to grant role to user

sql-server sql-server-2008 t-sql
asked 2012-06-13T04:55:05.870
9
votes
1
answers

How to check the isolation level of another connection SQL Server 2008

sql-server sql-server-2008
asked 2012-06-12T12:56:46.173
9
votes
2
answers

SQL Server add computed column in VIEW with conditions

sql sql-server-2008 calculated-columns sql-view
asked 2012-06-06T10:07:36.860
11
votes
1
answers

MERGE Violation of PRIMARY KEY constraint

sql sql-server sql-server-2008 t-sql upsert
asked 2012-05-23T16:44:37.530
9
votes
6
answers

Fastest way to transfer Excel table data to SQL 2008R2

excel vba sql-server-2008 import large-data
asked 2012-05-22T18:42:30.987
46
votes
1
answers

database: primary key, Clustered or NonClustered

database sql-server-2008 primary-key clustered-index
asked 2012-05-22T17:26:16.563
8
votes
3
answers

Failed To Convert Parameter Value From A String To A Int32

c# sql sql-server-2008
asked 2012-05-20T18:07:19.863
12
votes
5
answers

SQL - convert int to double

sql-server-2008
asked 2012-05-18T12:51:26.367
9
votes
3
answers

Is TimeStamp column unique?

sql sql-server sql-server-2008 timestamp
asked 2012-05-16T10:17:09.493
13
votes
4
answers

Changing a data column from varchar(max) to nvarchar(max) in SQL Server 2008

sql-server-2008
asked 2012-05-15T20:22:11.257
32
votes
3
answers

Update Rows in SSIS OLEDB Destination

sql-server-2008 ssis
asked 2012-05-11T17:14:30.423
117
votes
8
answers

How do I use the CONCAT function in SQL Server 2008 R2?

sql-server sql-server-2008 t-sql
asked 2012-05-11T11:17:11.787
15
votes
2
answers

The specified cast from a materialized 'System.Guid' type to the 'System.Int32' type is not valid

c# wcf sql-server-2008 sql-server-2005 entity-framework-4
asked 2012-05-10T20:59:48.217
8
votes
4
answers

Doctrine 2: Can't update DateTime column on SQL Server 2008apm

php sql-server-2008 datetime doctrine doctrine-orm
asked 2012-05-10T06:17:12.850
35
votes
11
answers

Determine ROW that caused "unexpected end of file" error in BULK INSERT?

sql sql-server sql-server-2008 bulkinsert
asked 2012-05-08T21:57:05.977
8
votes
1
answers

Create a new menu item in SQL Server Management Studio

c# visual-studio-2010 sql-server-2008 ssms
asked 2012-05-05T08:53:58.787
18
votes
4
answers

Will indexing improve varchar(max) query performance, and how to create index

sql-server sql-server-2008 indexing full-text-indexing database-optimization
asked 2012-05-02T22:54:58.400
12
votes
4
answers

A network-related or instance-specific error occurred while establishing a connection to SQL Server - ASP.NET MVC Entity Framework

asp.net-mvc-3 sql-server-2008 entity-framework
asked 2012-05-02T05:29:35.010
15
votes
3
answers

SQL Server: Checking the datatype of a column

sql-server-2008 sqldatatypes
asked 2012-04-27T15:06:11.253
← Prev page 2 of 9 Next →