Sunday, May 27, 2012

SQL Server Tips

1. How to get list of stored procedures in a database

SELECT NAME FROM SYS.ALL_OBJECTS WHERE type= 'P'


2. How to get list of tables in a database

SELECT * from sysobjects where type = 'U'


3. How to get list of databases in a SQL server

SELECT name, collation_name
FROM sys.databases
WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')

3 comments:

  1. I thoroughly enjoyed reading the article on SQL Server tips at codeketchup.blogspot.com! The insights provided are incredibly valuable for anyone working with SQL Server. The tips are well-explained and will undoubtedly enhance the efficiency of database management.

    Additionally, I'd like to take this opportunity to highlight the significance of upskilling in the field of data science. Imarticus Learning's Data Science Course stands out as an excellent choice for those looking to advance their skills in this rapidly evolving field. With a curriculum designed to cover the latest industry trends and hands-on projects, Imarticus Learning ensures that students gain practical knowledge and experience. The course not only equips learners with data science essentials but also prepares them for real-world applications. Kudos to Imarticus Learning for contributing to the growth of aspiring data scientists!

    ReplyDelete
  2. Great SQL Server tips! 👏 It's always helpful to stay updated with the latest tricks and techniques. On a different note, I've been exploring some interesting topics lately, including 'sad whatsapp dp.' It's fascinating how technology connects us in various ways, even through the expression of emotions in our online profiles. Looking forward to more insightful posts like these! 💻 #SQLServer #TechTalk #EmotionalConnectivity

    ReplyDelete