Tricks to Replace SELECT * with Column Names - SQL in Sixty Seconds #017

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

This is so cool and saves time.
I am glad I came across this.
Thank you!

harshmehta
Автор

hi, Pinal
please, make a video on how do you count length of a string, if you want the exactly length, including spaces in the beginning and the end of the string

Obratim
Автор

Dear Admin, ur 60sec videos are always helpful, it would be great if u add those handy queries in the description box as well. Thanks in advance.

Shivraj-gtin
Автор

hi Pinal, do you have a quick way to get all column names (and their datatype if possible) of a #Temp table (beside sp_helptext) ?

frankdo
Автор

Also we can use sp_help <table_name>

dineshyd
Автор

Good one, and all these while i was using Alt+F1 :-( ;-( :-(

killerranjith