Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
2 7300hi 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
2183We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
3 5239
What is Service Broker in sql server 2012?
How to monitor firebird server activity?
How to turn off warning messages during php execution?
What are drillthrough reports?
State about the security aspects of stored procedures?
How many types of segments in Oracle?
Mention the command used to rename the database.
What are mysql functions?
What are local and global Indexes and where they are useful.
How do I know if localdb is running?
Explain about system database?
How to start your 10g xe server?
How can you access different databases temporarily?
What is normalization in database with example?
Explain how dts is used to extract, transform and consolidate data?