Can group functions be mixed with non-group selection fields in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
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
What is SQL server agent?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
How are the unique and primary key constraints different?
What is a print index?
Explain sql server authentication modes?
How to add an address record into adventureworkslt?
Can we use max in where clause?
What is left outer join in sql server joins?
Explain what is raid and what are different types of raid levels?
Can you explain what is indexed view? How to create it?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?