This procedure will return DEFAULT value for the parameter in the stored procedure. Usage: Use pubs go declare @Value varchar(30) exec _GetParamDefault 'random_password','@password_type',@value OUTPUT SELECT @VALUE Also accepts different versions, by default, if not specified, first version info retrieved. exec _GetParamDefault 'random_password;2','@password_type',@value
2002-05-10
379 reads
SFormat is UDF function that can convert seconds to HH:MM:SSEx:1- Select dbo.SFormat(130) will return 00:02:102- Select dbo.SFormat(dbo.test.Duration) as Dur (to be used with tables). where 'Test' is table name and 'Duration is a field(int).
2002-05-10
476 reads
Rather than invent (or learn) a whole new set of tools to preserve and version all DDL underneath our databases, we decided to use SourceSafe (something we're already using for all other source code). -- We've developed this VBscript to run nightly; it recreates object-level DDL in a given database and compares each object's script […]
2002-05-09
191 reads
This script gives the count of records of each user table in the current database along with the table name. This script eliminates the need of going through all the tables and counting them. Works on SQL 2000 (For SQL 7.0 - use 'rows' instead of rowcnt).
2002-05-09
2,401 reads
This script gives the count of records of each user table in the current database along with the table name using a single SQL Statement. It has been tested on SQL 7 and SQL 2000
2002-05-09
969 reads
Like the replace function, but can replace more than 1 value at a time.e.g. select dbo.multiple_replace('hello', 'e', '1', default) gives 'h1llo'. Equivalent to: select replace('hello', 'e', '1')e.g. select dbo.multiple_replace('hello world', 'e;w;ld', '1;2;END', default) gives 'h1llo 2orEND'e.g. select dbo.multiple_replace('hello world', 'e$w$ld', '1$2$END', '$') gives 'h1llo 2orEND'
2002-05-09
496 reads
This function was written to supplant cumbersome age-at calculations. To execute, simply set a local INT variable equal to the output of the function. For example, the following, given my birthdate, computes my own age: DECLARE @age_at INT SET @age_at = dbo.f_age_at ('2/16/1954', GETDATE ())
2002-05-09
1,088 reads
This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.
2002-05-09
236 reads
This stored procedure will retrieve list of parameters for specified stored procedure.To check similar names,like 'myproc_xxx', pass any char in the second parameter(optional).
2002-05-09
1,255 reads
A user-defined function that returns a table of numbers between a and b (using the most efficient way I can think of).e.g. select * from table_of_numbers(1, 4) gives a table with rows 1, 2, 3 and 4.
2002-05-09
195 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers