Creating Linked Server: [sql] EXEC sp_addlinkedserver @server=N’IIC82′, @srvproduct=N”, @provider=N’SQLNCLI’, @datasrc=N’IIC82\SQL2008R2′; [/sql] Here you need to replace with your server name.
Find which are all table has set identity. [sql] select COLUMN_NAME, TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = ‘dbo’ and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, ‘IsIdentity’) = 1 order… Read More »Find Which Are All Table has Set Identity
Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: [sql] SELECT sysobjects.Name ,… Read More »Get the Count of Entries in Each Table in a DB in SQL
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?… Read More »Passing a DataTable to a Stored Procedure