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 ...
-
Use this query to drop all kind of Transaction Deadlock in Sql Server ALTER DATABASE <DataBase Name> SET SINGLE_USER WITH ROLLBACK ...
-
Please Write this qurey and get
-
This is right use of SQL transaction Using TRY Catch for Avoid DeadLock Condition BEGIN TRANSACTION TransRavi BEGIN TRY <Do Y...
-
Please pass your table name in this query and Get name of all object which are dependent on that SELECT distinct A.name FROM syscomme...
-
This Function is used in replacing null or blank value as 0 select coalesce(@param, 0) this gives result 0 when @param is null or blank...
-
For Finding particular text in stored procedures please put your text on the place of <Text> and get result... SELECT c.name...
-
Use Quotaion Mark like this for show this select 'Hello, He is Ravi''s brother.'
0 comments:
Post a Comment