TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ajay raju
NA
398
0
Doubt in Sql Query
Apr 20 2010 7:36 AM
hi!
i am create table like
create table user1(id int,firstname varchar(50),Lastname varchar(50), Fullname as (lastname + firstname))
table is executed. but i am write query to select value this time it shows empty column i write statement below. how to solve this. and i am goto objectexplorer and select modify table of user1. in that it shows no data type for Fullname column. what is default data type of sql server.
select id from user1 where Fullname = 'K.Ajay'
Thanks.
Reply
Answers (
1
)
SQL Server: Restrict the duplicate insertion of records to the database using Store Procedure
how to put dot and comma in columns of sql table?