随笔分类 -  Database

摘要：一个可以有助于提高command执行效率的方法：） 阅读全文

摘要：前一段时间在数据库中用了触发器后发现了一个问题：如果触发器中修改了某个表中的数据的话，那么用ExecuteNonQuery方法执行一个SQL语句的时候，返回的值将是触发器所影响的行数和sql语句本身所影响的行数的总和。这个问题，对于以往通过ExecuteNonQuery方法的返回值来得知当前SQL语句修改了当前表中几条记录的程序来说，就带来了些麻烦。 阅读全文

摘要：Tody, I created a table with three columns are of data type varchar(8000), and a warning was prompted out in the SQL Query Analyzer: “Warning: The table 'TestTable' has been created but its maximum ro... 阅读全文

摘要：Today, one of my colleagues demonstrated how to use the extended stored procedure xp_cmdshell to activate the windows Guest account and clear the password of that account, and thenadd theGuest accou... 阅读全文

摘要：In SQLServer, I tried to define a stored procedure to recursively invoke itself (See the following T-SQL statements). However, the maximum nesting level of recursion is 30 (Tested under SQL Server 200... 阅读全文

摘要：SQL Server has a built-inextended stored procedure,named sp_sdidebug, the permission towhich is necessary for a user tohave the capabilityof debugging stored procedures. To grant the permission, ... 阅读全文