1. 使用“select * into 表2 from 表1”将表1的表结构及数据复制到表2,但不包含约束(如主码、外码等)
2.创建存储过程的语句实例
CREATE PROCEDURE Proc_UserExists (
@Name varchar(50),
@Password varchar(50))
AS
if exists(select * from Customer where Customer_RegName=@Name and Customer_PSW=@Password)
return 100
else
return -100
GO
问题八:
往表中批量插入记录
INSERT INTO Discount (Discount_BMID, Discount_CTypeID)
SELECT MBaseInfo.MBaseInfo_ID, CustomerType.CustomType_ID
FROM MBaseInfo CROSS JOIN CustomerType
WHERE (CustomerType.CustomType_ID = 1)
3.在数据库中的datetime类型是包括日期和时间的,我只想得到 日期(年月日),请问应该怎么做??
-->
convert(varchar(10),dtfield,120)