mssql cheatsheet - in progress

StuartCreed - Dec 28 '22 - - Dev Community

To find the structural information about a table in mssql:

sp_help table_name
Enter fullscreen mode Exit fullscreen mode

Use the top helper like select top 10 * from table_name to limit the number of results from a select wildcard

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Terabox Video Player