How to secure data in the SQL Server Database?
If a table has more than one index, how will you call a specific index in query?
How to write query to unsort while retrieving data?
What is 'no lock' term in SQL, like "select * from table a (no lock)". What is its purpose?
Latest Answer: It is useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, ...
How to insert bulk data into the SQL Server?
Latest Answer: Table to table data transferselect * into targettable from tableflat file to table data transferuse bcp command bcp pubs2..publishers in pub_out -c -t , -r r ...
How to insert data in multiple tables at same time. using SQL Server 2000
Latest Answer: Here is the example for you question.
USE YourDB
GO
INSERT INTO
MyTable (FirstCol,
SecondCol)
SELECT ‘First’
,1
UNION ALL
SELECT ‘Second’
,2
UNION ALL
SELECT ‘Third’
,3
UNION ALL
SELECT ‘Fourth’
,4
UNION ALL
SELECT ...
1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani).
Latest Answer: Inset data:insert into targettableselect top 5 * from sourcetabledelete data:1. select distinct * into targettable from sourcetable2. delete from sourcetable3. insert into sourcetable    select * from targettable ...
How can we dynamically assign parameters to a subscription in SQL Server Reporting Services 2005.
How to read the data from a pdf in SSIS?
How can we improve stored procedure performance? Explain the performance tuning techniques.
Latest Answer: 1. Use many WHERE clauses in the SELECT statments.2. Select only those fields which you really require.3. Joins are expensive in terms of time. Join the tables using related fields manly indexed fields.4. Don't use unused ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
