SQL server Archives - Tech Insight !

SQL server 2005

How to make SQL Server 2005 database empty using cursor & sys.objects (Delete All Tables, stored procedures, views & UDF’s)

<img alt height=100 width=100 data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20100%20100'%3E%3C/svg%3E" data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazy' height=100 width=100>

kiranFebruary 24, 2010December 31, 2019

Understanding sys.objects: Sys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself. Using Sys.objects returns...

.Net 2.0 asp.net C#.net SQL server 2005 Web Developement

Storing and Retrieving image in SQL server 2005 & asp.net using large value data type & HTTP handler

<img alt height=100 width=100 data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20100%20100'%3E%3C/svg%3E" data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazy' height=100 width=100>

kiranDecember 9, 2009January 1, 2020

ASPX page : <form id="form1" runat="server"> <div style="padding: 200px;"> <asp:Image ID="imagebox" runat="server" ImageUrl="~/sql-image-store/image-handler.ashx" /> </div> </form> Handler code: image-handler.ashx <%@ WebHandler Language="C#" Class="image_handler" %> using System; using System.Web; using System.IO;...

Excel SQL server 2005

Import Excel data into SQL Server 2005 table using distributed queries

<img alt height=100 width=100 data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20100%20100'%3E%3C/svg%3E" data-src='https://secure.gravatar.com/avatar/034fcba2f75894afc6a6bf09a205a0e2?s=100&d=mm&r=g' class='avatar avatar-100 photo avatar-img lazy' height=100 width=100>

kiranDecember 9, 2009January 1, 2020

/*SQL server configuration settings */ exec sp_configure sp_configure 'show advanced options', 1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries', 1 reconfigure /*Excel import into sql table using distributed query*/ select...