Geeks With Blogs
Sharvan Dhaka blog MS Sql
How to change the ower of tables in Microsoft SQL Server database
To do this, execute the following command on every table exec sp_changeobjectowner '?????', 'DBO' - where ????? is the name of your database table. Also below is the stored procedure through which you can change the owner for every table in the database. EXEC sp_changeobjectowner @oldownerplusobject, @new create procedure _ChangeObjectOwner (@type varchar(1),@old varchar(20),@new varchar(20)) as declare @ObjectName varchar(100) declare @oldownerplusobject varchar(50) begin declare Cursor_Object cursor ......

Posted On Sunday, October 15, 2006 5:55 PM

How to change the ower of tables in Microsoft SQL Server database
To do this, execute the following command on every table exec sp_changeobjectowner '?????', 'DBO' - where ????? is the name of your database table. Also below is the stored procedure through which you can change the owner for every table in the database. EXEC sp_changeobjectowner @oldownerplusobject, @new create procedure _ChangeObjectOwner (@type varchar(1),@old varchar(20),@new varchar(20)) as declare @ObjectName varchar(100) declare @oldownerplusobject varchar(50) begin declare Cursor_Object cursor ......

Posted On Sunday, October 15, 2006 5:54 PM

Split function in MS Sql, Split string
There is no in bulit function to split values in sql. i have created a tabular function that can split a string in a table. Create function [dbo].[StrFunc_Split] ( @InputStr nvarchar(4000), @SplitChar nchar ) returns @Splittings table ( Position int, Value nvarchar(4000) ) as begin declare @Index int, @LastIndex int, @SNo int set @LastIndex = 0 set @Index = charindex(@SplitChar, @InputStr) set @SNo=0 while @Index > 0 begin set @SNo=@SNo+1 insert into @Splittings(Position, Value) values(@SNo, substring(@InputStr, ......

Posted On Sunday, October 15, 2006 5:39 PM

SQL Interview Questions
What is normalization? Explain different levels of normalization? What is denormalization and when would you go for it? As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? One-to-One relationship can be implemented as a ......

Posted On Sunday, October 15, 2006 5:13 PM

HOW TO: Configure SQL Server Security for .NET Applications
This article describes how to configure the SQL Server for .NET applications. By default, the SQL Server denies access to user accounts that have not explicitly been granted access to a database, a table, or a view. By default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application cannot read and cannot update data in an SQL Server database. This article describes the process that you can use to permit an ASP.NET ......

Posted On Sunday, October 15, 2006 4:59 PM

SQL Injection
SQL injection is a technique used to take advantage of non-validated input vulnerabilities to pass SQL commands through a Web application for execution by a backend database. Attackers take advantage of the fact that programmers often chain together SQL commands with user-provided parameters, and can therefore embed SQL commands inside these parameters. The result is that the attacker can execute arbitrary SQL queries and/or commands on the backend database server through the Web application. Detailed ......

Posted On Sunday, October 15, 2006 4:18 PM

Copyright © Sharvan Dhaka | Powered by: GeeksWithBlogs.net