Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
deepu
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table book(isbn varchar(10),title varchar(10),pub_year varchar(10),unit_price varchar(10),author_name varchar(10),publisher_name varchar(10)); insert into book values(1001,'oracle',2004,399,'arora','phi'); insert into book values(1002,'dbms',2004,400,'basu','technical'); insert into book values(2001,'dos',2003,250,'sinha','nirali'); insert into book values(2002,'adbms',2004,450,'basu','technical'); insert into book values(2003,'unix',2000,300,'kapoor','scitech'); select * from book; Select author_name from book; Select publisher_name from book; Select title, unit_price * 10 from book;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
20181CSE0534
Task_3_Final
employee table
Libros
FIRST DATABASE
Microsoft SQL Server T-SQL in 10 minutes - products
P1
sql-server-storing-wildcards-in-data
Generate xml
Use the right tool to get identity values back after an insert
Please log in to post a comment.