Answer Posted / skybeaver

create proc ShowMeHow
as

declare @Cities table(
AirportCode char(3) not null primary key,
CityName varchar(255) not null
)

insert into @Cities values('LAX', 'Los Angeles')
insert into @Cities values('ORD', 'Chicago')

select * from @Cities
go

What is the maximum size of column in sql server?

938

---

How to deploy the Report?

140

---

What are the different Topologies in which Replication can be configured?

1235

---

What is transact-sql language?

1129

---

How do I find the query plan in sql server?

1012

---

How to scale out a federation by Sql statement?

118

---

How do I view a script in sql server?

1079

---

Explain different types of Normalization.

1893

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1170

---

Explain an incremental backup?

1049

---

Explain how does the report manager work in ssrs?

997

---

What happens when converting big values to integers?

1053

---

What are the advantages of paper records?

1010

---

What do you mean by SQL injection attack?

1123

---

What new data source types were added in ssrs 2014?

169

---