What is the best way to move n number of DTS package from
one SQLServer to another SQLServer?
Answer / pratik
transfer data from sysdtspackages of msdb database to
another SQL Server
| Is This Answer Correct ? | 1 Yes | 2 No |
Explain how to integrate the ssrs reports in application?
What are the advantages of user-defined functions over stored procedures in sql server?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
What is 'Join' and explain its various types.
What is indexing in sql server with example?
What are examples of triggers?
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )
3 Answers CarrizalSoft Technologies, iGate,
Why we are using the sql language?. What is the purpose of using this?
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
Explain the concept of recursive stored procedure.
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
How do I run sql server 2014?
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)