Sibeesh Passion

Find the Relationship Difference Between Two DB

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Find the relationship difference between two DB.

Read More

Find Relationships Between Tables in SQL Server 2008

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         find the relationships between tables in SQL Server 2008

Read More

Creating Linked Server in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Creating Linked Server: Here you need to replace with your server name.

Read More

Find Which Are All Table has Set Identity

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Find which are all table has set identity.

Read More

Get the Count of Entries in Each Table in a DB in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: OR [/sql] SELECT sum(sysindexes.Rows),GETDATE() FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id WHERE type = ‘U’ AND sysindexes.IndId < 2 [/sql] Kindest Regards

Read More

Get the Table Count in a DB in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Get the table count in a DB in SQL.

Read More

Passing a DataTable to a Stored Procedure

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         This article explains how we can pass our data table to a stored procedure in C#. We all passed parameters to our stored procedures right? What if we get a situation that to pass a bunch of arguments to a stored procedure, for example a normal data table which we create. This post helps you […]

Read More

SQL Server Tips and Tricks

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Introduction This article provides some tricks we may use in our day-to-day programming life in SQL. Background Right now, I am handling a software product in my office. The back end used in that project is SQL Server 2008, that have more than 250 tables and consists around cores of data. :). So I used […]

Read More
Footer With Address And Phones