Get record based on specific column Sql

Firuz

SOLVED CLOSED ACTIVE ANSWERED
User: Firuz
Posted: on Mar 03, 2016 04:08 AM
Forum: SQL Server
Answer: 1
Views: 3279

Hi! I used Index out of range it's worked. Bu i have problem. When i input Suhrob it's not show any data about Suhrob because not saved in database it's right work. I clear Suhrob and write Rustam It's must show all data because i saved about Rustam it's not work. Can you help me?

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

Shashika...

0 5

Reply
ANSWER
User: Shashikant
Replied: on Mar 03, 2016 06:01 AM
Report

Please refer below code.

SQL

CREATE PROCEDURE pinfo
   @name VARCHAR(25)
AS
IF ltrim(rtrim(@name))<>' '
BEGIN
	SELECT firstname
	      ,name
	      ,lastname
	      ,birthday
	      ,[address]
	FROM info 
	WHERE name=@name
END

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

Get record based on specific column Sql

Company

Explore

Follow us

Contact Us