I want to discuss about SQL Basic Query. Microsoft SQL and Oracle PLSQL is import for DB sql query.
SQL queries can be written in the box located under the “Execute SQL” tab. Click ‘Run SQL’ to execute the query in the box.
1 2 |
SELECT year FROM surveys; |
We have capitalized the words SELECT and FROM because they are SQL keywords. SQL is case insensitive, but it helps for readability, and is good style.
Select Code in 5 Digit:
1 2 3 |
SELECT top 10 PAYROLL_CODE, CAST((REPLICATE('0', 5 - len(PAYROLL_CODE)) + CAST(PAYROLL_CODE AS VARCHAR)) as varchar) FROM [TAX_OIL].[dbo].[TAX_DETAILS_OLL] |
Update:
1 2 |
update [TAX_DETAILS_OLL] set PAYROLL_CODE = CAST((REPLICATE('0', 5 - len(PAYROLL_CODE)) + CAST(PAYROLL_CODE AS VARCHAR)) as varchar) |
Search Tables For Specific Columns
1 2 3 |
SELECT COLUMN_NAME AS 'ColumnName' ,TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%MyName%' ORDER BY TableName ,ColumnName; |
Table List Of a Database
1 2 3 4 5 |
USE YOURDBNAME GO SELECT * FROM sys.Tables GO |
Update One Table From Another Table:
1 2 3 4 5 6 7 8 9 |
UPDATE NATIONAL_SALES_OLL_Test.dbo.TRANS_TARGET_MONTHLY_DTL SET REGION_NAME = Q.REGION_NAME FROM ( select REGION_CODE,REGION_NAME from NATIONAL_SALES_OLL_Test.dbo.TRANS_TARGET_MONTHLY_DTL TD where TRG_ID= 106 )Q where TRG_ID= 107 and NATIONAL_SALES_OLL_Test.dbo.TRANS_TARGET_MONTHLY_DTL.REGION_CODE = Q.REGION_CODE |
Thank you for another great post. Where else could anybody get that kind of information in such an ideal way of writing? I’ve a presentation next week, and I am on the look for such info.