- 博客(3)
- 收藏
- 关注
原创 use Network Service account to access DB
It’s impressive that a DB access issue was encountered whenwe deployed DW on mikplatform. A web app adopts an Application Pool with Identity ApplicationPoolIdentity A windows service uses NetworkS
2017-01-22 17:32:16 575
原创 manipulate array of data in SQL
As we know, SQL server lacks of concept of array. a workaround is to store the data in a table variable and then iterate it. one way to do iterate is using cursor, but it's slow another way is add
2017-01-11 10:40:17 239
原创 Recover sql when Management Studio crashes
UseMaster SELECTexecquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROMsys.dm_exec_query_stats AS execquery CROSS APPLYsys.dm_exec_sql_text(execquery.sql_handle) AS execsql
2017-01-11 10:27:15 190
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人