![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
goushaoping04
交流中学习
展开
-
s1(java)项目实战(固定资产管理)(SQL_sever)
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = Nasset) DROP DATABASE [asset]GOCREATE DATABASE [asset] ON (NAME = Nasset_Data, FILENAME = ND:/41y01/project/asset_Data.MDF ,原创 2007-02-07 15:14:00 · 767 阅读 · 0 评论 -
len()/length()
SQL sever中select len(hello) 5select len( hello )(前后各空格一个) 6select len(hello )(后空格一个) 5select len( hello)(前空格一个) 6 javascriptvar a = new Array(5);a[0] = 1;a[2] = 2;alert(原创 2007-01-12 10:43:00 · 643 阅读 · 0 评论 -
基础java项目(8)Sql-Sever
CREATE TABLE [dbo].[MACapital] ( [Bh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [ckID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [style] [varchar] (50) COLLATE Chinese_PRC_CI_AS NO原创 2007-01-12 13:47:00 · 578 阅读 · 0 评论 -
sql:基础
--结束正在运行的事物use mastergoif(exists(select * from sysdatabases where name = student)) drop database studentgocreate database studentgouse studentgoif(exists(select * from sysobjects where name =stu原创 2007-04-10 14:20:00 · 461 阅读 · 0 评论 -
SQL:trigger
use mastergoif(exists (select * from sysdatabases where name = bank)) drop database bankgocreate database bankgouse bankgo--创建客户信息表create table customer( CID int identity(1001,1) , CName varchar(20)原创 2007-04-16 16:38:00 · 701 阅读 · 0 评论 -
SQL:利用存储过程实现分页
use mastergoif(exists(select * from sysdatabases where name = pageviewDemo )) drop database pageviewDemogocreate database pageviewDemogouse pageviewDemogoif(exists(select * from sysobjects where n原创 2007-04-17 16:59:00 · 505 阅读 · 0 评论 -
msdb被置疑修改语句.txt
USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE GO UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='msdb' Go sp_dboption 'msdb', 'single user', 'true' Go DBCC CHECKDB原创 2014-03-13 18:20:36 · 531 阅读 · 0 评论