i was running a bad update query in QA and canceled the job midway by hitting (X) in upper right corner. The query was changing EVERY record. I cannot tell if only a few records were changed. I did a controlled test on a test table and no changes were made. Could any of the […]
2001-10-01
3 reads
Hello, I connect from SQL Server on Windows 2000 to Progress Database on UNIX. The database name of SQL Server is cstarsql and the name is cstarint on UNIX. I would like to schedule to copy data from cstarint(Progress) to cstarsql(SQLServer). I did for one time, but I want to control if the data has […]
2001-10-01
3 reads
somebody please tell me how to query data like below table : test.dbo ID Desc qty ----------------------- 1 Oil, chem 1 2 Oil, chem 1 3 gas, oil 1 4 bez, oil, gaz 1 ----------------------- how to show all desc = "oil" using select if in visual foxpro should be like ... "brow for alltrim("oil") […]
2001-09-28
3 reads
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
2001-09-28
7,613 reads
Hello everyone how to import the .mdf file into database. Actually i uninstalled the sql server with out taking backup, now i installed it again, i want the old database files to be back. with regards kittu
2001-09-27
4 reads
Hello, How can I delete the file(sql text document)? When I tired to delete the file, the message is displayed 'There has been a sharing violation. The source or destination file may be in use.'
2001-09-27
2 reads
Our SQL 2000 machine had SP1 installed recently and since then the SQL Agent stops with no warning and with no apparent pattern except mostly on the hour or half hour. e.g. 7:00 AM, 12:30 PM, 9:30 AM etc None of the tasks run by the agent have been executed at all the times that […]
2001-09-26
4 reads
Can i use a alias name in a "where" clause to filter records. eg. select employeename en, age from employees where en like 'a%' i am getting an error 'en' column not found. how do i get over this problem. Paras Shah Evision Technologies Mumbai, India
2001-09-26
2 reads
Have you ever come across this scenario? I know you can have logins without users, but users without logins????! If I create a new database on this particular server the dbo instance in the new database is also NULL. I've checked MODEL and in this and all system databases dbo has a login of SA […]
2001-09-26
96 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset.asp
2001-09-26
5 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers