Category: T-SQL
Copying environment variables from one environment to another using SQL query
Inkey, October 7, 20222817 Views
As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development phase or the underground lab) -> UAT (for testing phase or Racoon city) -> PROD (for real-time application or the world). In SSIS also, we are able to deploy the same SSIS package in 3 different environments, but […]
Read moreMicrosoft SQL Server > Find a specific value in all the tables of a database using T-SQL
Inkey, September 2, 202234021 Views
Often times we find ourselves in a situation where we want to find a particular value but we are unaware of its whereabouts, i.e., we don’t know in which table or column this value is present. Or we want to know in which other tables a particular value is present. Or just if this value […]
Read moreHow to quickly match data of two recordsets in SQL Server?
Inkey, August 10, 20222313 Views
While working with T-SQL, many times we create complex queries, and then we might need to optimize them at some later point of time to reduce the execution time. This activity always demands an approach to compare data for the older and newer version of the T-SQL. And here comes the question – how do […]
Read moreJuggling with .net & sql
Vinay Pugalia, June 13, 20175266 Views
Technology expert, Vinay gets excited when it comes to writing about Dot Net, SSRS and SQL Server. Be it complex concepts or complex problems, Vinay has explained everything in simple and easy steps. To learn more, click on the link below and follow his posts.
Read moreInkey’s ability pond
Admin, June 8, 20175671 Views
‘‘INKEY’s ability pond” is your one stop shop to learn more about the services offered at INKEY. Here, our authors discuss on some of the topics like Microsoft SQL Server, Microsoft Dynamics CRM, Microsoft Business Intelligence, Microsoft Power BI, Microsoft Office Add-ins, Mobile Development, and Custom Application Development.
Read more