Into a store procedure I want write a SELECT changing dynamically the name of table to select. I have used: SELECT @punteggio = @punteggio + Punti from @TblProfessione WHERE ID = @professione where @TblProfessione is the variable with the name of table to select but It's don't work
2001-08-28
2 reads
Is it possible to create relationship between 2 tables from different databases in SQL SERVER 2000 ? Thanx
2001-08-28
hello there, i want to access two different tables a and b which are in two different databases d1 and d2 is there any way out thanks keyur
2001-08-28
2 reads
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
2001-08-28
1,500 reads
I have used SQLDMO extensively (SQL2000) in an app I have just finished developing. I am now trying to make an install for Win2000 and am having troubles. I have followed the guide in the redist.txt file on the SQL Server CD as follows: sqldmo.dll (reg. by extracting com info) sqldmo.rll (in app path folder) […]
2001-08-27
165 reads
I have table A with three fields. Emp_Code Char(3), Emp_Name varchar(15), Policy_Change_Date datetime GetDate() . If any one record changes in table A, i wish to get the system date into the Policy_Change_Date. How will i create this trigger?
2001-08-27
2 reads
I am attempting to import data from one SQL Server to another by linking both SQL Servers together and running a query using the 4 part SQL object name. The SQL Servers are situated over separated networks, this being 2 separated VLANS. For security reasons I wish only to connect over a single port (say […]
2001-08-27
We have SQL Servers: 6.5/7/2000. How can I issue, via SQLServereAgent scheduler, the commands "sp_helpdb, sp_helplogins, sp_helpdevice" and send the output to a textfile? TIA, Bill Salkin
2001-08-24
41 reads
I know Access isn't the best front end program for SQL Server but it's what I had to use. Anyways, I'm new to the SQL Server world and am both developer and administrator of a database. I have linked my tables into an Access front end, but every once in awhile I get an error […]
2001-08-24
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/iqreference.asp
2001-08-24
3 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