what is select1 and give example

Posted by Rajesh081725 under Sql Server on 12/3/2012 | Points: 10 | Views : 1780 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Can u any one tell me

what is select 1
why are using this select 1
can u given explainatin and example for select1 with if exist in sql
different between select and select 1

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Nataran on: 12/3/2012 [Member] Starter | Points: 25

0	Hi Please check this blog, it may be helpful to you http://blog.sqlauthority.com/2008/02/26/sql-server-select-1-vs-select-an-interesting-observation/ Regards, Anitha Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...