IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE

Опубликовано: 10 Ноябрь 2024
на канале: SQL University

472

This video is the beginning portion of a much larger video where I will cover how I used sql code to generate data for a puzzle book. In this particular video, I cover IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE, and certain errors that you will need to look out for.

Link to my SQL Courses on Udemy: https://www.udemy.com/course/sql-serv...

--------------------------------------------------------------------------
-- THIS WILL CRASH, IF THE TABLE DOES NOT EXIST
--------------------------------------------------------------------------

--IF EXISTS (SELECT * FROM A)
--DROP TABLE dbo.A

--------------------------------------------------------------------------
-- THIS WILL ALWAYS WORK
--------------------------------------------------------------------------

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'A' AND xtype = 'u')
DROP TABLE dbo.A

--------------------------------------------------------------------------

SELECT '1' A INTO A

INSERT INTO A SELECT '2'
INSERT INTO A SELECT '3'
INSERT INTO A SELECT '4'
INSERT INTO A SELECT '5'
INSERT INTO A SELECT '6'

SELECT * FROM A