KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
sql-server-2005
288 questions · page 3 of 6
Follow Tag
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 →