SQL Server/T-SQL/Table/Table Existence

Материал из SQL эксперт
Перейти к: навигация, поиск

Check table existence

   <source lang="sql">

25> 26> IF EXISTS(SELECT name FROM sys.tables 27> WHERE name = "T") 28> DROP TABLE T 29> GO 1> 2> CREATE TABLE T ( 3> c1 int, 4> c2 varchar(8000) 5> ) 6> GO 1> 2> DECLARE @v1 varchar(max) 3> 4> SET @v1 = REPLICATE("A",7999) + "B" 5> INSERT T VALUES (1, @v1) 6> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T 7> 8> SET @v1 = @v1 + "B" 9> INSERT T VALUES (2, @v1) 10> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T 11> GO (1 rows affected) Right 2 of c2

AB Msg 8152, Level 16, State 10, Server sqle\SQLEXPRESS, Line 9 String or binary data would be truncated. The statement has been terminated. (1 rows affected) Right 2 of c2

AB (1 rows affected) 1> 2> drop table t 3> GO 

      </source>
Источник — «http://sqle.ru/index.php?title=SQL_Server/T-SQL/Table/Table_Existence&oldid=5641»