{infiniteZest}
// Articles. Tutorials. Utilities.
Home  |   Search  |   Login  
Categories Skip Navigation Links
New / All
AJAX
Apple
ASP.NET
.NET
Git
Google / Android
Python / IronPython
Miscellaneous
SQL Server
Listing of sqlserver Articles
Sort By:
icon-replace-window.jpg
This article looks at the client-side way to replace a piece of matching string in a text column.
icon-copy-database.jpg
This article shows one way of setting up a local database and populating it with data from the server database. Restriction here is that you might not have full admin access to the server db and you might not want all the tables.
Selecting the top x records from a query using one order by clause and then ordering the records with in that set of records becomes easy with the WITH keyword in SQL Server 2005. This article looks at creating a temporary table and then querying on that table.
SQL Server 2005 provides a way to obtain a range of records obtained from a SELECT statement using row_number. This article has a stored procedure that gives the records of a given pagesize from given pagenumber.
Sometimes you need to execute a stored procedure from the query window to view the results in a quick and dirty way. This article shows how to execute a stored procedure that's already there in the db with output parameters.
Page 1 : Article 1 to 5 of 5
About  Contact  Privacy Policy  Site Map