Alex Rivera | Logout

Questions tagged sql-server-2005

288 questions · page 2 of 6

Sort by: Newest Votes Active
25
votes
3
answers

Cannot connect to SQL Server express from SSMS

sql sql-server sql-server-2005 ssms
asked 2011-05-15T06:58:40.747
17
votes
7
answers

Why are values stored in an NVARCHAR column sometimes padded with trailing spaces?

c# sql-server-2005
asked 2011-04-21T15:18:19.290
25
votes
1
answers

SQL Server - use count function with intersect

database sql-server-2005 select
asked 2011-04-16T00:16:59.797
12
votes
4
answers

How can I check for duplicates before inserting into a table when inserting by select

sql sql-server sql-server-2005 t-sql sql-server-2008
asked 2011-04-08T19:25:41.360
28
votes
3
answers

Find out default SQL Server schema for session

sql sql-server-2005
asked 2011-04-01T12:00:34.970
75
votes
6
answers

How do parameterized queries help against SQL injection?

c# .net sql sql-server-2005 parameterized-query
asked 2011-03-29T05:50:33.023
17
votes
2
answers

SQL: Aggregating strings together

sql sql-server-2005
asked 2011-03-27T21:46:10.233
11
votes
3
answers

using self referencing in sql server

sql sql-server sql-server-2005 foreign-keys self-reference
asked 2011-03-26T13:45:10.603
18
votes
9
answers

What is an alternative to cursors for sql looping?

sql-server t-sql sql-server-2008 sql-server-2005 database-cursor
asked 2011-03-24T21:17:06.717
18
votes
4
answers

In SQL Server, what is the best way to determine if a given string is a valid XML or not?

xml sql-server-2005 t-sql
asked 2011-03-21T18:20:54.060
25
votes
4
answers

SQL Server: Native client vs. ODBC?

sql-server sql-server-2005 sql-server-2008 odbc database-connection
asked 2011-03-17T18:20:13.383
149
votes
3
answers

Difference between FOR and AFTER triggers?

sql sql-server-2005 triggers
asked 2011-03-17T14:44:34.853
20
votes
3
answers

What happens to the primary key Id when it goes over the limit?

sql-server sql-server-2005 sql-server-2008
asked 2011-03-14T22:13:04.963
47
votes
2
answers

Row_Number() with union query

sql-server-2005
asked 2011-03-04T05:57:41.660
15
votes
4
answers

SQL: Count number of columns in all tables, excluding views

sql sql-server-2005
asked 2011-03-01T17:17:25.210
24
votes
3
answers

how to tell if an index is ever used

sql-server sql-server-2005
asked 2011-02-28T17:27:45.840
16
votes
6
answers

If Else If In a Sql Server Function

sql sql-server-2005
asked 2011-02-17T16:35:19.940
21
votes
4
answers

Difference between Implicit and Explicit Transaction

sql-server-2005 sql-server-2008 c#-4.0 transactions transactionscope
asked 2011-02-13T20:30:59.217
10
votes
3
answers

C# Prepared Statements - @ sign (at / strudel sign) queries

c# sql sql-server-2005 prepared-statement email-validation
asked 2011-02-10T08:32:45.613
12
votes
1
answers

"The selected data source is on remote computer" error when creating an SSIS job

sql-server-2005 ssis import flat-file dataflowtask
asked 2011-02-08T22:41:10.263
19
votes
7
answers

Using the result of an expression (e.g. Function call) in a stored procedure parameter list?

sql sql-server sql-server-2005 t-sql casting
asked 2011-02-08T17:24:04.897
20
votes
3
answers

Is There ANY Sense in SQL Data Type VARCHAR(1)?

sql sql-server-2005 types
asked 2011-02-02T00:25:05.140
11
votes
5
answers

How to use like condition with multiple values in sql server 2005?

sql sql-server sql-server-2005 t-sql like-keyword
asked 2011-01-31T20:32:33.317
11
votes
4
answers

How to add one year to a date using SQL script in SQL server?

sql-server-2005
asked 2011-01-20T06:36:16.173
27
votes
9
answers

Default getdate for Insert date

sql sql-server sql-server-2005 t-sql
asked 2011-01-12T17:49:52.313
10
votes
5
answers

SQL SERVER NON-Clustered Index on table variable?

t-sql sql-server-2005
asked 2011-01-10T09:19:38.153
25
votes
3
answers

Disable "save" prompt in SQL Server Management Studio 2005

sql sql-server sql-server-2005 ssms
asked 2011-01-06T21:16:01.630
17
votes
2
answers

What is an Extended Stored Procedure in MS SQL Server?

sql-server stored-procedures sql-server-2005 database-administration definition
asked 2011-01-05T11:11:19.633
149
votes
10
answers

How can I get the actual stored procedure line number from an error message?

sql sql-server-2005
asked 2010-12-30T19:30:44.340
168
votes
10
answers

What does collation mean?

sql sql-server-2005 t-sql mysql
asked 2010-12-27T12:47:10.847
15
votes
1
answers

Composite primary key and additional indexes

sql-server sql-server-2005
asked 2010-12-07T21:44:57.120
29
votes
6
answers

Custom aggregate function (concat) in SQL Server

sql sql-server-2005 sql-server-2008 aggregate-functions aggregation
asked 2010-12-07T08:33:26.400
32
votes
3
answers

Finding blocking/locking queries in MS SQL (mssql)

sql-server sql-server-2005 sql-server-2008 query-optimization
asked 2010-12-06T11:36:49.910
26
votes
1
answers

SqlDependency - How do I interpret the SqlNotificationEventArgs properties?

c# sql-server-2005 sqldependency
asked 2010-11-30T19:24:22.593
14
votes
3
answers

Is it possible for a trigger to find the name of the stored procedure that modified data?

sql-server-2005 stored-procedures triggers
asked 2010-11-23T21:45:00.740
32
votes
7
answers

SQL Subtract exactly a year

sql sql-server sql-server-2005
asked 2010-11-22T15:33:09.013
64
votes
11
answers

How to select rows for a specific date, ignoring time in SQL Server 2005 or earlier

sql sql-server-2005
asked 2010-11-11T15:24:34.753
30
votes
5
answers

Table Valued Function Killing My Query Performance

sql-server sql-server-2005 sql-server-2008
asked 2010-11-05T18:59:24.370
11
votes
5
answers

Auto increment feature in Database

asp.net mysql sql-server database sql-server-2005
asked 2010-11-02T07:16:26.637
55
votes
9
answers

Script to save varbinary data to disk

sql sql-server sql-server-2005 varbinary
asked 2010-10-29T21:30:03.213
67
votes
2
answers

Convert Xml to Table SQL Server

sql xml sql-server-2008 t-sql sql-server-2005
asked 2010-10-21T15:55:52.280
150
votes
6
answers

Getting result of dynamic SQL into a variable for sql-server

sql sql-server sql-server-2005 t-sql dynamic-sql
asked 2010-10-01T15:39:16.627
103
votes
4
answers

Declare Variable for a Query String

sql sql-server sql-server-2005 t-sql dynamic-sql
asked 2010-09-30T17:50:19.170
27
votes
6
answers

SQL Server search for a column by name

sql sql-server sql-server-2005
asked 2010-09-21T15:09:23.233
143
votes
6
answers

How much size "Null" value takes in SQL Server

sql-server t-sql sql-server-2005 null
asked 2010-09-16T22:01:04.653
9
votes
3
answers

SQL Server sp_ExecuteSQL and Execution Plans

sql sql-server sql-server-2005 t-sql sql-execution-plan
asked 2010-09-14T15:47:44.743
24
votes
2
answers

MS SQL server - convert HEX string to integer

sql-server sql-server-2005
asked 2010-08-30T22:08:37.017
16
votes
5
answers

I Need Countries List in T-SQL

sql-server-2005 t-sql sql-server-2008
asked 2010-08-28T07:37:27.917
94
votes
5
answers

Index Key Column VS Index Included Column

sql-server-2005 t-sql
asked 2010-08-27T04:17:01.113
13
votes
5
answers

Ways to escape single quotes in SQL 'LIKE' command

sql sql-server-2005 mysql oracle10g
asked 2010-08-17T15:48:35.187
← Prev page 2 of 6 Next →