Browse by Tags
All Tags »
Sql Server (
RSS)
I was trying to restore one database backup; which I successfully did (I'm using SQL Server 2005), and want to delete the users of the database which are restored along with the DB; I received this error which says "The database principal owns...
I came across one good article on Dynamic SQL (SQL Server) by Erland Sommarskog, SQL Server MVP. The Article describes Intro to Dynamic SQL, SQL Injection, Dynamic Queries and SPs, Good Coding Practice and Tips for Dynamic SQL, and the common cases where...
Multiple Active Result Sets (MARS) is a feature in ADO.NET 2.0. It allows execution of multiple batches against Database on a single connection. Preeviously, only one batch could be executed at a time against a single connection. But, execution of multiple...
Compound Assignment Operators in SQL Server 2008 Compound assignment operator means an operator combined with another operator. We have used such assignment operators in C++ and C#. This Compound Assignment Operator is introduced in SQL Server 2008. The...
(this is one of the article i posted on our local intranet repository; hope it will be helpful to others) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols...
Here is a line of T-SQL solution to get comma separated list of values of single field of a database table DECLARE @commaSeparatedVal AS VARCHAR ( 4000 ) SELECT @commaSeparatedVal = ISNULL ( @commaSeparatedVal + ',' , '' ) + CONVERT (...
In SQL Server 2008, Microsoft introduces the MERGE functionality through the MERGE command. The MERGE command inserts rows that don’t exist and updates the rows that do exist. What MERGE Command works as, IF FOUND THEN UPDATE ELSE INSERT; Until...
Hello Mates, Today I am going to buzz on Error Handing in Sql Server 2005. The release of Sql Server 2005 has provided us somany features over its predecessor. No doubt that more preference is given to the tasks performed by the administrator. But there...
INSERT offers the ability to insert into a table based upon a SELECT statement with the following syntax: INSERT INTO [TABLEA] ([FIELDA],[FIELDB],[FIELDC]) SELECT [FIELDA],[FIELDB],[FIELDC] FROM [TABLEB] there are time where you may want to do a similar...
One of the cool features of SQL 2008 is Row Constructor. The concept ‘Row Constructors in SQL Server 2008’ basically deals with the crux of multiple inserts performed at one shot. Instead of having to call multiple inserts, we could just insert...
SQL Server 2008 introduces a TIME data type which allows us to store the time without the date. For Example, DECLARE @t TIME = '17:32:19' SELECT [Time] = @t Time ---------------- 17:32:19.0000000 The TIME data type also allows you to define the...
For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real importance lies. Sure, functionality is a part of...
Article is about : The ability to pass "a list of values" from .Net as a parameter to a T-SQL based stored procedure. Scenarios : There are lots of scenarios where we need to pass a list of values to save in database. Here's a couple of...
