Questions tagged [t-sql]

15

votes

4

answers

Determine MAX Decimal Scale Used on a Column

asked 2012-01-23T20:26:37.583

11

votes

3

answers

Automatically generate a user defined table type that matches an existing table

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

asked 2012-01-20T18:31:35.837

38

votes

1

answers

Is there a trick for using TSQLMonitor with a TSQLConnection that uses the new ODBC dbExpress driver?

t-sql delphi delphi-xe2 dbexpress

asked 2012-01-18T20:15:22.023

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

10

votes

2

answers

Building sql query with count() where count() is > 1

sql-server t-sql

asked 2012-01-05T22:26:36.453

19

votes

3

answers

How to check if a table variable is empty in SQL Server?

sql-server t-sql null table-variable

asked 2012-01-05T18:17:26.137

11

votes

3

answers

Using SELECT to obtain only fields with alphanumeric data (and certain punctuation) in SQL Server

sql-server t-sql

asked 2012-01-05T14:32:28.537

8

votes

4

answers

SQL: Error, Expression services limit reached?

sql sql-server-2008 t-sql

asked 2011-12-20T23:48:09.047

11

votes

6

answers

How do I extend this query to find valid combinations of three items?

sql t-sql

asked 2011-12-14T20:42:55.153

11

votes

5

answers

TSQL: Date BETWEEN Query - Ignoring Time

sql-server t-sql

asked 2011-12-12T17:06:51.563

51

votes

5

answers

Is "SET NOCOUNT OFF" necessary in a stored procedure?

sql sql-server t-sql nocount

asked 2011-11-21T19:13:24.890

70

votes

3

answers

SQL Server: check whether a Trigger is Enabled or Disabled?

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

asked 2011-11-15T13:18:35.800

9

votes

4

answers

How to "Implode" (de-normalize/concat) multiple columns into a single column?

sql-server t-sql concatenation

asked 2011-11-10T19:12:33.587

17

votes

3

answers

SQL String comparison speed 'like' vs 'patindex'

sql sql-server string performance t-sql

asked 2011-11-08T14:59:49.320

43

votes

6

answers

Adding a month to a date in T SQL

sql sql-server t-sql datetime

asked 2011-11-01T13:50:01.227

900

votes

15

answers

How to drop a table if it exists?

sql-server t-sql

asked 2011-10-25T09:05:46.817

21

votes

3

answers

What is the difference between CALL and EXEC in T-SQL?

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

asked 2011-10-21T07:42:41.193

360

votes

8

answers

SQL RANK() versus ROW_NUMBER()

sql sql-server t-sql

asked 2011-10-12T22:26:38.310

14

votes

1

answers

How to use a CTE in a left outer join?

sql t-sql sql-server-2008

asked 2011-10-10T01:15:20.220

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

9

votes

1

answers

SQL Server: Endless WHILE EXISTS loop

sql sql-server t-sql loops while-loop

asked 2011-10-03T07:54:47.257

11

votes

3

answers

Sql Server Delete and Merge performance

sql-server t-sql merge sql-delete

asked 2011-10-02T13:48:02.967

106

votes

2

answers

Maximum size of a varchar(max) variable

sql-server t-sql

asked 2011-09-30T13:52:54.643

12

votes

4

answers

How to calculate the number of "Tuesdays" between two dates in TSQL?

sql t-sql date

asked 2011-09-27T00:54:55.940

9

votes

4

answers

Select all if parameter is null in stored procedure

sql sql-server t-sql select notnull

asked 2011-09-22T11:23:56.237

42

votes

1

answers

Curly braces in T-SQL

sql sql-server t-sql syntax

asked 2011-09-15T09:16:11.400

46

votes

57

answers

How to get second-highest salary employees in a table

sql sql-server t-sql optimization

asked 2011-09-14T13:48:58.323

55

votes

2

answers

IF EXISTS in T-SQL

sql-server t-sql exists

asked 2011-09-07T00:36:31.583

43

votes

3

answers

SQL returns less results when using UNION?

sql-server t-sql union

asked 2011-09-02T18:49:27.230

30

votes

4

answers

Conditional Inner Join

sql sql-server t-sql join inner-join

asked 2011-09-01T09:43:54.657

10

votes

2

answers

What is VertiPaq and how it works

sql sql-server t-sql sql-server-2012

asked 2011-09-01T03:07:28.767

243

votes

4

answers

How do I escape a percentage sign in T-SQL?

sql-server t-sql

asked 2011-08-25T13:43:41.653

29

votes

7

answers

Getting SqlBulkCopy to honor column names

c# t-sql sqlbulkcopy

asked 2011-08-23T15:50:45.583

12

votes

2

answers

Enable foreign key with Check existing data

sql-server t-sql sql-server-2008

asked 2011-08-23T14:52:39.280

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

28

votes

3

answers

SQL Stored Procedure: If variable is not null, update statement

sql t-sql stored-procedures sql-update

asked 2011-08-18T17:58:12.130

13

votes

2

answers

Can we use group by and where condition with same fieldname

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

asked 2011-08-16T03:57:14.790

24

votes

6

answers

Group by every N records in T-SQL

sql sql-server t-sql

asked 2011-08-15T17:20:06.947

15

votes

8

answers

T-SQL average rounded to the closest integer

sql sql-server t-sql

asked 2011-08-15T10:33:31.823

104

votes

7

answers

Applying the MIN aggregate function to a BIT field

sql sql-server t-sql

asked 2011-08-09T14:24:28.873

9

votes

2

answers

TSQL Update DATETIME Minutes and Seconds

sql sql-server t-sql

asked 2011-08-09T12:54:57.243

13

votes

4

answers

Conversion failed when converting from a character string to uniqueidentifier error in SQL Server

sql sql-server t-sql

asked 2011-08-08T22:45:43.713

14

votes

5

answers

T-SQL, Insert into with MAX()+1 in subquery doesn't increment, alternatives?

sql-server t-sql sql-server-2008 batch-insert

asked 2011-08-08T15:42:56.273

14

votes

6

answers

how to use single quotations inside a transact sql statement

sql t-sql sql-server-2008

asked 2011-07-26T19:38:03.267

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

13

votes

2

answers

Backup/Restore the database using T-SQL (MSSQL2005, 2008)

t-sql

asked 2011-07-24T15:27:29.210

44

votes

5

answers

How to check if the USER is already created in the database or not in SQL?

sql t-sql

asked 2011-07-17T07:41:00.593

12

votes

1

answers

Joining against a CSV Column in SQL Server

sql sql-server t-sql

asked 2011-07-15T02:18:08.047

10

votes

2

answers

Is it possible to have multiple SQL instructions in a ADO.NET Command.CommandText property?

sql t-sql .net-3.5 ado.net command

asked 2011-07-14T16:09:09.873

Questions tagged t-sql