Alex Rivera | Logout

Questions tagged sql-server

1569 questions · page 2 of 32

Sort by: Newest Votes Active
8
votes
2
answers

SQL Server Create Table with Foreign Key

sql sql-server sql-server-2008
asked 2013-04-10T22:26:13.040
11
votes
4
answers

Inserting into table with a Default column value

sql sql-server
asked 2013-04-09T10:57:36.887
17
votes
11
answers

Data import from Excel to SQL Server failing to import all data

sql-server excel import
asked 2013-04-08T17:06:43.423
10
votes
3
answers

set xact_abort on and try catch together

sql-server try-catch xact-abort
asked 2013-04-05T16:59:09.530
34
votes
1
answers

Restore a SQL Server 2000 backup on SQL Server 2012

sql-server sql-server-2000 sql-server-2012
asked 2013-04-03T13:25:36.947
9
votes
2
answers

Is moving a constraint into a join more efficient than join and a where clause?

sql-server sql-server-2008 t-sql
asked 2013-04-02T21:37:09.860
27
votes
2
answers

Show datediff as seconds, milliseconds

sql sql-server t-sql datetime
asked 2013-03-27T13:56:01.500
59
votes
4
answers

T-SQL Conditional Order By

sql sql-server t-sql
asked 2013-03-25T18:00:42.143
10
votes
1
answers

SQL bigint hash to match c# int64 hash

c# sql-server hash bigint uint64
asked 2013-03-22T21:14:12.650
52
votes
6
answers

Using the WITH clause in an INSERT statement

sql sql-server common-table-expression with-clause
asked 2013-03-22T15:37:58.007
11
votes
2
answers

Merge multiple rows into one column using carriage return line feeds

sql-server
asked 2013-03-22T14:17:51.387
15
votes
8
answers

Show empty string when date field is 1/1/1900

sql-server datetime case
asked 2013-03-21T17:35:26.930
133
votes
24
answers

Connection to SQL Server Works Sometimes

sql-server ado.net
asked 2013-03-18T23:34:29.737
17
votes
4
answers

SQL Update after Joining Two Tables

sql-server
asked 2013-03-18T16:10:32.220
113
votes
4
answers

ListAGG in SQLSERVER

sql sql-server aggregate
asked 2013-03-18T13:14:09.050
19
votes
3
answers

SqlBulkCopy Multiple Tables Insert under single Transaction OR Bulk Insert Operation between Entity Framework and Classic Ado.net

c# sql-server entity-framework ado.net
asked 2013-03-18T06:52:07.927
8
votes
5
answers

MS SQL Server with Rails 4

sql-server ruby-on-rails-4
asked 2013-03-17T23:55:35.733
9
votes
1
answers

How to get the table name from a field in a join query with MSSQL? (mysql_field_table equivalent)

sql-server delphi ado tablename
asked 2013-03-15T11:56:31.953
16
votes
1
answers

Multiple condition in single IF statement

sql sql-server sql-server-2008
asked 2013-03-15T10:29:48.427
9
votes
7
answers

How to divide two values from the same column in SQL

sql sql-server sql-server-2008-r2
asked 2013-03-14T03:05:20.920
37
votes
4
answers

What is the optimal way to compare dates in Microsoft SQL server?

sql sql-server t-sql datetime query-optimization
asked 2013-03-11T17:20:42.050
18
votes
5
answers

Convert YYYYMMDD to DATE

sql sql-server sql-server-2008-r2
asked 2013-03-09T23:56:22.613
22
votes
9
answers

com.microsoft.sqlserver.jdbc.SQLServerDriver not found error

java sql-server eclipse jdbc
asked 2013-03-06T08:03:52.693
13
votes
5
answers

Can't get SQL Server to start or connect to my local database engine through SSMS

sql-server ssl-certificate sql-server-2012 ssms
asked 2013-03-05T17:44:12.717
14
votes
6
answers

Watch for a table new records in sql database

c# sql-server entity-framework .net-4.5
asked 2013-03-05T13:35:09.073
22
votes
2
answers

How to get a list of all extended properties for all objects

sql-server
asked 2013-03-05T10:22:28.157
8
votes
4
answers

Refine Search SQL with Custom Pagination

c# asp.net sql sql-server sql-server-2008
asked 2013-03-02T06:34:52.000
10
votes
4
answers

Language which compiles to t-sql

sql-server sql-server-2008 t-sql dsl
asked 2013-03-01T20:18:55.937
16
votes
2
answers

nvarchar concatenation / index / nvarchar(max) inexplicable behavior

sql-server t-sql sql-server-2012 string-concatenation nvarchar
asked 2013-02-28T14:55:16.060
27
votes
5
answers

Passing dynamic order by in stored procedure

sql sql-server sql-server-2008-r2
asked 2013-02-26T09:11:16.320
13
votes
6
answers

Using DATEADD with bigints

sql sql-server sql-server-2008
asked 2013-02-22T18:05:23.027
37
votes
5
answers

How to disable Constraints for all the tables and enable it?

sql-server sql-server-2008 foreign-keys constraints foreign-key-relationship
asked 2013-02-20T05:21:09.577
9
votes
6
answers

Linux based PHP install connecting to MsSQL Server

php sql-server linux
asked 2013-02-19T11:20:18.420
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
15
votes
6
answers

How to get running sum of a column in sql server

sql sql-server sql-server-2008 select
asked 2013-02-19T08:50:10.673
16
votes
1
answers

SQL Server specific types support for OrmLite

c# sql sql-server ormlite-servicestack
asked 2013-02-17T17:56:24.383
8
votes
1
answers

Order of execution in SQL Server variable assignment using SELECT

sql sql-server t-sql variable-assignment operator-precedence
asked 2013-02-14T20:58:28.590
11
votes
9
answers

SQL Performance, .Net Optimizations vs Best Practices

c# .net sql-server asp.net-mvc sql-server-2008
asked 2013-02-13T22:23:48.513
31
votes
6
answers

get basic SQL Server table structure information

sql sql-server
asked 2013-02-11T20:10:06.167
63
votes
3
answers

How to fix the embedded text qualifier issue while exporting data to CSV flat file?

sql-server ssis sql-server-2000 sql-server-2012
asked 2013-02-11T15:45:16.560
11
votes
3
answers

Detecting SQL Server Utilization with a query

sql sql-server database sql-server-2008 rdbms
asked 2013-02-08T15:48:35.270
13
votes
4
answers

Get All Except from SQL database using Entity Framework

c# sql-server linq entity-framework linq-to-entities
asked 2013-02-04T07:41:17.297
35
votes
2
answers

How to create a pivot query in sql server without aggregate function

sql sql-server t-sql
asked 2013-01-31T04:09:21.013
10
votes
3
answers

SQL - remove duplicates from left join

sql sql-server join
asked 2013-01-30T22:24:24.680
47
votes
2
answers

Retrieve column names and types of a stored procedure?

sql sql-server
asked 2013-01-29T02:38:55.213
12
votes
3
answers

WITH CHECK | NOCHECK OPTION FOR EXISTING DATA CHECK ENFORCEMENT IS IGNORED

sql-server visual-studio compiler-warnings static-analysis database-project
asked 2013-01-28T08:36:45.350
11
votes
1
answers

Passing a user-defined table type between SQL Server database

sql-server sql-server-2008 user-defined-types
asked 2013-01-24T15:21:16.923
23
votes
9
answers

"Cannot create an instance of OLE DB provider" error as Windows Authentication user

sql-server oracle-database oledb windows-authentication linked-server
asked 2013-01-24T11:14:12.573
11
votes
3
answers

how to limit and order by in MS SQL?

sql sql-server select
asked 2013-01-23T12:40:51.817
8
votes
2
answers

Cast integer column to varchar and compare with string

sql sql-server
asked 2013-01-22T11:54:31.440
← Prev page 2 of 32 Next →