Info-lake

Search This Blog

find Table used in number of Stored procedures

May 30, 2012

Get link
Facebook
X
Pinterest
Email
Other Apps

SELECT
DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so
on sc.id=so.id WHERE
sc.text LIKE '%TableName%'

SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Difference between string.Empty , string = "" , string = null

string.Empty doesn't create an object. on other hand "" creates a string object as string is a reference type, For each time when you declare a string values as "" it create a new object for the same string. while string.Empty just reference a string in memory that is created by default. In case of string value is equal to null refers to absence of characters, NULL is NOT a value. It is a state indicating that the object value is unknown or nonexistent. It is not zero or blank or an “empty string” and it does not behave like any of these values.

Connection Pooling in Asp.Net

Connection Pooling in Asp.Net Connecting to a database server typically consists of several time-consuming steps. A physical channel such as a socket or a named pipe must be established, the initial handshake with the server must occur, the connection string information must be parsed, the connection must be authenticated by the server, checks must be run for enlisting in the current transaction, and so on. In practice, most applications use only one or a few different configurations for connections. This means that during application execution, many identical connections will be repeatedly opened and closed. To minimize the cost of opening connections, ADO.NET uses an optimization technique called connection pooling . Connection pooling reduces the number of times that new connections must be opened. The pooler maintains ownership of the physical connection. It manages connections by keeping alive a set of active connections for each given ...

Copy and Clone method

DataTable.Copy() Vs DataTable.Clone() Both the Copy and the Clone methods create a new DataTable with the same structure as the original DataTable. The new DataTable created by the Copy method has the same set of DataRows as the original table whereas the new DataTable created by the Clone method does not contain any DataRows." DataTable.Copy() DataTable.Clone() Create a new methods with same structure Create a new methods with same structure Data Row / Data in table is also copied Data in table is not copied

Powered by Blogger

find Table used in number of Stored procedures

Comments

Post a Comment