摘要:
function GetRequest() { var url = location.search; //获取url中"?"符后的字串 var theRequest = new Object(); if (url.indexOf("?") != -1) { var str = url.substr( 阅读全文
摘要:
Create PROCEDURE [dbo].[P_SYSTEM_FindData] ( @value VARCHAR(1024) ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering 阅读全文
摘要:
删除所有的视图 use fkbmvcultimate GO declare @sql varchar(8000) while (select count(*) from sysobjects where type='V')>0 begin SELECT @sql='drop view ' + nam 阅读全文
摘要:
游标实例 DECLARE @LegalUnitID as varchar(100), @ViewID as varchar(100) declare my_cursor cursor for select LegalUnitID,ViewID from T_TEMPLATE_VIEW group b 阅读全文
摘要:
新增字段IsCheckInvoice Alter table T_LegalUnit add IsCheckInvoice bit UPDATE T_LegalUniT SET IsCheckInvoice=1 WHERE LegalUnitID='000010' SELECT *FROM T_Le 阅读全文
摘要:
http://www.cnblogs.com/qcq0703/p/9099199.html select * from user select * from user where 1=1 --这两个 句子执行结果是一样一样的。而sql注入就是利用了这个原理 来进行破坏。比如: select * fr 阅读全文