Posts
Sort by recent activity
(un)Indent the body of a store procedure of function
I have the following code:CREATE PROCEDURE dbo.test
@test1 NVARCHAR(MAX) = 'All',
@test2 NVARCHAR(MAX) = 'All'
AS
BEGIN
SET NOCOUNT ON;
END
GO
Is there a way to *not* ...
Format of EXECUTE statement
For now there is an option "For EXECUTE statements, place each parameter on new line". I want to know if it's possible to add an option like "if number of parameters are greater than 4, then place ...
Is it possible to add an option to format all @@variables?
@? I want to get a consistent case for all those variables. Now there seems no this option and I have both lower case and upper case in my code.
Thanks.
Could you please help on the SELECT format?
Is there any way to set the arrow location to one space instead of 2?
Thanks.[/img]
How to stop indent the BEGIN ... END block?
Hi there,
I want to know if it's possible to disable the indentation of the BEGIN ... END block. Below is a sample code to demo what I want.USE master;
GO
IF DATABASEPROPERTYEX(N'testdb', N'Ver...
How can I get the meta data from an SQB file directly?
How can I get the meta data from an SQB file directly without an instance that has RedGate SQL Backup installed?
I need to get those information directly in an automatic way. After some investigati...
license issue
Hi,
The GUI shows I'm using professional version, but when I run the command line version executable, a window pops up and says that I'm using standard version and need to upgrade to professional v...
How to get this kind of information programmatically?
When I hover my mouse over a sqb file, I can get some information. See the following image:
How can I get this kind of information programmatically?
Thanks!
How to get these information from TSQL?
Hi,
I want to know how can I get these information from TSQL? Can I change them from TSQL?
Thanks[/img]
What's the easiest way to get the metadata from sqb files?
Hi,
For example, if I have some sqb files located in c:\temp, what's the easiest way to get the meta information(such as first lsn last lsn etc) in a easy to use form from them? The following code ...