By Vincent


2008-10-03 16:00:33 8 Comments

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements.

When you Google for the answer, you get so many different answers. Is there an official/backward and forward compatible way of doing it?

Here are two possible ways of doing it. Which one among the two is the standard/best way of doing it?

First way:

IF EXISTS (SELECT 1 
           FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_TYPE='BASE TABLE' 
           AND TABLE_NAME='mytablename') 
   SELECT 1 AS res ELSE SELECT 0 AS res;

Second way:

IF OBJECT_ID (N'mytablename', N'U') IS NOT NULL 
   SELECT 1 AS res ELSE SELECT 0 AS res;

MySQL provides the simple

SHOW TABLES LIKE '%tablename%'; 

statement. I am looking for something similar.

26 comments

@Reza Jenabi 2019-09-15 05:47:39

You can use bellow code

IF (OBJECT_ID('TableName') IS NOT NULL )
BEGIN
  PRINT 'Table Exists'
END
ELSE
BEGIN 
  PRINT 'Table NOT Exists'
END

Or

IF (EXISTS (SELECT * FROM sys.tables WHERE NAME = 'TableName'))
BEGIN
  PRINT 'Table Exists'
END
ELSE
BEGIN 
  PRINT 'Table NOT Exists'
END

@BTE 2014-11-18 14:36:47

You can use this :

     IF OBJECT_ID (N'dbo.T', N'U') IS NOT NULL 
        BEGIN 
            print 'deleted table';
            drop table t 
        END
     else 
        begin 
            print 'table not found' 
        end

 Create table t (id int identity(1,1) not null, name varchar(30) not null, lastname varchar(25) null)
 insert into t( name, lastname) values('john','doe');
 insert into t( name, lastname) values('rose',NULL);

 Select * from t
1   john    doe
2   rose    NULL

 -- clean
 drop table t

@Mohamad Shahrestani 2019-07-03 10:03:12

IF EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE 
TABLE_CATALOG = 'Database Name' and
TABLE_NAME = 'Table Name' and 
TABLE_SCHEMA = 'Schema Name') -- Database and Schema name in where statement can be deleted

BEGIN
--TABLE EXISTS
END

ELSE BEGIN
--TABLE DOES NOT EXISTS
END

@S Krishna 2019-05-29 13:38:32

Run this query to check if the table exists in the database:

IF(SELECT TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'YourTableName') IS NOT NULL
PRINT 'Table Exists';

@Michael Quad 2019-03-22 05:31:33

I've had some problems either with selecting from INFORMATIONAL_SCHEME and OBJECT_ID. I don't know if it's an issue of ODBC driver or something.. Queries from SQL management studio, both, were okay.

Here is the solution:

SELECT COUNT(*) FROM <yourTableNameHere>

So, if the query fails, there is, probably, no such table in the database (or you don't have access permissions to it).

The check is done by comparing the value (integer in my case) returned by SQL executor which deals with ODBC driver..

if (sqlexec(conectionHandle, 'SELECT COUNT(*) FROM myTable') == -1) {
  // myTable doesn't exist..
}

@wscourge 2019-03-22 06:11:46

Fails with what output?

@Michael Quad 2019-03-22 06:22:20

@wscourge, SQL query failed or something alike. I just check the return value from the executor function.

@wscourge 2019-03-22 06:22:57

Add it to your answer

@Krishnaraj Barvathaya 2018-06-19 08:54:28

IF EXISTS (   SELECT * FROM   dbo.sysobjects WHERE  id = OBJECT_ID(N'dbo.TableName') AND OBJECTPROPERTY(id, N'IsUserTable') = 1 )
BEGIN
  SELECT * FROM dbo.TableName;
END
GO

@Mathieu Dierckx 2017-09-06 09:39:37


-- -- create procedure to check if a table exists


DELIMITER $$

DROP PROCEDURE IF EXISTS `checkIfTableExists`;

CREATE PROCEDURE checkIfTableExists(
    IN databaseName CHAR(255),
    IN tableName CHAR(255),
    OUT boolExistsOrNot CHAR(40)
)

  BEGIN
      SELECT count(*) INTO boolExistsOrNot FROM information_schema.TABLES
      WHERE (TABLE_SCHEMA = databaseName)
      AND (TABLE_NAME = tableName);
  END $$

DELIMITER ;

-- -- how to use : check if table migrations exists


 CALL checkIfTableExists('muDbName', 'migrations', @output);

@iliketocode 2016-06-22 17:18:48

Just wanted to mention one situation where it would probably be a little easier to use the OBJECT_ID method. The INFORMATION_SCHEMA views are objects under each database-

The information schema views are defined in a special schema named INFORMATION_SCHEMA. This schema is contained in each database.

https://msdn.microsoft.com/en-us/library/ms186778.aspx

Therefore all tables you access using

IF EXISTS (SELECT 1 
           FROM [database].INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_TYPE='BASE TABLE' 
           AND TABLE_NAME='mytablename') 
   SELECT 1 AS res ELSE SELECT 0 AS res;

will only reflect what is in [database]. If you wanted to check if tables in another database exist, without dynamically changing the [database] each time, OBJECT_ID will let you do this out of the box. Ex-

IF OBJECT_ID (N'db1.schema.table1', N'U') IS NOT NULL 
   SELECT 1 AS res ELSE SELECT 0 AS res;

works just as well as

IF OBJECT_ID (N'db2.schema.table1', N'U') IS NOT NULL 
   SELECT 1 AS res ELSE SELECT 0 AS res;

SQL SERVER 2016 Edit:

Starting with 2016, Microsoft simplified the ability to check for non-existent objects prior to dropping, by adding the if exists keywords to drop statements. For example,

drop table if exists mytablename

will do the same thing as OBJECT_ID / INFORMATION_SCHEMA wrappers, in 1 line of code.

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2015/11/03/drop-if-exists-new-thing-in-sql-server-2016/

@sansalk 2013-11-22 09:59:29

IF OBJECT_ID('mytablename') IS NOT NULL 

@Bob King 2008-10-03 16:05:16

We always use the OBJECT_ID style for as long as I remember

IF OBJECT_ID('*objectName*', 'U') IS NOT NULL 

@Joe Pineda 2008-10-03 19:39:53

I believe this would be fast, though not very portable. Information schema views are guaranteed to exist on any DBRMS that supports the standard. Furthermore, plain OBJECT_ID doesn't guarantee the object's a table.

@Apeiron 2011-09-07 18:06:41

Thanks Joe, I was wondering why you would use OBJECT_ID vs INFORMATION_SCHEMA.TABLES vs sys.tables. Pointing out that INFORMATION_SCHEMA is part of a standard pretty much answers that question. BTW it's funny, one of our Database experts that I was going to ask this question has the same last name as you, must be a good last name for databases.

@Allon Guralnek 2011-10-04 16:41:17

@JoePineda: Then you case use OBJECT_ID('TableName', 'U') to guarantee the object is a table.

@defines 2012-05-15 14:42:01

@AllonGuralnek so, instead of following a simple and portable standard, add an extra piece of cryptic info?

@Allon Guralnek 2012-05-15 16:00:53

@DustinFineout: The question was tagged tsql, so portability doesn't apply as much. In general I've encountered very few truly portable codebases and if succinctness is valued then it sure beats writing that IF EXISTS query from the accepted answer over and over. Plus, everything is cryptic until you read the documentation, especially in T-SQL (or any other variant, really).

@Martin Smith 2014-12-27 13:31:33

@AllonGuralnek not to mention that I doubt the IF EXISTS BEGIN...END is portable anyway.

@Alternator 2015-03-19 21:01:31

@MartinSmith You're correct, I copy pasted the exists statement into Oracle and it didn't work.Personally a 1 line if statement is always going to be my preference...

@Knickerless-Noggins 2016-12-07 13:32:06

This is my preferred answer, and if you can make a function with a more readable name if you're worried you might forget what IF OBJECT_ID('*objectName*', 'U') IS NOT NULL does

@dipi evil 2015-04-16 13:42:06

In SQL Server 2000 you can try:

IF EXISTS(SELECT 1 FROM sysobjects WHERE type = 'U' and name = 'MYTABLENAME')
BEGIN
   SELECT 1 AS 'res' 
END

@Marcello Miorelli 2015-01-23 17:40:57

Just adding here, for the benefit of developers and fellow DBAs

a script that receives @Tablename as a parameter

(which may or may not contain the schemaname) and returns the info below if the schema.table exists:

the_name                object_id   the_schema  the_table       the_type
[Facts].[FactBackOrder] 758293761   Facts       FactBackOrder   Table

I produced this script to be used inside other scripts every time I need to test whether or not a table or view exists, and when it does, get its object_id to be used for other purposes.

It raises an error when either you passed an empty string, wrong schema name or wrong table name.

this could be inside a procedure and return -1 for example.

As an example, I have a table called "Facts.FactBackOrder" in one of my Data Warehouse databases.

This is how I achieved this:

PRINT 'THE SERVER IS ' + @@SERVERNAME
--select db_name()
PRINT 'THE DATABASE IS ' + db_NAME() 
PRINT ''
GO

SET NOCOUNT ON
GO

--===================================================================================
-- @TableName is the parameter
-- the object we want to deal with (it might be an indexed view or a table)
-- the schema might or might not be specified
-- when not specified it is DBO
--===================================================================================

DECLARE @TableName SYSNAME

SELECT @TableName = 'Facts.FactBackOrder'
--===================================================================================
--===================================================================================
DECLARE @Schema SYSNAME
DECLARE @I INT
DECLARE @Z INT 

SELECT @TableName = LTRIM(RTRIM(@TableName))
SELECT @Z = LEN(@TableName)

IF (@Z = 0) BEGIN

            RAISERROR('Invalid @Tablename passed.',16,1)

END 

SELECT @I = CHARINDEX('.',@TableName )
--SELECT @TableName ,@I

IF @I > 0 BEGIN

        --===================================================================================
        -- a schema and table name have been passed
        -- example Facts.FactBackOrder 
        -- @Schema = Fact
        -- @TableName = FactBackOrder
        --===================================================================================

   SELECT @Schema    = SUBSTRING(@TABLENAME,1,@I-1)
   SELECT @TableName = SUBSTRING(@TABLENAME,@I+1,@[email protected])



END
ELSE BEGIN

        --===================================================================================
        -- just a table name have been passed
        -- so the schema will be dbo
        -- example Orders
        -- @Schema = dbo
        -- @TableName = Orders
        --===================================================================================

   SELECT @Schema    = 'DBO'     


END

        --===================================================================================
        -- Check whether the @SchemaName is valid in the current database
        --===================================================================================

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.SCHEMATA K WHERE K.[SCHEMA_NAME] = @Schema ) BEGIN

            RAISERROR('Invalid Schema Name.',16,1)

END 

--SELECT @Schema  as [@Schema]
--      ,@TableName as [@TableName]


DECLARE @R1 TABLE (

   THE_NAME SYSNAME
  ,THE_SCHEMA SYSNAME
  ,THE_TABLE SYSNAME
  ,OBJECT_ID INT
  ,THE_TYPE SYSNAME
  ,PRIMARY KEY CLUSTERED (THE_SCHEMA,THE_NAME)

)

;WITH RADHE_01 AS (
SELECT QUOTENAME(SCHEMA_NAME(O.schema_id)) + '.' + QUOTENAME(O.NAME) AS [the_name]
      ,the_schema=SCHEMA_NAME(O.schema_id)
      ,the_table=O.NAME
      ,object_id =o.object_id 
      ,[the_type]= CASE WHEN O.TYPE = 'U' THEN 'Table' ELSE 'View' END 
from sys.objects O
where O.is_ms_shipped = 0
AND O.TYPE IN ('U','V')
)
INSERT INTO @R1 (
   THE_NAME 
  ,THE_SCHEMA 
  ,THE_TABLE 
  ,OBJECT_ID
  ,THE_TYPE 
)
SELECT  the_name
       ,the_schema
       ,the_table
       ,object_id
       ,the_type
FROM RADHE_01
WHERE the_schema = @Schema 
  AND the_table  = @TableName

IF (@@ROWCOUNT = 0) BEGIN 

             RAISERROR('Invalid Table Name.',16,1)

END 
ELSE BEGIN

    SELECT     THE_NAME 
              ,THE_SCHEMA 
              ,THE_TABLE 
              ,OBJECT_ID
              ,THE_TYPE 

    FROM @R1

END 

@deroby 2016-12-05 10:52:01

There are a lot of assumptions in your script. For instance, I could easily craete a table named dbo.[hello.world ] and the script would not find it for multiple reasons. That said, it's unlikely anyone would want to create such a table, but still. Anyway, your THE_NAME column is defined as sysname', yet you try to squeeze 2 sysname` columns and a dot (.), all surrounded in square brackets in there... that one is bound to fail someday!

@Marcello Miorelli 2016-12-05 11:24:23

@deroby I agree sysname is not the best data type to be used, yet the script has been running for a long time without any errors, I would spend time on it only if I find a reasonable situation where it does not work. Even better, you take this code, improve it and post it here as an answer and I will test it, if it works I will upvote your answer.

@BrainCoder 2014-12-22 12:01:58

Please see the below approaches,

Approach 1: Using INFORMATION_SCHEMA.TABLES view

We can write a query like below to check if a Customers Table exists in the current database.

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'Customers')
BEGIN
    PRINT 'Table Exists'
END

Approach 2: Using OBJECT_ID() function

We can use OBJECT_ID() function like below to check if a Customers Table exists in the current database.

IF OBJECT_ID(N'dbo.Customers', N'U') IS NOT NULL
BEGIN
    PRINT 'Table Exists'
END

Approach 3: Using sys.Objects Catalog View

We can use the Sys.Objects catalog view to check the existence of the Table as shown below:

IF EXISTS(SELECT 1 FROM sys.Objects WHERE  Object_id = OBJECT_ID(N'dbo.Customers') AND Type = N'U')
BEGIN
   PRINT 'Table Exists'
END

Approach 4: Using sys.Tables Catalog View

We can use the Sys.Tables catalog view to check the existence of the Table as shown below:

 IF EXISTS(SELECT 1 FROM sys.Tables WHERE  Name = N'Customers' AND Type = N'U')
 BEGIN
      PRINT 'Table Exists'
 END

Approach 5: Avoid Using sys.sysobjects System table

We should avoid using sys.sysobjects System Table directly, direct access to it will be deprecated in some future versions of the Sql Server. As per Microsoft BOL link, Microsoft is suggesting to use the catalog views sys.objects/sys.tables instead of sys.sysobjects system table directly.

  IF EXISTS(SELECT name FROM sys.sysobjects WHERE Name = N'Customers' AND xtype = N'U')
  BEGIN
     PRINT 'Table Exists'
  END

referred from: http://sqlhints.com/2014/04/13/how-to-check-if-a-table-exists-in-sql-server/

@user3651072 2014-08-18 22:08:21

If this is to be the 'ultimate' discussion, then it should be noted that Larry Leonard's script can query a remote server as well if the servers are linked.

if exists (select * from REMOTE_SERVER.MyOtherDatabase.sys.tables where name = 'MyTable')
    print 'Exists'

@EWit 2014-08-18 22:34:46

Perhaps it's more suited to add this as a comment to Leonards answer or maybe as an edit?

@phil294 2014-07-23 13:55:00

Something important to know for anybody who hasn't found their solution yet: SQL server != MYSQL. If you want to do it with MYSQL, it is quite simple

    $sql = "SELECT 1 FROM `db_name`.`table_name` LIMIT 1;";
    $result = mysql_query($sql);
    if( $result == false )
        echo "table DOES NOT EXIST";
    else
        echo "table exists";

Posting this here because it's the top hit at Google.

@mordack550 2014-07-23 14:03:55

-1 because the OP is precisely asking for a SQL Server solution to the problem, not the MySQL one. He wrote about MySQL because he knew the solution on that DBMS and he wanted the same result on SQL Server. Also your answer is not even a MySQL query, but a PHP code that works with MySQL.

@Mark 2014-08-01 17:25:27

@mordack550, I agree with Blauhirn. He's right. This is the top hit on Google for finding out if a table exists in SQL. He's intentions are good and his information is helpful. +1

@psaxton 2016-03-02 20:51:18

It is unfortunate that Microsoft has a habit of trying to Embrace/Extend/Extinguish common standards and patterns like SQL. I really wish they had given their implementation of a SQL server a proper name so people could identify references specific to their product unambiguously.

@MarceloMadnezz 2014-02-10 18:54:51

select name from SysObjects where xType='U' and name like '%xxx%' order by name

@Maslow 2014-02-07 18:48:06

If anyone is trying to do this same thing in linq to sql (or especially linqpad) turn on option to include system tables and views and do this code:

let oSchema = sys.Schemas.FirstOrDefault(s=>s.Name==a.schema )
where oSchema !=null
let o=oSchema!=null?sys.Objects.FirstOrDefault (o => o.Name==a.item && o.Schema_id==oSchema.Schema_id):null
where o!=null

given that you have an object with the name in a property called item, and the schema in a property called schema where the source variable name is a

@dilip kumar singh 2011-04-07 10:39:34

IF EXISTS 
(
    SELECT   * 
    FROM     sys.objects 
    WHERE    object_id = OBJECT_ID(N'[dbo].[Mapping_APCToFANavigator]') 
             AND 
             type in (N'U')
)
BEGIN

    -- Do whatever you need to here.

END

Here in the above code, the table name is Mapping_APCToFANavigator.

@marc_s 2011-06-29 13:41:22

If you post code, XML or data samples, please highlight those lines in the text editor and click on the "code samples" button ( { } ) on the editor toolbar to nicely format and syntax highlight it!

@Olivier Jacot-Descombes 2014-02-04 18:04:16

Note that the access to system tables might be discontinued in future version of SQL Server. Use Schema views instead.

@Moccassin 2013-10-24 11:04:32

IF EXISTS 
(
    SELECT  * 

    FROM    INFORMATION_SCHEMA.TABLES 

    WHERE   TABLE_SCHEMA = 'PutSchemaHere'     
            AND  
            TABLE_NAME   = 'PutTableNameHere'
)

@sumon 2013-04-10 18:32:06

consider in one database you have a table t1. you want to run script on other Database like - if t1 exist then do nothing else create t1. To do this open visual studio and do the following:

Right click on t1, then Script table as, then DROP and Create To, then New Query Editor

you will find your desired query. But before executing that script don't forget to comment out the drop statement in the query as you don't want to create new one if there is already one.

Thanks

@Ivaylo Slavov 2015-04-21 21:12:00

In SSMS 2012 it no longer performs the if-exists check, if it ever did it (I do not remember how former versions generated the above script). Maybe you are mistaken with the way other db tools are scripting table objects?

@Seann Alexander 2018-05-23 21:52:11

SSMS will perform the if-exists check if you ask it to. Tools > Options > SQL Server Object Explorer > Scripting > "Object scripting options": "Check for object existence" = True

@akmad 2008-10-03 16:17:35

For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version.

To check if a table exists use:

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

@Nicholas Piasecki 2009-09-23 13:36:26

Works great! In T-SQL (in response to the original poster), though, it's TABLE_SCHEMA, not SCHEMA_NAME. Thanks for the tip.

@haridsv 2010-03-18 21:40:22

How would you avoid having schema_name in the where clause? The benefit of using object_id() approach is that it defaults to the current schema.

@akmad 2010-03-22 16:38:14

Given that an object name alone (that is, without a schema) is not guaranteed to be unique, there is no 100% failsafe way to do this. If you are working with a DB that has no naming conflicts across schemas then simply omitting the "TABLE_SCHEMA = 'TheSchema'" will work just fine.

@Pierre-Alain Vigeant 2010-09-27 14:44:08

To check for a temporary table, we have to query the tempdb database and use a LIKE operator for the table name SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TheSchema' AND TABLE_NAME LIKE '#TheTable%'

@Rich Rousseau 2012-09-04 14:56:49

The above tempdb INFORMATION_SCHEMA query will return rows for temp tables created on any connection, not just your current connection. This could result in an "if exists, then drop" statement failing.

@Rich Rousseau 2012-09-04 15:09:30

A response below that uses the OBJECT_ID function does operate correctly regarding per connection temp tables - stackoverflow.com/a/2155299/16147

@Marc K 2014-01-09 10:49:37

This is all well, but what if in your --Do Stuff you want to select from TheTable? Then the query will fail. So your --Do Stuff needs to be dynamic?

@akmad 2014-01-10 13:47:51

@MarcK Why would the select fail? You have simply checked that the table exists before doing something with it. There is no table locking or anything like that occurring here.

@Marc K 2014-01-13 06:35:11

@akmad SQL query compiler will check for the table before running the query and will fail before even starting.

@Elliot Chen 2014-02-13 21:06:57

This method has problem if the table does exist but has no data.

@Guru Josh 2015-10-27 02:57:41

The TABLE_SCHEMA field in the database I am working with is exclusively populated with "dbo". This does not work for me.

@John 2015-11-10 07:58:16

This answer doesn't care if it's a view or a table. If you need to know if it's really a table you also need to check the column TABLE_TYPE.

@Govind Rai 2016-02-10 05:22:42

FYI: A common mistake made when performing these checks - what I usually see [not just] beginners do is check existence of a table by querying the records in the table (i.e. IF (EXISTS (SELECT * FROM TheTable)) BEGIN --Do Stuff END While the answer query will return correct results 100% of the time, the query above will return a false negative if your table is empty (has 0 records) and should be avoided at all costs! Just another reason why this is a superior query/why you should always query INFORMATION_SCHEMA.TABLES view when checking table existence.

@Petar Vasilev 2017-11-06 17:34:11

What is "TABLE_SCHEMA"?

@Jeff Humphreys 2019-10-08 19:56:25

This may lock the schema dictionary, which sys.table queries do not.

@Larry Leonard 2012-03-15 17:19:42

Looking for a table on a different database:

if exists (select * from MyOtherDatabase.sys.tables where name = 'MyTable')
    print 'Exists'

@dko 2011-01-21 15:37:37

I know it is an old question but I have found this possibility if you plan to call it often.

create procedure Table_Exists
@tbl varchar(50)
as
return (select count(*) from sysobjects where type = 'U' and name = @tbl)
go

@Martin Smith 2011-11-23 23:05:57

-1. Pointless having a procedure for this as it is as much code to call and consume the return as simply to do the select. Should use sysname datatype not varchar(50). Shouldn't use deprecated sysobjects view and takes no account of schema.

@James Bloomer 2010-01-28 14:50:03

Also note that if for any reason you need to check for a temporary table you can do this:

if OBJECT_ID('tempdb..#test') is not null
 --- temp table exists

@Rich Rousseau 2012-09-04 14:58:06

Using this method seems to respect the per connection nature of temp tables. The earlier posted INFORMATION_SCHEMA query will return rows regardless of the connection that created the table.

@Even Mien 2009-10-21 14:58:15

If you need to work on different databases:

DECLARE @Catalog VARCHAR(255)
SET @Catalog = 'MyDatabase'

DECLARE @Schema VARCHAR(255)
SET @Schema = 'dbo'

DECLARE @Table VARCHAR(255)
SET @Table = 'MyTable'

IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES   
    WHERE TABLE_CATALOG = @Catalog 
      AND TABLE_SCHEMA = @Schema 
      AND TABLE_NAME = @Table))
BEGIN
   --do stuff
END

@quillbreaker 2013-07-09 22:14:32

Are you sure? Information schema on my 2005 box only returns the current catalog.

@Vinko Vrsalovic 2008-10-03 16:03:54

Using the Information Schema is the SQL Standard way to do it, so it should be used by all databases that support it.

@underscore_d 2016-02-29 14:05:41

This should have been a comment.

@rory.ap 2016-03-07 18:09:59

This answer needs improvement.

Related Questions

Sponsored Content

39 Answered Questions

29 Answered Questions

41 Answered Questions

[SOLVED] How to return only the Date from a SQL Server DateTime datatype

30 Answered Questions

4 Answered Questions

[SOLVED] Inserting multiple rows in a single SQL query?

33 Answered Questions

[SOLVED] How do I UPDATE from a SELECT in SQL Server?

12 Answered Questions

[SOLVED] LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

24 Answered Questions

[SOLVED] Find all tables containing column with specified name - MS SQL Server

16 Answered Questions

[SOLVED] How can I do an UPDATE statement with JOIN in SQL?

10 Answered Questions

[SOLVED] SQL Server: How to Join to first row

Sponsored Content