By host on
12/12/2011 10:34 PM
The IsNullOrEmpty() is a user defined function in SQL server which is used to check the given variable is null or empty.
Read More »
|
By host on
12/12/2011 4:28 AM
To pass dynamic value to table valued function we can use the cross apply
Read More »
|
By host on
12/4/2011 9:25 PM
If you want to validate the values of column in DatagridView, when the user updates a cell of that column, the CellValueChanged event is fired. The event will be called when the focus leaves cell.
Read More »
|
By host on
11/30/2011 12:44 AM
This article helps to create the table queries which import Excel data in to the SQL Server table.
Read More »
|
By host on
11/29/2011 3:43 AM
Execute query script provides a list of scripts and its time of execution in the last 24 hours. If we close our query window in SQL Server management studio without saving the script. It works for all executed scripts not only a view or procedure.
Read More »
|
By host on
11/28/2011 12:16 AM
In a function we can return only one data type. If you need to return more data type dynamically, we can pass different parameter and return as object data types.
Read More »
|
By host on
12/29/2010 2:39 AM
The Apply Operator was introduced in SQL Server 2005. It is very similar to the Join clause, since both allow joining between two table expressions.
Read More »
|
By host on
9/28/2010 10:10 PM
OPENROWSET method is a onetime ad hoc method to connect and access the remote data from an OLEDB data source. Syntax for OPENROWSET contains all information required to access remote data from an OLEDB data source.
Read More »
|
By host on
9/9/2010 10:49 PM
This is Part 5 of Tsql Features in Sql 2008. In this article we discussed about Sparse columns, Filtered Indexes, Object dependencies, Collation alignment and Depreciation.
Read More »
|
By host on
8/31/2010 9:57 AM
SET operators are mainly used to combine the same type of data from two or more tables. Although more than one select statement will then be present, only one result set is returned.
Read More »
|
By host on
8/17/2010 11:31 PM
“Undocumented Extended Stored Procedures” is a dynamic link library that runs directly in the address space of SQL Server. We can create our own extended stored procedures using the C Language. Query Analyzer will help you to run the Extended Stored Procedures. Here we are going to explain some useful extended undocumented stored procedures.
Read More »
|
By host on
8/4/2010 3:23 AM
This is Part 4 of Tsql Features in Sql 2008. In this article we discussed about Table value parameters, Large user defined Types, Constructor support, The hieararcy id data type, DDL trigger enhancements and User defined Aggregate functions.
Read More »
|
By host on
8/2/2010 4:31 AM
Microsoft provides a standard mechanism for accessing the database engine using SOAP via HTTP in SQL server 2005. Web services are Application Programming Interfaces, or web APIs, that will be accessed via the Hypertext Transfer Protocol and can be executed on a remote system. In order to run the following example, you have to install IIS.
Read More »
|
By host on
7/26/2010 3:57 AM
A constraint is a rule or condition defined on a table or table column(s) to prevent wrong data from being entered into the database. DML operations like INSERT, UPDATE or DELETE that violate the constraints are not allowed to modify the data and thus the constraints maintain the database integrity (i.e. the accuracy and reliability of the data in the database).
Read More »
|
By host on
7/12/2010 2:48 AM
Normally a view is just a SQL query which has only its definition but no data on its own until the view is executed. However, SQL Server allows us to create indexes on a view to significantly improve the performance of data retrieval operations.
Read More »
|