At work we have a number of databases that we need to do the same operations on.I would like to write 1 SP that would loop over operations and set开发者_StackOverflow中文版 the database at the beginni
Ex: for store procedure we use 开发者_如何学Pythonsp_helptext .is there any keyword for viewing jobs in text in sql server 2005
In SQL SERVER 2005 This quer开发者_JS百科y works fine : Select * from sys.procedures where object_definition(object_id) like \'%J%\'
How can I import CSV file data into SQL Server 2000 table? I need to insert data f开发者_运维问答rom CSV file to table twice a day. Table has more then 20 fields but I only need to insert value into 6
I\'m currently in the process of cleaning up a sql server 2000 instance. I found 10 L开发者_JS百科ocal Packages that were created 4-5 years ago. In an effort to clean up old processes, I want to delet
I create a query: Select * from HR_Tsalary where month=\'3\' and year =\'2010\' the result is 473 records and I found 2 duplicate record, then I create another query t开发者_运维技巧o find duplicat
I\'m trying to better understand why one of our database update scripts failed to work properly at a particular customer site, and narrowed it down (I think) to database ownership and roles.
While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked
I thought I had this figured out but it turns out I\'m just deleting the first record. The following returns the duplicate rows. All have开发者_JAVA百科 a count of 2. I just want to delete the first o
This is what I\'m trying to do something similar to the foll开发者_如何转开发owing request, but I don\'t know if it\'s possible with the SQL-Server syntax:
加载中,请稍侯......