Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
No Answer is Posted For this Question
Be the First to Post Answer
what is difference between primary key and Unique
What is primary key index?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
What is Online Index Rebuild Operation?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Which databases are part of SQL server default installation? Explain the usage of each?
How to execute function in stored procedure sql server?
When we should use @@error?
What is @@rowcount in sql?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to update values in a table with update statements in ms sql server?
What is the difference between Userdefined function and stored procedure? Explain and give the example also
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)