for maintaining performance of queries we need to rebuild indexes so below is the way we can use to rebuild all indexes of complete database so we need not to rebuild indexes of all tables one by one.DECLARE @TableName varchar(255)DECLARE TableCursor CURSOR FORSELECT table_name FROM information_schema.tablesWHERE table_type = 'base table'OPEN TableCursorFETCH NEXT FROM TableCursor INTO @TableNameWHILE @@FETCH_STATUS = 0BEGINDBCC...
Friday, November 26, 2010
Remove Scripts from database/ Remove Sql Injections
USE [DBFORUMSNEW]GO/****** Object: StoredProcedure [dbo].[sp_sqlinjection] Script Date: 11/26/2010 19:46:09 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER Procedure [dbo].[sp_sqlinjection] @DBName varchar(100) as Begin declare @DB_Name varchar(40), @Table_Name varchar(40),@Column_Name varchar(40) declare @sql1 varchar(1000), @sql2 varchar(1000)Set @DB_Name = @DBName begin exec ('use ' + @Db_Name) DECLARE...
Friday, November 12, 2010
What is Bookmarklet / what is use of Bookmarklet
Each bookmarklet is a tiny program (a JavaScript application) contained in a bookmark (the URL is a "javascript:" URL) which can be saved and used the same way you use normal bookmarks. The idea was suggested in the Netscape JavaScript Guide.JavaScript has been used by page authors on millions of webpages; Bookmarklets allow anybody to use JavaScript - on whatever page you choose (not just your own page). so A bookmarklet is...
FileUploader in asp.net MVC2
as we all know ASP.NET MVC sits on top of ASP.NET. That means ASP.NET MVC didn't do any special work for File Upload support. It uses whatever stuff is built into ASP.NET itself. So the core process is still same for file upload:below is code for viewCode for how to Upload file in ASP.NET MVC2< %@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" % > < asp:Content...
Wednesday, November 10, 2010
difference between exec and sp_executeSql
both are used for executing dynamic sql in sql server.both are not preferred because, If we are using dynamic sql in stored procedure, SQL Server may not use the execution plan. It will recreate the execution plan every time with different string of SQL.So, we have to think about the performance while using dynamic sql.Main Difference:Exec is non parametrizedsp_executeSql is parametrizedthe main difference between above two is...
what is cls compliant code
cls compliant is mostly used when we wants our dll or any other code to be used by other language which are supported by .net.lets say we wants to create a library in c# which we wants to be use in c# , vb.net , visual c++ or any other such languages. so for that we will have to create it as a cls compliant so that it can be consumed by all other .net supported language.You can apply the CLSCompliant attribute on a class, an...
How to refresh view when table structure got changed
Lets we have got a table named tblstudent which contains following fieldsstudentRNo, studentName, StudentAddressnow we have create a view on it like:create view viewNameasselect * from tblstudentnow when we will perform select operation on view then it will show us columns:select * from viewNameoutput:studentRNo, studentName, StudentAddressnow we have added a new column to tblstudent named 'studentFee' alter table tblstudent...
Monday, November 1, 2010
Gridview with master-slave data
some times we wants to show gridview with master-child data. so that on click of master the details should be shown in child.To do so here is a very good article:http://www.progtalk.com/viewarticle.aspx?articleid=...
Subscribe to:
Posts (Atom)