What is database replicaion? What are the different types of replication you can set up in SQL Server?5 19826
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.836
can we call stored Procedure in Function in Sql Server 2000 and vice versa.3 15295
What is an extended Stored Procedure?1 4654
What is the difference between having and where clause?4 6745
how many no of arguments can be passed in procedures and functions
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Comment,Datatypes are unlimited
How to convert a table data in XML format in sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is data modeling and Reterminal integrity?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
last function used in MS Access to convert sql what function will use in sql
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
You are doing log shipping due to some reasons it is failing. How you will proceed from there
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How do you Implement SSIS Packages in your Project?
can any body tell me how to know the password of current user in sql server