Alex Rivera | Logout

Questions tagged sql-server-2005

288 questions · page 3 of 6

Sort by: Newest Votes Active
12
votes
4
answers

How do I "Declare the scalar variable" in a VIEW in Sql Server (2005)

sql sql-server-2005
asked 2010-08-13T09:49:58.927
19
votes
2
answers

SQL server select distinct rows using most recent value only

sql sql-server sql-server-2005 t-sql greatest-n-per-group
asked 2010-08-09T18:22:37.653
18
votes
4
answers

SSIS 2005: "Append rows to the destination table" is greyed out. Why?

sql-server-2005 ssis import append dts
asked 2010-08-06T16:45:21.350
15
votes
4
answers

SQL Server 2005, how to copy a Database Diagram to another server

sql sql-server-2005 t-sql ssms
asked 2010-07-22T14:48:12.073
17
votes
2
answers

What's the best to check if item exist or not: Select Count(ID)OR Exist(...)?

sql sql-server-2005 performance t-sql
asked 2010-07-17T12:25:04.403
22
votes
6
answers

Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2

c# asp.net sql-server-2005 asp.net-mvc-2 sql-server-ce
asked 2010-07-11T14:19:07.247
14
votes
3
answers

Retrieving the most recent records within a query

sql-server sql-server-2005 t-sql group-by greatest-n-per-group
asked 2010-07-05T22:17:19.853
45
votes
4
answers

How to implement badges?

c# sql-server-2005 asp.net-mvc-2 badge
asked 2010-07-01T23:47:19.573
31
votes
7
answers

SQL Server - How to Grant Read Access to ALL databases to a Login?

sql sql-server sql-server-2005 t-sql permissions
asked 2010-06-21T18:00:11.680
9
votes
4
answers

UPDATE is not allowed because the statement updates view "table_name" which participates in a join and has an INSTEAD OF UPDATE trigger

sql sql-server sql-server-2005 t-sql
asked 2010-06-21T13:26:54.850
10
votes
5
answers

How can I rename my column in a SQL table?

sql sql-server sql-server-2005
asked 2010-06-17T08:29:00.000
35
votes
2
answers

SQL Server Update Trigger, Get fields before and after updated

sql-server-2005
asked 2010-06-06T06:29:01.890
10
votes
7
answers

Can I select 0 columns in SQL Server?

sql-server sql-server-2005 t-sql
asked 2010-06-03T19:12:48.237
315
votes
13
answers

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

sql sql-server sql-server-2005 foreign-keys
asked 2010-06-03T12:24:54.647
15
votes
9
answers

check if a value is NULL or Less than 0 in one TSQL statement

sql-server-2005 t-sql
asked 2010-05-27T10:03:41.923
28
votes
1
answers

Is it possible to join a table valued function and another table with parameters

sql-server-2005
asked 2010-05-26T21:03:59.070
142
votes
26
answers

Login failed for user 'DOMAIN\MACHINENAME$'

.net sql-server sql-server-2005 web-applications iis-6
asked 2010-05-10T21:01:21.700
32
votes
5
answers

What is a deadlock in a database?

database sql-server-2005 deadlock database-deadlocks
asked 2010-05-05T16:12:16.800
44
votes
4
answers

Is there any way to view whitespace in the query editor for SQL Server Management Studio Express 2005?

sql-server-2005 ide whitespace ssms
asked 2010-05-03T18:03:27.333
18
votes
3
answers

How can we check that table have index or not?

sql sql-server sql-server-2005 sql-server-2008
asked 2010-04-29T08:59:55.727
47
votes
3
answers

If I update a view, will my original tables get updated

sql sql-server sql-server-2005 t-sql view
asked 2010-04-15T19:41:39.873
43
votes
1
answers

How to change the primary key to be non-clustered?

sql sql-server-2005 clustered-index alter
asked 2010-04-09T00:54:18.143
43
votes
5
answers

Get row where datetime column = today

sql-server sql-server-2005
asked 2010-04-06T07:14:29.703
13
votes
2
answers

C++ Access to SQL Server from Linux

c++ sql linux sql-server-2005 odbc
asked 2010-03-30T14:11:44.970
41
votes
10
answers

Images in database vs file system

asp.net sql database sql-server-2005 document-storage
asked 2010-03-25T17:10:22.483
12
votes
2
answers

SQL Server: Migrate Stored Procedures between Databases, Instances

sql-server sql-server-2005
asked 2010-03-18T15:18:47.007
9
votes
5
answers

how Do I list all table names in SQL Server using T-SQL?

sql-server sql-server-2005 t-sql
asked 2010-03-16T17:51:40.360
40
votes
2
answers

check for null date in CASE statement, where have I gone wrong?

sql sql-server-2005 case smalldatetime
asked 2010-03-16T11:43:16.970
29
votes
2
answers

Create a table without columns

sql-server-2005 t-sql sql-server-express
asked 2010-03-13T12:35:33.607
14
votes
2
answers

How do you add a NOT NULL FOREIGN KEY column to an existing (populated) table in MS SQL?

sql-server sql-server-2005 foreign-keys constraints nullable
asked 2010-03-11T06:51:58.060
9
votes
4
answers

SQL Server 2005 Error 701 - out of memory

sql-server-2005 memory
asked 2010-02-19T12:57:22.573
75
votes
5
answers

How to get number of rows inserted by a transaction

sql-server sql-server-2005
asked 2010-02-16T12:11:14.997
19
votes
3
answers

Multiple commands on one line in SQL Server 2005

sql-server sql-server-2005
asked 2010-02-15T09:54:56.277
14
votes
8
answers

Automated generation of database change scripts

sql-server visual-studio-2008 sql-server-2005 t-sql tfsbuild
asked 2010-02-12T16:06:16.323
12
votes
3
answers

How to run a sql script using C#

c# .net sql-server sql-server-2005
asked 2010-02-12T07:48:13.320
30
votes
7
answers

Omitting the Milliseconds in a Date

sql sql-server database sql-server-2005 t-sql
asked 2010-02-11T18:24:56.690
18
votes
5
answers

How to connect to sql-server with windows authentication from windows-service?

c# .net sql-server sql-server-2005 windows-services
asked 2010-02-11T13:54:32.777
19
votes
2
answers

Count(*) vs Count(Id) in sql server 2005

sql-server-2005 count
asked 2010-02-08T05:54:36.563
14
votes
3
answers

What is a dynamic SQL query, and when would I want to use one?

sql sql-server-2005 dynamic-sql
asked 2010-02-03T06:03:33.063
9
votes
2
answers

SQL Server 2005 : Converting varchar value '1.23E-4' to decimal fails

sql sql-server-2005
asked 2010-01-27T17:32:17.403
70
votes
7
answers

Check whether a table contains rows or not sql server 2005

sql-server-2005
asked 2010-01-27T09:59:00.310
19
votes
7
answers

How to get if a string is a number in T-SQL

sql-server-2005 t-sql
asked 2010-01-21T13:42:19.653
26
votes
4
answers

Marking persisted computed columns NOT NULL in SQL Server Management Studio

sql-server sql-server-2005 ssms
asked 2010-01-12T15:22:38.437
255
votes
10
answers

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

sql sql-server sql-server-2005 t-sql
asked 2010-01-11T19:49:20.713
16
votes
3
answers

How to alter length of varchar in composite primary key?

sql-server sql-server-2005 sql-server-2008 primary-key constraints
asked 2010-01-11T16:48:38.433
44
votes
4
answers

Reading a text file with SQL Server

sql-server sql-server-2005 xp-cmdshell
asked 2010-01-05T17:30:29.327
13
votes
5
answers

SQL Server cache question

sql-server-2005 caching performance
asked 2010-01-04T22:00:52.937
116
votes
5
answers

Use a LIKE statement on SQL Server XML Datatype

sql sql-server xml sql-server-2005
asked 2009-12-02T13:40:49.637
9
votes
3
answers

SQLServerException: The statement did not return a result set when executing SQL

sql-server sql-server-2005 jdbc
asked 2009-12-01T13:44:39.963
251
votes
6
answers

SQL Server - transactions roll back on error?

sql sql-server sql-server-2005 transactions
asked 2009-11-17T15:38:13.087
← Prev page 3 of 6 Next →