自己對一個典型的formatFile格式進行了注釋,方便以後查看。<?xml version="1.0"?><BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <!--This node is used for SSIS to locate recor
// from http://www.sommarskog.se/dynamic_sql.html#sp_executesqlong// not tested yet.There is a limitation with sp_executesql on SQL Server, since you cannot use longer SQL strings than 4000 characters. If you want to use sp_executesql despite you
Simplily say, If you have a CI(clustered index) which is composed by 4 columns, Which one of the 4 would you put into the first one in the CI? and Which would be put into the last? Or you shouldn't consider this question at all, just put them
1.The most common oneINSERT INTO V1 (col1, col2) VALUES ('Row 1',1);2.Sometimes you just need to insert a default rowINSERT INTO T1 DEFAULT VALUES; 3.What if you have a Identity column, and you still want to insert a row with you own value of that
Sometimes you want to detect whether a service is running, and if not, you want to run it. Here is what you can do for the Sql Server Agent Service:EXEC master.dbo.xp_ServiceControl 'QUERYSTATE','SQLServerAgent'EXEC master.dbo.xp_ServiceControl
When we look into a query plan, in a Seek Operation Node, we could can find 2 Properties: Predicate and Seek Predicate.Before I was really not clear about them, and today I read the bellow info: SQL Server 2005 Books Online (BOL) explains the
1.When you use stored procedures with only static SQL, users do not need direct permissions to access the tables, only permissions to execute the stored procedures, and thus you can use the stored procedure to control what users may and may not
In AS 2.0 we use flvplayback.getVideoPlayer(flvplayback.activeVideoPlayerIndex)._video.smoothing=trueto get video smoothing in flvplayback object.Now in AS 3.0,that doesn't work ever.the tracing of