|
|
|
|
-
Sineetha Commented 2 Years ago through Blogs | 1 Point
Query 2 throws error.If we need to use a table more than once in a query, need to use alias name....
|
-
Sineetha Commented 2 Years ago through Blogs | 1 Point
Query 2 throws error.If we need to use a table more than once in a query, need to use alias name....
|
-
Sineetha Liked 2 Years ago through Blogs | 1 Point
Out of these four queries, only one query will throw an error. Without running these queries find out the query and error message that it would generate.
Queries
Query 1 : select top 1 1 from sysobjects,syscolumns where 1=1
Query 2 : select top 1 1 f...
|
-
Sineetha Commented 2 Years ago through Blogs | 1 Point
It can cause an invalid memory access
when the specification contains two or more duplicate ORDER BY
columns.No such problem for GROUP BY...
|
-
Sineetha Commented 2 Years ago through Blogs | 1 Point
It can cause an invalid memory access
when the specification contains two or more duplicate ORDER BY
columns.No such problem for GROUP BY...
|
-
Sineetha Liked 2 Years ago through Blogs | 1 Point
Consider the following table
create table #t(id int, names varchar(100))
insert into #t
select 1,'name1'
union all
select 2,'name2'
Consider the following select statement
select id from #t
order by id,id
It returns the error
Msg 169, L...
|