SELECT TOP 1 column FROM table
ORDER BY NEWID()
![select_random_record_from_a_table_in_sql_server2.png (499×319)](https://dattatreysindol.files.wordpress.com/2010/03/select_random_record_from_a_table_in_sql_server2.png?w=499)
Ví dụ:
SELECT TOP 5 City_name FROM vw_ttv_mtd
ORDER BY NEWID()
Kiểm tra sự tồn tại
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MDF_Summary]') AND type in (N'U'))
print('ok')
else
print('ok2')
IF EXISTS (SELECT * FROM vw_ttv_mtd where city_name='linz')
drop table table_1
else
print('ok2')