Magic of SQL Server
Today we will talk about magic of Sql Server. There is a scenario, we need to swap value between two columns, what will be sql query for that?
Look the following sql query and you will surprised that there is a simple way to do that in Sql without using third variable.
Tell me above sql query will be execute or we will get error.
Today someone asked me, how to insert data from XML to Database?
Now we are going to insert the values of an XML file to a Database Table using SQL Insert Command . Here the Dataset using an XmlReader for read the content of the XML file - SampleProduct.XML . Locate the XML file using XmlReader and pass the XmlReader as argument of Dataset. Also establish a connection to the Database using a connectionstring . After getting the data from XML file to the Dataset , we can loop through the dataset values and use insert command to add the values to the Product table in the Databse...
Today some one asked me how can do image slide with Jquery. It is easy to do that with use of some Jquery animations.
TypeScript optionally provides source maps, enabling source level debugging.
In c# introduce new concept is Indexer. This is very useful for some situation. Let as discuss something about Indexer.
Indexers help us to simplify the way to access a collection for a class.
Summarizing in a sentence - Indexers help to access contained collection with in a class using a simplified interface. It's a syntactic sugar.
Indexer Concept is object act as an array.
Indexer an object to be indexed in the same way as an array.
Indexer modifier can be private, public, protected or internal.
The return type can be any valid C# types.
Indexers in C# must have at least one parameter. Else the compiler will generate a compilation error.
When we analyze the Context vs Scope then we find that both are not same. I met lots of developers and noticed many of them confuse with these and be frank they mixed both to each other.
Both null and undefined can be regarded as a special value that indicates "no value".
The null is a language keyword (in fact, it is a primitive ) which is used to indicate the expected lack of value. On the other hand, undefined is a predefined global variable that has a deeper meaning and is used to indicate an error-like, unexpected lack of value.
When we insert data in table in SQL, in that case we need to get the reference of new inserted row, how can we do that?
There are some internal functionality in SQL Server through which we can get that value from SQL Server.