What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
No Answer is Posted For this Question
Be the First to Post Answer
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What do you understand by triggers and mention the different types of it?
what authentication modes does sql server support? : Sql server database administration
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is shrink log file?
Can we drop user if user mapped to any logins
What are the different subsets of sql?
Explain the different types of backups available in sql server? : sql server database administration
What will happen if a column containing char type data is changed to the nchar data type?
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 do you need to connect php to sql server?