OBJECT_ID ('student',在SQL里

来源：学生作业帮编辑：神马作文网作业帮分类：综合作业时间：2024/11/18 23:56:40

OBJECT_ID ('student',在SQL里
IF OBJECT_ID ('student','U') IS NOT NULL U

OBJECT_ID ( '[ database_name . [ schema_name ] . | schema_name . ]
object_name' [ ,'object_type' ] )
Object type:
AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended stored procedure

OBJECT_ID ('student',在SQL里 IF OBJECT_ID(N'STUDENT') IS NOT NULL DROP TABLE STUDENT GO 这有一个"u"在单词"student"里 sql语句中!例如SELECT STUDENT.学号,student.姓名from sdb!student 用SQL语句如何列出各班平均成绩的前30%?班级在名为student的表上,各科成绩在名为score的表上. SQL里的DISTINCT什么意思在vfp里use student in 0是什么意思我在安装SQL的时候出现 ORACLE中between…and...是SQL语句中的吗?还是仅限于SQL*PLUS里? 实验中的SQL部分学生表:Student(Sno,Sname,Ssex,Sage,Sdept) 课程写SQL查询语句：两张表（Student(id,name,sex),score(id,english,chinese,m 怎么用SQL语句查询student表中年龄最小的前三名学生信息?