What is the difference between seek predicate and predicate?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain the third normal form(3nf)?

0 Answers  


What is the difference between dataadapter and datareader?

0 Answers  


What will you do If the low Performance occurs?

2 Answers  


hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  


I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,






How to Debug a Stored Procedure?

5 Answers   Allianz,


Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,


How to copy the tables, schema and views from one sql server to another?

0 Answers  


Determine when an index is appropriate?

0 Answers  


What are the different types of sql server replication? : sql server replication

0 Answers  


How to retrieve error messages using mssql_get_last_message()?

0 Answers  


how can a database be repaired? : Sql server administration

0 Answers  


Categories