Alex Rivera | Logout

Questions tagged sql-server-2008

405 questions · page 3 of 9

Sort by: Newest Votes Active
8
votes
3
answers

MSSQL Query to delete duplicate rows from a TABLE leaving distinct rows in table

sql sql-server sql-server-2008
asked 2012-04-27T07:21:11.907
86
votes
1
answers

SQL Server Invalid Column name after adding new column

sql sql-server sql-server-2008 t-sql sql-server-2005
asked 2012-04-26T17:43:51.227
8
votes
2
answers

how to use openrowset to execute a stored procedure with parameters

sql-server-2008 t-sql stored-procedures openrowset
asked 2012-04-24T06:25:37.573
34
votes
7
answers

Conditional JOIN different tables

sql sql-server-2008 join conditional-statements
asked 2012-04-23T10:49:13.463
8
votes
4
answers

How to find the join path from one table to another in a large database

sql database sql-server-2008 t-sql
asked 2012-04-18T13:00:22.680
8
votes
1
answers

SQL query that selects effective costing rate based on charge date

sql sql-server sql-server-2008
asked 2012-04-17T18:18:28.753
39
votes
3
answers

Why are CLR Types derived from generics not supported in SQL Server 2008 and later?

c# sql-server-2008 t-sql generics sql-server-2012
asked 2012-04-13T13:41:04.800
14
votes
7
answers

Encoding SQL_Latin1_General_CP1_CI_AS into UTF-8

php xml sql-server-2008 encoding utf-8
asked 2012-04-12T13:48:57.773
9
votes
1
answers

How to use stored proc inside log4net configuration for SQL Server for logging

asp.net sql-server-2008 stored-procedures logging log4net
asked 2012-04-05T18:35:58.667
48
votes
4
answers

Counting no of rows returned by a select query

sql-server sql-server-2008 t-sql
asked 2012-03-30T15:15:10.970
10
votes
4
answers

Create a trigger that inserts values into a new table when a column is updated

sql sql-server sql-server-2008 triggers
asked 2012-03-29T19:08:20.140
9
votes
2
answers

Unable to access table variable in stored procedure

c# sql-server-2008 stored-procedures
asked 2012-03-29T07:45:09.783
58
votes
4
answers

Count records for every month in a year

sql sql-server sql-server-2008
asked 2012-03-27T10:58:16.780
54
votes
4
answers

Can't change table design in SQL Server 2008

sql sql-server sql-server-2008
asked 2012-03-26T11:04:58.520
8
votes
3
answers

Hibernate (/JPA) server-side paging and MS SQL Server

sql-server sql-server-2008 hibernate jpa orm
asked 2012-03-26T08:23:35.743
275
votes
14
answers

SQL Server Configuration Manager cannot be found

sql-server sql-server-2008 sql-server-2012 sql-server-2008-r2 sql-server-config-manager
asked 2012-03-23T18:40:41.823
50
votes
10
answers

How to backup Sql Database Programmatically in C#

.net database sql-server-2008 c#-4.0 backup
asked 2012-03-23T07:34:47.667
11
votes
8
answers

Error converting data types when importing from Excel to SQL Server 2008

sql-server sql-server-2008
asked 2012-03-21T16:03:28.260
8
votes
3
answers

What's the difference between these T-SQL queries using OR?

sql-server sql-server-2008 database-performance sql-execution-plan
asked 2012-03-13T11:45:05.073
30
votes
4
answers

How to insert 1000 random dates between a given range?

sql sql-server-2008
asked 2012-03-10T09:26:49.027
8
votes
4
answers

SQL Server returns unexpected week number

sql-server-2008 t-sql
asked 2012-03-08T16:16:56.990
16
votes
5
answers

<table-valued function> is not a recognized built-in function name

sql sql-server sql-server-2008
asked 2012-03-05T23:19:45.973
73
votes
8
answers

How to check if datetime happens to be Saturday or Sunday in SQL Server 2008

sql-server-2008
asked 2012-03-05T16:19:09.500
83
votes
10
answers

SQL query with NOT LIKE IN

sql sql-server-2008 t-sql
asked 2012-02-22T10:55:33.823
78
votes
4
answers

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
asked 2012-02-22T10:38:40.630
18
votes
7
answers

How to restore a SQL Server database backup without knowing the destination path or filenames?

sql-server sql-server-2008 t-sql database-restore
asked 2012-02-22T02:57:47.310
11
votes
10
answers

SSIS issue Failed to decrypt protected XML node

sql sql-server sql-server-2008 ssis
asked 2012-02-15T16:17:21.727
18
votes
4
answers

Adding a nullable foreign key

sql sql-server-2008 foreign-keys
asked 2012-02-08T19:09:10.687
14
votes
1
answers

How can i change or update password in asp.net membership via sql server

asp.net sql sql-server-2008 asp.net-membership password-recovery
asked 2012-01-24T11:46:48.597
12
votes
1
answers

can SQL insert using select return multiple identities?

sql-server sql-server-2008 lastinsertid
asked 2012-01-24T06:38:24.007
9
votes
3
answers

Ordering SQL Server results by IN clause

asp.net sql database sql-server-2008 stored-procedures
asked 2012-01-20T20:19:01.110
11
votes
3
answers

Automatically generate a user defined table type that matches an existing table

sql sql-server-2008 t-sql sql-server-2008-r2
asked 2012-01-20T18:31:35.837
16
votes
3
answers

pyodbc/FreeTDS/unixODBC on Debian Linux: issues with TDS Version

sql-server-2008 pyodbc freetds unixodbc
asked 2012-01-17T06:11:20.853
13
votes
2
answers

How to properly run ALTER VIEW after ALTER TABLE

sql sql-server-2008 sql-server-2005 t-sql
asked 2012-01-16T00:08:13.343
11
votes
5
answers

how to change positive value to negative

sql-server sql-server-2008
asked 2012-01-13T08:46:55.903
17
votes
5
answers

Using a HAVING clause in an UPDATE statement

sql sql-server-2008 having
asked 2012-01-09T19:20:34.433
10
votes
3
answers

How to execute dtsx packages through command line

visual-studio-2010 sql-server-2008 ssis
asked 2012-01-09T10:29:36.847
10
votes
2
answers

Upsert SQL query

sql sql-server-2008 stored-procedures
asked 2012-01-02T13:39:18.877
11
votes
4
answers

How to add identity to the column in SQL Server?

sql sql-server sql-server-2008
asked 2011-12-28T16:25:41.943
194
votes
12
answers

How to drop column with constraint?

sql-server sql-server-2008
asked 2011-12-27T06:55:57.370
10
votes
6
answers

Error : Cannot fetch a row from OLE DB provider "ADsDSOObject" for linked server "ADSI"

sql sql-server sql-server-2008
asked 2011-12-21T18:46:44.153
8
votes
4
answers

SQL: Error, Expression services limit reached?

sql sql-server-2008 t-sql
asked 2011-12-20T23:48:09.047
11
votes
1
answers

Executing the same SSIS Package with different parameters at different time

sql-server-2008 parameters ssis sql-server-agent
asked 2011-12-05T11:50:20.013
28
votes
6
answers

Set variable value to array of strings

sql sql-server-2008
asked 2011-12-01T23:36:12.217
11
votes
1
answers

How to move a text file after importing the data using SSIS package?

sql-server sql-server-2008 ssis
asked 2011-11-22T17:45:15.757
70
votes
3
answers

SQL Server: check whether a Trigger is Enabled or Disabled?

sql-server sql-server-2008 t-sql triggers
asked 2011-11-15T13:18:35.800
11
votes
4
answers

How to load image from SQL Server into picture box?

c# winforms sql-server-2008 picturebox
asked 2011-11-10T18:38:26.293
12
votes
2
answers

Cross database queries, joins advantages and disadvantages

sql sql-server sql-server-2008
asked 2011-11-09T09:25:52.573
8
votes
9
answers

Getting "Multiple-step operation generated errors. Check each status value." error using ADO with SQL server 2008

sql-server sql-server-2008 ado
asked 2011-11-07T18:03:42.953
8
votes
1
answers

SqlDependency notification - immediate failure notification after executing query

c# .net sql-server-2005 sql-server-2008 ado.net
asked 2011-10-30T18:31:01.300
← Prev page 3 of 9 Next →