随笔分类 -  Database

摘要：有些边界条件没有处理好，但是基本能用。--#Inputparameters#--DECLARE@Valuetable(valuefloat);INSERTINTO@ValueVALUES(0.5),(1),(1.5),(7),(7.5); DECLARE@Xtable(xfloat);INSERTINTO@XVALUES(1),(2),(3),(4),(5),(6),(7); DECLARE@Ytable(yfloat);INSERTINTO@YVALUES(2),(4),(6),(8),(10),(12),(14); --#Core#--DECLARE@MinXfloat,@MaxXfloa 阅读全文

摘要：SELECT * FROM INFORMATION_SCHEMA.TABLES SELECT * FROM INFORMATION_SCHEMA.VIEWS SELECT * FROM INFORMATION_SCHEMA.COLUMNS SELECT * FROM INFORMATION_SCHEMA.ROUTINES 阅读全文