摘要:
USE [database_test]GO--创建SEQUENCE CREATE SEQUENCE defaultSequenceAS INT --设置开始行START WITH 1 --自增量INCREMENT BY 1--删除SEQUENCE DROP SEQUENCE [DefaultSequ... 阅读全文
摘要:
DECLARE @CurCode NVARCHAR(36);DECLARE MyCur CURSOR FOR SELECT [ID] FROM [Table];OPEN MyCur;FETCH NEXT FROM MyCur INTO @CurCode;WHILE @@FETCH_STATUS=... 阅读全文