Questions tagged [t-sql]

8

votes

4

answers

How to convert Float to Varchar in SQL

sql sql-server t-sql

asked 2013-07-20T09:54:44.127

9

votes

2

answers

ANY or IF EXISTS in T-SQL

sql t-sql

asked 2013-06-27T06:25:06.237

44

votes

6

answers

Check if a column contains text using SQL

sql sql-server t-sql

asked 2013-06-26T14:00:59.880

27

votes

4

answers

Replacing NULL and empty string within Select statement

sql t-sql

asked 2013-06-21T21:47:29.907

9

votes

3

answers

Error 20012 (severity 2):Server name not found in configuration files

t-sql command-line

asked 2013-06-12T11:16:00.520

9

votes

2

answers

while loop inside a trigger to loop through all the columns of table in sql

sql-server t-sql triggers

asked 2013-06-11T18:16:47.290

11

votes

3

answers

remote procedure call (RPC) protocol stream is incorrect

c# .net wpf entity-framework t-sql

asked 2013-06-06T13:38:13.733

15

votes

4

answers

sql rounding up to a multiple of 5?

sql sql-server t-sql

asked 2013-05-16T16:15:46.753

27

votes

4

answers

Getting count of records in child table using select statement

sql sql-server sql-server-2008 t-sql sql-server-2008-r2

asked 2013-05-15T08:44:38.510

16

votes

1

answers

Convert SQL geography to C#

c# sql-server t-sql sqlgeography

asked 2013-05-09T07:10:27.223

161

votes

2

answers

Is there a ternary conditional operator in T-SQL?

sql-server t-sql

asked 2013-04-25T08:21:08.137

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

31

votes

2

answers

SQL Update - Multiple Columns

sql t-sql sql-server-2012

asked 2013-04-08T14:16:33.120

12

votes

4

answers

Combine consecutive date ranges

sql t-sql sql-server-2008-r2

asked 2013-04-03T09:17:08.910

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

8

votes

1

answers

How to find which OLE provider is available for SQL Server?

sql sql-server-2008 t-sql oledb linked-server

asked 2013-03-15T14:19:44.193

11

votes

2

answers

How to create a scheduled job in SQL server 2008 via T-SQL?

sql t-sql jobs schedule

asked 2013-03-13T17:10:27.757

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

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

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

10

votes

3

answers

Do indexes count towards the 10gb database size limit on SQL Server Express?

sql t-sql indexing sql-server-express

asked 2013-02-06T22:22:11.853

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

48

votes

11

answers

Preserving ORDER BY in SELECT INTO

sql-server t-sql sql-order-by select-into

asked 2013-01-20T13:18:00.223

42

votes

5

answers

Want to learn more on NTILE()

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

asked 2013-01-16T09:43:10.530

87

votes

3

answers

Remove certain characters from a string

sql-server t-sql

asked 2013-01-14T13:18:15.987

10

votes

5

answers

SQL group by select

sql sql-server t-sql

asked 2013-01-01T14:12:56.353

15

votes

3

answers

SQL select multiple rows in one column

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

asked 2012-12-28T06:01:16.320

16

votes

4

answers

SQL Server datatypes nvarchar and varchar are incompatible error

sql sql-server t-sql

asked 2012-12-27T13:20:13.437

10

votes

4

answers

last friday of a given month in sql server

sql-server t-sql sql-date-functions

asked 2012-12-21T10:45:27.677

13

votes

1

answers

syntax error in CROSS APPLY

sql-server t-sql dmv

asked 2012-12-17T21:33:29.883

44

votes

4

answers

SQL Server 2008 thousands separator for a column

sql sql-server database sql-server-2008 t-sql

asked 2012-12-13T10:01:24.017

11

votes

3

answers

TSQL retrieve all records in current month/year

sql-server t-sql datetime

asked 2012-12-05T16:27:04.527

21

votes

3

answers

SQL query to split column data into rows

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

asked 2012-11-23T10:50:05.067

25

votes

2

answers

CREATE TRIGGER must be the first statement in a batch

sql-server t-sql triggers

asked 2012-11-13T23:12:52.173

81

votes

7

answers

How to send email from SQL Server?

sql sql-server t-sql sp-send-dbmail

asked 2012-11-09T01:35:16.643

12

votes

3

answers

Adventure Works Explanation

sql sql-server t-sql adventureworks

asked 2012-11-04T16:42:28.823

27

votes

3

answers

Get integer part of number

t-sql

asked 2012-10-31T02:37:53.440

8

votes

1

answers

T-SQL CTE materializing techniques not working on SQL Server 2012

sql-server t-sql sql-server-2012 common-table-expression materialized

asked 2012-10-26T15:38:20.210

11

votes

6

answers

Invalid length parameter passed to the LEFT or SUBSTRING function

t-sql

asked 2012-10-23T20:48:08.173

17

votes

4

answers

SQL string manipulation [Get all text left of '(']

sql sql-server t-sql

asked 2012-10-15T16:21:34.737

14

votes

2

answers

Insert multiple rows of default values into a table

sql-server t-sql

asked 2012-10-12T16:32:55.907

8

votes

4

answers

How to avoid namespace in child nodes using FOR XML PATH?

t-sql namespaces for-xml-path

asked 2012-10-10T15:56:49.683

15

votes

3

answers

How would you add a column that only has a set choice of values?

sql sql-server t-sql

asked 2012-10-07T06:32:49.993

10

votes

1

answers

T SQL: How get all minutes from Time type

t-sql

asked 2012-10-02T11:27:45.663

17

votes

6

answers

How to select only numeric values

sql sql-server t-sql sql-server-2000

asked 2012-09-30T06:18:12.120

11

votes

4

answers

Selecting Values From a table as Column Headers

sql sql-server sql-server-2008 t-sql pivot

asked 2012-09-27T10:46:28.530

19

votes

3

answers

SQL Join on Table A value within Table B range

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

asked 2012-09-26T14:34:40.860

Questions tagged t-sql