Tag: sql-server

3169 How do I UPDATE from a SELECT in SQL Server? 2010-02-25T14:36:53.113

2388 Add a column with a default value to an existing table in SQL Server 2008-09-18T12:30:04.630

1637 How to check if a column exists in a SQL Server table? 2008-09-25T12:34:00.093

1577 How to concatenate text from multiple rows into a single text string in SQL server? 2008-10-11T23:49:59.470

1492 How to return only the Date from a SQL Server DateTime datatype 2008-09-22T03:31:33.277

1419 Inserting multiple rows in a single SQL query? 2009-01-17T05:55:54.150

1383 Insert results of a stored procedure into a temporary table 2009-03-17T10:45:26.080

1311 LEFT JOIN vs. LEFT OUTER JOIN in SQL Server 2009-01-02T08:30:10.297

1285 How do I perform an IF...THEN in an SQL SELECT? 2008-09-15T14:34:09.337

1234 Table Naming Dilemma: Singular vs. Plural Names 2008-12-03T18:09:30.710

1208 What is the difference between varchar and nvarchar? 2008-09-27T19:34:00.273

1182 How can I remove duplicate rows? 2008-08-20T21:51:29.780

1087 How can I do an UPDATE statement with JOIN in SQL? 2009-08-18T11:40:07.273

1073 Altering a column: null to not null 2009-03-27T13:24:29.177

966 Parameterize an SQL IN clause 2008-12-03T16:16:43.187

962 Get size of all tables in database 2011-10-25T16:14:34.197

950 How to Delete using INNER JOIN with SQL Server? 2013-05-10T11:38:21.043

928 Best way to get identity of inserted row? 2008-09-03T21:32:02.587

923 Check if table exists in SQL Server 2008-10-03T16:00:33.803

923 Find all tables containing column with specified name - MS SQL Server 2011-01-31T10:12:26.260

863 What do Clustered and Non clustered index actually mean? 2009-08-09T15:59:41.927

821 Difference between JOIN and INNER JOIN 2009-02-19T14:47:29.977

795 When should I use Cross Apply over Inner Join? 2009-07-16T17:42:21.513

782 SQL update from one Table to another based on a ID match 2008-10-22T07:14:03.313

764 How do I get list of all tables in a database using TSQL? 2008-10-06T17:53:21.950

758 How can foreign key constraints be temporarily disabled using T-SQL? 2008-10-01T18:33:43.630

730 How do I escape a single quote in SQL Server? 2009-10-19T01:18:22.493

716 Update a table using JOIN in SQL Server? 2009-10-21T22:48:11.393

713 Should I use != or <> for not equal in T-SQL? 2009-04-06T20:56:15.100

704 Function vs. Stored Procedure in SQL Server 2009-07-24T19:40:06.827

647 DateTime2 vs DateTime in SQL Server 2009-08-26T11:45:10.697

639 Count(*) vs Count(1) - SQL Server 2009-08-03T10:15:10.700

628 Search text in stored procedure in SQL Server 2013-02-05T09:30:39.060

618 SQL Server: How to Join to first row 2010-01-11T16:44:37.123

604 How can I list all foreign keys referencing a given table in SQL Server? 2009-01-27T12:17:59.193

576 How to drop a table if it exists in SQL Server? 2011-10-25T09:05:46.817

555 SQL exclude a column using SELECT * [except columnA] FROM tableA? 2009-04-08T09:15:28.297

549 SQL update query using joins 2009-06-11T18:49:33.633

541 How can I get column names from a table in SQL Server? 2009-06-28T14:05:50.193

540 What is the difference between char, nchar, varchar, and nvarchar in SQL Server? 2008-10-06T22:47:33.480

540 What is "with (nolock)" in SQL Server? 2009-03-26T17:13:35.640

533 Reset identity seed after deleting records in SQL Server 2014-02-17T08:51:48.637

530 Check if a temporary table exists and delete if it exists before creating a temporary table 2009-03-18T16:34:33.810

518 Multiple Indexes vs Multi-Column Indexes 2008-10-07T15:36:44.597

518 How do I create a unique constraint that also allows nulls? 2009-04-20T10:12:55.640

511 How do you clear the SQL Server transaction log? 2008-09-11T14:08:11.523

511 Rename column SQL Server 2008 2013-04-30T09:34:48.440

508 Solutions for INSERT OR UPDATE on SQL Server 2008-09-20T15:00:47.833

502 SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported 2011-03-30T14:45:11.100

498 What is the best way to auto-generate INSERT statements for a SQL Server table? 2009-06-11T17:42:28.067

496 SQL Server: Database stuck in "Restoring" state 2009-02-06T16:21:45.040

466 How do I insert multiple rows WITHOUT repeating the "INSERT INTO dbo.Blah" part of the statement? 2010-04-12T19:18:48.600

465 C# Equivalent of SQL Server DataTypes 2009-01-08T18:51:08.753

459 How do I split a string so I can access item x? 2008-08-05T18:15:47.727

456 Best approach to remove time part of datetime in SQL Server 2009-07-24T12:49:54.420

452 NOT IN vs NOT EXISTS 2008-10-06T02:19:05.033

444 How to insert a line break in a SQL Server VARCHAR/NVARCHAR string 2008-08-27T19:53:01.303

441 What is the difference between Integrated Security = True and Integrated Security = SSPI? 2009-08-04T20:15:32.283

410 What is the significance of 1/1/1753 in SQL Server? 2010-07-22T15:28:52.350

405 SQL Client for Mac OS X that works with MS SQL Server 2008-08-06T14:25:17.457

404 Select statement to find duplicates on certain fields 2010-12-13T22:30:06.130

399 Is there a Max function in SQL Server that takes two values like Math.Max in .NET? 2008-09-23T22:52:03.837

399 Select columns from result set of stored procedure 2008-10-16T16:44:42.447

393 Optimistic vs. Pessimistic locking 2008-09-24T19:29:05.390

390 The backup set holds a backup of a database other than the existing 2012-04-18T07:02:41.023

378 What is the best way to paginate results in SQL Server 2008-09-20T20:16:18.633

372 Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server? 2009-02-24T17:54:38.850

372 Auto increment primary key in SQL Server Management Studio 2012 2012-06-12T07:04:59.710

370 Why use the INCLUDE clause when creating an index? 2009-08-20T18:27:18.123

368 Cannot truncate table because it is being referenced by a FOREIGN KEY constraint? 2008-10-31T15:06:41.080

362 Adding an identity to an existing column 2009-06-26T13:41:21.333

360 How do you specify a different port number in SQL Management Studio? 2008-09-18T02:50:41.887

358 What's the difference between a temp table and table variable in SQL Server? 2008-08-26T12:27:30.337

356 How to remove a column from an existing table? 2011-04-11T19:19:04.123

352 Exporting data In SQL Server as INSERT INTO 2009-10-04T08:57:36.447

343 SQL Server Profiler - How to filter trace to only display events from one database? 2008-11-07T16:58:32.303

332 how can I Update top 100 records in sql server 2009-07-29T06:37:18.913

332 SQL Server SELECT into existing table 2010-11-04T21:49:42.100

330 Does a foreign key automatically create an index? 2009-05-07T18:06:18.063

328 How to select all records from one table that do not exist in another table? 2010-04-21T20:18:25.207

326 Sleep Command in T-SQL? 2009-03-20T03:39:52.320

325 How to replace a string in a SQL Server Table Column 2009-05-02T09:43:52.523

325 SQL Server query - Selecting COUNT(*) with DISTINCT 2009-10-05T18:19:16.153

320 Simulating group_concat MySQL function in Microsoft SQL Server 2005? 2009-01-16T18:14:52.570

318 How to rename a table in SQL Server? 2011-03-17T06:10:20.410

314 UPDATE and REPLACE part of a string 2013-06-28T12:55:07.367

312 Are there any disadvantages to always using nvarchar(MAX)? 2008-09-29T12:01:11.750

312 Get day of week in SQL 2005/2008 2009-07-10T17:49:14.213

312 How do I obtain a Query Execution Plan? 2011-09-09T09:37:21.923

311 I get a "An attempt was made to load a program with an incorrect format" error on a SQL Server replication project 2008-09-03T10:55:53.113

311 Conversion of a datetime2 data type to a datetime data type results out-of-range value 2009-08-26T00:39:55.497

309 SELECT INTO a table variable in T-SQL 2010-10-01T10:12:40.307

308 How to use GROUP BY to concatenate strings in SQL Server? 2008-11-07T19:08:00.703

306 Copy tables from one database to another in SQL Server 2008-10-09T15:20:58.170

303 SQL MAX of multiple columns? 2008-09-16T10:27:02.400

303 Is it possible to specify condition in Count()? 2009-09-09T14:28:52.637

303 How to set a default value for an existing column 2011-07-22T14:42:41.497

300 Nested select statement in SQL Server 2011-01-07T20:27:26.240

294 How do you change the datatype of a column in SQL Server? 2009-03-09T16:06:41.090