摘要：C:\mysql\bin>mysql-uroot-pEnterpassword:****WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis4Serverversion:5.0.51b-community-ntMySQLCommunityEdition(GPL)Type'help;'or'\h'forhelp.Type'\c'toclearthebuffer.mysql>showdatabases;+--------------------+|Dat 阅读全文

摘要：CREATEPROCEDUREdropTable@tableNamevarchar(40)ASdeclarecurcursorread_onlyforselectdistincttable_namefrominformation_schema.columnswheretable_namelike@tableNamedeclare@namevarchar(40),@sqlvarchar(1000)opencurfetchnextfromcurinto@namewhile(@@fetch_status=0)beginset@sql='droptable'+@nameexec(@sq 阅读全文

摘要：exec sp_MSforeachtable 'cranedata'exec sp_spaceused 'cranedata20101227'exec sp_MSforeachtable "exec sp_spaceused '?'" 阅读全文

摘要：string sql = "update tb_type set typename=@typename,describe2=@describe2 where id=@id"; OleDbParameter[] parameters = { new OleDbParameter("@typename", OleDbType.VarChar,50), new OleDbParameter("@des... 阅读全文

摘要：代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/----触发器createtriggertg_cranedataondbo.CraneDataforinsertasbegindeclare@idint,@craneidint,@acttimedatet... 阅读全文

摘要：Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16 Select CONVERT(varchar(100), GE... 阅读全文

摘要：代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/----事务SETTRANSACTIONISOLATIONLEVELREPEATABLEREADbegintransaction--insertdeleteupdateselectif@@error&l... 阅读全文