حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to select without specifying column names in query in SQL Server

dotnetto...

SOLVED CLOSED ACTIVE ANSWERED
User: dotnettot
Posted: on Sep 25, 2013 04:24 AM
Forum: SQL Server
Answer: 1
Views: 3069

hi,,i have table in 45 column,,but i want 40 column,,how i select using star* symbol and unwanted 5 coloumn,,or manually typing than fourty coloumn name a

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Sep 25, 2013 04:24 AM
Report

if you want some columns from all then there is no way rather than writing column names or column index.

Example

select 1,2 from MyTable

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

216.73.216.165

How to select without specifying column names in query in SQL Server

Company

Explore

Follow us

Contact Us