操作
mysql
mssql
说明

赋值
delimiter //drop procedure if exists test//create procedure test()
begin
declare symbol1 char(6)default’000001′;
de[......]

操作
mysql
mssql
说明

重命名账号
rename user a01 to a02
企业管理器中,安全性-登录-选中登录名-右键属性-数据库访问-选择数据库-修改用户栏里面的名称
　

删除用户
drop user a02;
sp_dropuser test1[......]

简单事务
start
transaction;
delete from t;
select * FROM t;
rollback;
select * from t;
begin
transaction;
delete from t;
select * FROM t;
rollback;
select[......]

/* 触发器 */
/**************** mysql *********************/
– after insert
CREATE TRIGGER T_TRI AFTER INSERT ON TRI
FOR EACH ROW 
INSERT INTO TRI_L[......]

– 触发器
– MYSQL
CREATE TRIGGER T_TRI AFTER INSERT ON TRI
FOR EACH ROW 
INSERT INTO TRI_LOG(ID)
SELECT NEW.ID*2;
– MSSQL
CREATE TRIGGER[......]

/********************** 游标对比 **************************/
– MYSQL
DELIMITER $$
DROP PROCEDURE IF EXISTS `USECURSOR` $$
CREATE DEFINER=`ROOT`@`LOC[......]

输入输出
create procedure p_in_out( in n int, out t int ) begin   select n*n+2 into t;end
call p_in_out(3,@t);
select @t;
CREATE PROC P_IN_OUT
@N INT,
@T [......]

操作
mysql
mssql
说明

内联
select * from tablename a,t b where a.id=b.id;
一样
　

全文检索
select note_text from productnotes where match(note_text[......]

操作
mysql
mssql
说明

显示前三条
select * from tablename order by id limit 3;
select top 3 * from tablename order by id 
　

显示第2-5条
select * fro[......]