Sql
How to get the return value from a dynamic SQL Stored Procedure executed with sp_executesql
Solution: Example Stored Procedure. Create procedure Test (@ReturnValue Nvarchar(10…
Sql
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
I get this error Procedure expects parameter '@statement' of type 'ntext/…
WordPress
Error establishing a database connection in WordPress
Error establishing a database connection in WordPress Example: There are several …
Sql
Sql server get restore datetime | restore history sql server
List Out All Database Restore Date Time. WITH LastRestores AS ( SELECT Databa…
Sql
Sql cumulative sum
Sql cumulative sum Example: CREATE TABLE Test (id int,Number int); insert into tes…
Sql
how many sundays in month sql query
how many sundays in month sql query Solution: Use this function. First Find out H…
Sql
The transaction log for database 'XXX' is full
I'm getting the error like this "The transaction log for database 'xxx&#…
Sql
Multiple SQL rows merge into single row if the id is same
Multiple SQL rows merge into single row if the Code is same Example: Create t…
Sql
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I am getting below said collation error.. Example: Solution: These two collation…
Sql
Sql server String to Date conversion
Example: select convert(date,format(Getdate(),'yyyy')+'/'+format(Bir…
Sql
sql server birthday query
Get the list of an employee who have their birthdays today -- Sample Query Creat…
Sql
How to Get the first numeric value from the alphanumeric string in sql server
Solution: --Get the first numeric value from the alphanumeric string SELECT Naration…
Sql
How to get first day of the current month in Mysql
How to get first day of the current month in Mysql Example: --First day of the curre…
Sql
How to get all functions in a database
We can use sys.objects catalog view as shown in the below script to get all the funct…
Sql
How to get first day of the next quarter in Mysql
How to get first day of the next quarter in Mysql Example: --First day of the next q…
Sql
How to get first day of the current quarter
Example: --First day of the current quarter SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDA…
Sql
How to get first day of the previous quarter
Example: --First day of the previous quarter SELECT DATEADD(qq, DATEDIFF(qq, 0, GETD…
Sql
How to check if exists Database in Sql Server
We can use the sys.sysdatabases catalog view to check the existence of a Database. H…
Sql
How to check if exists Stored Procedure in Sql Server
We can use the sys.procedures catalog view to check the existence of a stored proedur…
Sql
How to check if Exists table in sql server
We can use the sys.Tables catalog view to check the existence of the Table. Here in …
Social Plugin