welcome to winton home, for more catogory's details, Please click [AJAX] [ASP.Net] [C#] [UML] [SQL Server] [心灵旅程] [首页]

飞天舞者

Enjoy work & Enjoylife
随笔 - 167, 文章 - 0, 评论 - 14, 引用 - 4
数据加载中……

SQL Server Technical Issues

sharing the skills about writing SQL Scripts, Store Procedure..
Process multi-row data with cursor or without cursor[利用游标或者非游标处理多行数据]

posted @ 2008-05-07 21:14 飞天舞者 阅读(33) | 评论 (0)  编辑

A store procedure sample using caes ...when ...then...

posted @ 2008-05-02 13:05 飞天舞者 阅读(19) | 评论 (0)  编辑

difference between Truncate and Delete

posted @ 2008-03-03 14:45 飞天舞者 阅读(19) | 评论 (0)  编辑

some tips about sys.objects table

posted @ 2008-01-25 14:37 飞天舞者 阅读(26) | 评论 (0)  编辑

just some skills for SQL

posted @ 2008-01-22 16:55 飞天舞者 阅读(20) | 评论 (0)  编辑

execute sql query dynamically

posted @ 2008-01-17 15:57 飞天舞者 阅读(19) | 评论 (0)  编辑

insert/process multi-records without cursor

posted @ 2008-01-17 11:34 飞天舞者 阅读(29) | 评论 (0)  编辑

how to judge if the temptable or normal table that you created exists

posted @ 2008-01-17 09:20 飞天舞者 阅读(17) | 评论 (0)  编辑

simple =, join,left out join,right outer join, cross join

posted @ 2008-01-16 11:18 飞天舞者 阅读(60) | 评论 (0)  编辑

How to receive another procedure result in one procedure.

posted @ 2008-01-16 11:13 飞天舞者 阅读(19) | 评论 (0)  编辑

how to call the procedure in c# program

posted @ 2008-01-16 11:11 飞天舞者 阅读(40) | 评论 (0)  编辑

get all table's information concerned

posted @ 2008-01-16 11:08 飞天舞者 阅读(19) | 评论 (0)  编辑

create procedure grammar

posted @ 2008-01-16 11:04 飞天舞者 阅读(29) | 评论 (0)  编辑

For more information about me, feel free email to me hiron_982135@hotmail.com