Murugan Andezuthu Dharmaratnam | 26 September 2023 | 164

Execute the script to backup the database from the command prompt using sqlpackage. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 09 May 2023 | 196

Explore best practices for SQL Server naming conventions. Discover the importance of consistency, clarity, and organization in database object naming for optimal database management. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 12 March 2021 | 1359

How to use group by clause with comma-separated column values in ms sql. I have a table … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 11 March 2021 | 1234

how to convert a comma separated string to individual rows in mssql … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 05 February 2021 | 1248

sql query to find list of table with insert updated or delete in the last one hour … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 22 January 2021 | 1248

I have a table named Purchase with several columns including PurchaseOrderNumber and PurchaseOrderLine with column data type nvarchar(max) I would like to change the data type to nvarchar(64) without dropping the table. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 18 January 2021 | 1275

… CONTINUE READING

Murugan Andezuthu Dharmaratnam | 28 November 2020 | 1384

sql server select columns into multiple variables from a table … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 27 November 2020 | 1302

mssql how to get the previous row and next row value using select statement … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 27 November 2020 | 1345

mssql how to get the current identity of a table before insert statement … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 09 November 2020 | 2268

ssms error/exception script generation failed, click on help for known solutions. I am getting this error while I was trying to take a backup of the database using generate script … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 03 November 2020 | 1415

how to remove duplicate from a table using mssql query … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 23 October 2020 | 1360

In an MSSQL stored procedure, I am passing the Name parameter how to select all if the name parameter in the where clause is null … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 18 October 2020 | 1408

How to use EXISTS in a select statement where you want to return a boolean column … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 15 October 2020 | 1596

mssql how to filter from select where in list only if the list is not null or how to handle empty IN clause parameter list in mssql. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 15 October 2020 | 1337

mssql how to check if the output from select returns empty or null … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 15 October 2020 | 1343

SQL script to copy the result from the select statement into a temp table. Please note that the temporary table is automatically created for you. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 15 October 2020 | 1706

from sql server management studio how do I pass a parameter of type user defined table type to a stored procedure … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 26 September 2020 | 2023

how to replace a string in a column in mssql … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 26 September 2020 | 1934

how to convert multiple rows to comma-separated string in mssql … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 24 September 2020 | 1856

mssql exception Operand type clash: dbo.type_name1 is incompatible with dbo.type_name2 … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 23 September 2020 | 1957

… CONTINUE READING

Murugan Andezuthu Dharmaratnam | 23 September 2020 | 1752

There are a couple of ways you can find the list of temporary tables in sql server. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 23 September 2020 | 2017

Creating a temporary table in mssql is one of the easiest things to do. You can use the same syntax as creating a table, the only difference prepend a # to the table name … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 15 September 2020 | 1970

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 10 September 2020 | 2212

ms sql server function to convert from number to words … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 10 September 2020 | 2064

we will write a function to find the depth of a tree. Depth of node N in the tree is the length of the path from the root of the tree to node N … CONTINUE READING

Murugan Andezuthu Dharmaratnam | 29 August 2020 | 2102

sql query to insert if item is not found else update the item … CONTINUE READING