DevSocial Blogs · SQL Server blogs

Just go through this Query to create database and tables, use database, insert values in to tables ,join three relevant tables in SQL Server 2005.

Karthika PalaniswamyOct 28, 20095,600250

The tables "INSERTED" and "DELETED" are called magic tables of the SQL Server. We can not see these tables in the data base. But we can access these tables from the "TRIGGER"

I think StoredProcedures are better for maintainability because they can create a clear interface to the database

Purushottam RathoreSep 14, 200912,353250

How to get all Stored Procedures Related to Table in Database?

Purushottam RathoreSep 11, 20099,091250

This blog allow to take backup of your sql database....

Here I will describe how to get list of Stored Procedure , Tables and views from Sql Server database

Blocked AccountJul 30, 2009295,762250

This blog shows you how to create a sql connetoin... by code.

Nikhil KumarApr 20, 20095,283250

SQL Server Native Client is a stand-alone data access API, used for both OLE DB and ODBC, that was introduced in SQL Server 2005.

Sateesh ArvetiMar 16, 20098,489250

DBCC CHECKTABLE verifies the integrity of all the pages and structures that makes the table or indexed view.

Sateesh ArvetiMar 3, 200911,499250

SHUTDOWN command is used to shut down an SQL Server Instance.

Sateesh ArvetiMar 1, 20097,638250

RESTORE HEADERONLY allows us to see all the backup information of a database backup.

Sateesh ArvetiFeb 27, 200912,659250

DBCC CHECKALLOC is used to check the consistency of disk space allocations structure for a specific database

Sateesh ArvetiFeb 26, 20097,990250

Replication Log Reader Agent copies all transactions marked for replication from transaction log into distribution database.

Sateesh ArvetiFeb 25, 20098,457250

SQL Server provides some built-in fixed database roles predefined in the database like db_owner ,db_securityadmin etc.

Sateesh ArvetiFeb 24, 20097,592250

Use DBCC FREESESSIONCACHE command to clear distributed query connection Cache.

Sateesh ArvetiFeb 24, 20099,484250

Give Some & Get Some

Vijaya KadiyalaFeb 22, 20097,288250

SQL Server 2008 Express version is available for download now - FREE. Very cool.

Mahesh ChandFeb 17, 20099,694250

In last couple of years, I have seen many medium to large scale businesses have started looking into SQL Server as an option to replace their existing Oracle databases.

Mahesh ChandFeb 8, 20095,386250

What is Difference between SQL 2000 and 2005

Amin AnwarJan 27, 20094,386250

SQL Server Data Services, Microsoft's Cloud database, is SQL but not as you know it. Check what experts are saying about it.

Mahesh ChandJan 14, 20095,565250

This blog is for finding Duplicate records from a table and delete it.

Find Duplicate records from a Database Table and Delete them.