Tag: mssql

To list all Databases in MSSQL you can use the following snippet. Sample MSSQL SQL Server Version newer than MS SQL 2000 also support these StoredProcedures. or

To check if a column exists in MSSQL you can use the following snippet. Sample MSSQL

To learn how to use the Space() function in MSSQL you can take a look at the following snippet.   Let’s say you have a table (tblTest) like this: ID…

To list all user defined functions in MSSQL you can use the following snippet. Sample MSSQL

To get a list of all functions in mssql you can use the following snippet. Sample MSSQL

To list all users in MSSQL you can use the following snippet.