Questions tagged [sql-server-2005]

93

votes

2

answers

Is it necessary to use # for creating temp tables in SQL server?

asked 2013-05-25T11:25:30.020

57

votes

15

answers

SQL Query to find the last day of the month

sql-server sql-server-2005 date datetime

asked 2013-05-20T09:37:20.507

45

votes

5

answers

Cannot find the user '', because it does not exist or you do not have permission

sql-server t-sql sql-server-2005 stored-procedures

asked 2013-04-16T15:06:41.443

10

votes

5

answers

SQL Server - INSERT failed because of 'ARITHABORT'

sql-server sql-server-2005 calculated-columns database-indexes

asked 2013-02-19T08:59:35.940

11

votes

1

answers

SQL Server 2005 : str(4.65,5,1) = 4.7, str(3.65,5,1) = 3.6?

sql sql-server sql-server-2005

asked 2012-11-27T13:29:36.737

10

votes

2

answers

Why does a NULL aggregate warning in an SQL query causes the SSIS package to fail?

sql-server-2005 ssis

asked 2012-10-31T12:03:15.910

8

votes

4

answers

How to add a row number to new table in SQL?

sql-server-2005 insert-into

asked 2012-10-24T20:40:25.037

21

votes

2

answers

pyodbc.connect timeout argument is ignored for calls to SQL Server

python sql-server-2005 pyodbc

asked 2012-10-18T00:14:35.080

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

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

10

votes

4

answers

how to fix Windows NT user or group 'IIS APPPOOL\DefaultAppPool' not found?

sql sql-server-2005 iis-7.5

asked 2012-07-27T01:26:03.500

11

votes

2

answers

How to Convert Datetime to Date in dd/MM/yyyy format

sql sql-server-2005

asked 2012-07-16T09:09:54.787

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

9

votes

1

answers

Cannot find data type date in SQL Server 2005

sql sql-server-2005

asked 2012-06-08T17:02:32.517

10

votes

5

answers

Need to start agent job and wait until completes and get success or failure

t-sql sql-server-2005 sql-agent-job

asked 2012-05-18T07:29:55.697

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

68

votes

8

answers

Convert SSMS .rpt output file to .txt/.csv

sql-server sql-server-2005 character-encoding ssms rpt

asked 2012-05-10T16:14:17.470

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

27

votes

5

answers

Why is IS NOT NULL returning NULL values for a Varchar(max) in SQL Server?

sql-server sql-server-2005

asked 2012-04-24T10:04:09.963

11

votes

2

answers

Query to Select Between Two Times of Day

sql t-sql sql-server-2005

asked 2012-04-05T20:47:04.020

18

votes

1

answers

Invalid column name 'False' (Classic asp, table edit issue)

sql-server sql-server-2005 asp-classic

asked 2012-03-30T10:47:06.350

19

votes

7

answers

Is there a quick way to check if ANY column is NULL?

sql sql-server sql-server-2005 t-sql

asked 2012-03-14T15:54:06.667

10

votes

6

answers

Can I search stored procedure results?

sql sql-server-2005 stored-procedures

asked 2012-02-21T13:35:09.327

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

16

votes

8

answers

SQL Group by Age Range

sql sql-server sql-server-2005 group-by

asked 2012-01-06T18:52:06.097

15

votes

1

answers

Advice for sql server full text indexing change tracking and population

sql-server-2005 full-text-search

asked 2011-12-20T23:10:27.637

35

votes

1

answers

Find non-default collation on columns for all tables in SQL Server

sql-server sql-server-2005

asked 2011-12-13T11:36:29.393

10

votes

2

answers

Dynamically name indexes in SQL Server 2005?

sql sql-server sql-server-2005

asked 2011-12-07T20:55:49.037

46

votes

4

answers

how to convert numeric to nvarchar in sql command

sql sql-server-2005

asked 2011-12-07T06:45:15.113

48

votes

3

answers

How to set the default schema of a database in SQL Server 2005?

sql sql-server sql-server-2005

asked 2011-11-21T06:22:57.050

16

votes

2

answers

Do statistics referencing a column prevent that column from being dropped?

sql-server sql-server-2005 ddl

asked 2011-10-31T16:31:03.293

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

35

votes

4

answers

Query the contents of stored procedures on SQL Server

sql-server sql-server-2005 t-sql relational-database

asked 2011-10-07T11:13:46.697

16

votes

2

answers

Select data from XML file as table in TSQL

sql-server-2005 t-sql

asked 2011-10-04T14:15:45.440

15

votes

3

answers

How to Update the Date without changing its Time Using SQL Server?

sql sql-server sql-server-2005 datetime

asked 2011-10-03T04:22:35.043

35

votes

2

answers

SQL Server pivot vs. multiple join

sql-server performance sql-server-2005 join pivot

asked 2011-09-16T17:43:55.217

48

votes

1

answers

1 SET statement for multiple variables like declare statement

sql sql-server-2005

asked 2011-08-25T16:16:09.420

10

votes

3

answers

How do I properly SELECT INTO @TempTable Multiple times to return a single resultset?

sql sql-server-2005 t-sql

asked 2011-08-22T19:36:35.153

13

votes

2

answers

SQL Server BIGINT or DECIMAL(18,0) for primary key

sql sql-server performance sql-server-2005 types

asked 2011-07-27T01:03:48.597

19

votes

2

answers

How to periodically flush dapper.net cache when used with SQL Server

c# sql-server-2005 t-sql orm dapper

asked 2011-07-25T15:13:26.677

11

votes

6

answers

Is there a way to escape a double quote within a text qualified string on a SSIS Csv import?

sql-server sql-server-2005 ssis

asked 2011-07-07T21:17:01.990

10

votes

4

answers

Concatenate values based on ID

sql sql-server sql-server-2005 t-sql sql-server-2008

asked 2011-07-06T21:36:24.517

10

votes

2

answers

SQL Server script to remove replication?

sql-server-2005 replication

asked 2011-06-29T08:03:10.427

18

votes

1

answers

Difference Between Transaction and TransactionScope

c# sql-server-2005 transactions transactionscope

asked 2011-06-27T12:58:32.603

81

votes

3

answers

Unique Key Violation in SQL Server - Is it safe to assume Error 2627?

sql-server-2005 unique-constraint

asked 2011-06-26T11:47:11.187

32

votes

7

answers

Is it possible to use Aggregate function in a Select statment without using Group By clause?

sql sql-server sql-server-2005 group-by aggregate-functions

asked 2011-06-24T11:38:15.643

47

votes

5

answers

Select SQL results grouped by weeks

sql-server t-sql sql-server-2005

asked 2011-06-20T10:57:24.937

65

votes

5

answers

Execute Stored Procedure from a Function

sql sql-server sql-server-2005 stored-procedures user-defined-functions

asked 2011-06-14T14:11:54.330

24

votes

6

answers

Why is my SQL Server ORDER BY slow despite the ordered column being indexed?

sql sql-server sql-server-2005 linq-to-entities

asked 2011-06-03T05:04:46.477

12

votes

4

answers

which datatype to use to store a mobile number

sql-server-2005 sql-server-2008 sql-server-express sqldatatypes

asked 2011-06-01T07:28:36.473

Questions tagged sql-server-2005