Common query commands in sql
This article introduces the knowledge of "sql common query commands". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
-- query version number SQL2000 select serverproperty ('productlevel')
-- query table in all field names Select name from syscolumns Where ID=OBJECT_ID ('barinfo')
-- query all table names in the data select name from sysobjects where type='U'
This is the end of the content of "sql Common query commands". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!
