Knowledge is Here...
Pages
(Move to ...)
Home
Advance Search All Posts
About blog
▼
Thursday, December 7, 2023
SQL Server SSMS stuck on query while truncate the table
›
I was going to truncate a table in sqlserver database but it seems to be went in deadlock. Apart from this if issue persist regularly then ...
Create Sequence Using SQL in MYSQL
›
Generate a range of consecutive/Sequence numbers (1 to 100) using a MySQL query, see below. Replace 100 number as per your choice, so it wi...
Wednesday, August 23, 2023
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component
›
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as ...
Driver class 'org.gjt.mm.mysql.Driver' could not be found
›
Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm....
Saturday, July 1, 2023
ALTER TABLE statement conflicted with the FOREIGN KEY constraint
›
Server Type - MS SQL Server Scanerio : Error faced when tried to apply foreign key constraint on table having data in it (non empty table)....
›
Home
View web version