Latest Answer: create table dup(id int, name varchar(50))insert into dup values (1 ,'raja')insert into dup values (1 ,'raja')insert into dup values (2 ,'krishna')insert into dup values (2 ,'krishna')insert into dup values (3 ,'ramana')insert ...
Latest Answer: If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the procedure or batch. And so we do a dynamic SQL Statement.CREATE ...
Latest Answer: Please refer that here we are discussing about Sql Server only. There is no function named 'Translate' in Sql Server. 'Translate' function exists in Oracle for translating a single character to some other character.Replace fucntion in ...
Latest Answer: Examples for Analytical functions in Sql Server 2005:AVG, COMPUTE, DENSE RANK, NTile, Over, RANK, Row Number, STDEV, SUM, VAR, VARP, WITH ROLLUP ...
Latest Answer: select column_list into new_table_name from old_table_name where false_condition(ex. 1!=1) ...
Latest Answer: * Stored procedure contains all DML stmt to perform operation With permanent table where user define function does not contain insert, update, delete stmt to modify the permanent table.*
Stored procedure takes input and output parameter where function ...
Latest Answer: HAVING specifies a search condition for a group or an aggregate function used in SELECT statement.HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like ...
Latest Answer: ref cursor can be used to retrieve and return the multiple records ...
Latest Answer: System.Data.Sqlclient ...
View page << Previous 6 7 8 9 [10]
Go Top
