CREATE FUNCTION f_catString(@id uniqueidentifier) RETURNS NVARCHAR(1000) AS BEGIN DECLARE @s NVARCHAR(1000) SET @s='' SELECT @s=@s+','+Name FROM StaffArchive INNER JOIN NoticeChecker ON StaffArchive.StaffID=NoticeChecker.CheckerID WHERE NoticeChecke
--新建视图 v_desk create view v_desk as select a.*, b.usingType_code, b.sOrderNo from t_desk a left join t_using_desk b on a.id = b.desk_id go --新建台号时向 t_using_desk 插入记录 --台号显示的时候查 v_desk --去掉表 t_dish_orderedNumber --t_order有些字段改为float --t_order_temp增加
代码如下: —涂聚文 Geovin Du DECLARE myid uniqueidentifier SET myid = NEWID() SELECT CONVERT(char(255), myid) AS ‘char’; GO –涂聚文 Geovin Du declare allstring char(255),AreaUid Uniqueidentifier set AreaUid=’37A1DA94-4AC6-4ED0-B96F-BA3FE6AEACC8′ set allstring=
