skip to main
|
skip to sidebar
.net resources
Monday 6 October 2008
Dynamic SQL use sp_executesql instead of EXECUTE Command
sp_executesql is more efficient, faster in execution and also supports parameter substitution
refer
http://www.codeproject.com/KB/database/Building_Dynamic_SQL.aspx
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
►
2010
(4)
►
August
(1)
►
May
(1)
►
April
(2)
►
2009
(1)
►
January
(1)
▼
2008
(17)
▼
October
(6)
extract email address from a string
simple search for column name all tables in db
SQL Server Find and Replace Values in All Tables a...
To search all columns of all tables in a database ...
Understanding View State in ASP.NET
Dynamic SQL use sp_executesql instead of EXECUTE C...
►
May
(3)
►
March
(4)
►
January
(4)
►
2007
(46)
►
December
(4)
►
November
(5)
►
October
(20)
►
September
(17)
About Me
aslam
software professional, enjoy travelling
View my complete profile
No comments:
Post a Comment