Category: SQL
-
List logins on SQL Server instance
Following sql query returns the list of logins in a sql server
-
Generate C# Class from Table using SQL
This is a wonderful snippet that generates C# Class from a Table inside SQL Management Studio, just change the table name Source: https://stackoverflow.com/questions/5873170/generate-class-from-database-table
-
Search text in all stored procedures in SQL Server
You may use your particular database name like
-
Find total Number of columns in a Table in SQL Database
SQL Query to find total number of columns in a Table in SQL Database,
-
Find recently Added Stored Procedures in Sql Server
Here is a small snippet, to find the recently added stored procedure that you created in your sql server, this can be useful when did not keep track of the stored procedures in your project.