sqlquery1.sql

来自「使用Java实现在SQLserver中实现图片的存储」· SQL 代码 · 共 18 行

use master
if exists(select * from sysdatabases where name = 'Moftec')
drop database Moftec
create database Moftec
go

use Moftec
if exists(select * from sysobjects where name = 'gs_img')
drop table gs_img
create table gs_img
(
	lei varchar(20),
	year int,
	img image
)
go

select * from gs_img