Common issue generally every developer faces in his initial days of development is how to generate connection string that connects my application to the database. Especially when we don't have sql management studio installed or if we are facing licensing issues.Well, a text file can come to a rescue. To overcome such
Read moreAs a layman or a novice, when we come across the concept of local temporary tables, global temporary tables, table variables or common table expressions; we tend to think that they function similarly i.e. they all store data in them in a tabular format. So whats the difference in them
Read moreWhy Front-end application testers should also know the basic Database testing in order to better test the applications:-What is Database TestingIn Database testing we validate:-Exactly the same data that is in database is retrieved by web or desktop application (front-end applications).The data which is inserted/modified from front-end application the same
Read moreIt is simple to implement to cross join in LINQSuppose i have 2 tables 1. Customers & 2.orderNow i want cross join on both tablesvar q = from c in dataContext.Customers from o in dataContext.Orders select new {
Read morewe can implement left outer join in LINQ as wellsuppose i have 2 tables 1. product 2. order. In the order we have foreign key named as productId reference to product tableNow we want to achieve left or left outer joinvar q=(from pd in dataContext.Products join od
Read moreEXEC sp_databasesEXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005SELECT nameFROM sys.databasesSELECT nameFROM sys.sysdatabases ----SQL SERVER Un-Documented ProcedureEXEC sp_msForEachDB 'PRINT ''?'''
Read moreThe only thing that needs to change to run this script are the database where you want this to run and the values for these two parameters: @stringToFind @stringToReplace [crayon-6892477f3e878204020137/]
Read moreIf you want to apply order by on column which contains data likes numbers, string..etc Then here is the solution [crayon-6892477f3e9ea710910639/] Input:- a ba ab 1 as 2 Output:- 1 2 a ab as ba :)
Read moreTechnologies Used: Visual Studio 2013 Express Sql Server 2008 R2 Express MVC 5 Nuget SqlDependency MSDN SignalR 2.0.1 Nuget Jquery 2.0.3 Nuget Toast Notifications Script to Create Broker & Service: create a user called "GeneralUser" with a password of "dbpassword" in your SQl Server logins. Run the following script in a Sql query pane, to create a message broker\service for
Read more