coming soon........
About Me
Popular Posts
-
Please Use this in your procedures and functions DECLARE C21 CURSOR FOR <Query to find Value on basis of ...> OPEN C21 ...
-
Dear all these are the query to reduce size of log file in sql Query 1 ALTER DATABASE databasename SET RECOVERY SIMP...
-
By Using This query we can reduce database file Firstly we should get File Name by Using This with TblSpace as ( select ...
-
This is right use of SQL transaction Using TRY Catch for Avoid DeadLock Condition BEGIN TRANSACTION TransRavi BEGIN TRY <Do Y...
-
Please Pass your date of birth in "DD/MM/YYYY" format and get age ..... Create a Procedure... create Proc dbo.CalculateAge...
-
Use this query to drop all kind of Transaction Deadlock in Sql Server ALTER DATABASE <DataBase Name> SET SINGLE_USER WITH ROLLBACK ...
-
For Finding particular text in stored procedures please put your text on the place of <Text> and get result... SELECT c.name...
-
Step 1. Please pass Your table Name in this Stored Procedure and get script Create Proc dbo.Ravi_Script_Table (@tablename varchar(50)) ...
-
Please Write this qurey and get
-
Use This Process to Kill sleeping Threads in sql CREATE proc [dbo].[KillProcess] as begin declare @ms...
0 comments:
Post a Comment