sql语句t_user带权限

最新推荐文章于 2024-03-22 11:39:18 发布

「已注销」

最新推荐文章于 2024-03-22 11:39:18 发布

阅读量351

点赞数

本文链接：https://blog.csdn.net/eds124/article/details/85872106

版权

--create database mydata;
--use mydata;
drop table t_user;
create table t_user(
	username nvarchar(10) not null default N'username',	unique(username),
	userpass nvarchar(10) not null default N'password',
	a1 bit not null default 0,
	a2 bit not null default 0,
	a3 bit not null default 0,
	a4 bit not null default 0,
	b1 bit not null default 0, 
	b2 bit not null default 0,
	b3 bit not null default 0,
	b4 bit not null default 0,
	c1 bit not null default 0,
	c2 bit not null default 0,
	c3 bit not null default 0,
	c4 bit not null default 0,
	d1 bit not null default 0,
	d2 bit not null default 0,
	d3 bit not null default 0,
	d4 bit not null default 0,
	usersmalldatetime smalldatetime not null default getdate(),
	p_userid uniqueidentifier not null default newid(),	primary key(p_userid)
);
insert into t_user (username, userpass) values (N'张三', N'zs123');
insert into t_user (username, userpass) values (N'李四', N'ls456');
insert into t_user (username) values (N'王五');
insert into t_user (userpass) values (N'666');
--预处理登陆select count(*) from t_user where username = @username and userpass = @userpass
select * from t_user order by username asc