Search results for query: *

The SQL statement can be like this SELECT dpto,cli from TBL TA Where TA.cli IN (select top 2 cli from TBL TB where TA.dpto=TB.dpto Order by cli)

I need a SQL Statement to return the first n records of every group (for example, the first 10 customers of every department), how can this be done.

I think it isn't, as I have no row at all on sysproperties table.

Can you tell me how to find out whihc procedures are run at SQL Server startup (those procedures whihc have been marked as autoproc using sp_procoption) ?

Your query should work for update and insert, as during the insert the record exists both in the real and inserted tables.

MS SQL Server and Sybase are quite similar on the capabilitis to updete views, there are some restrictions for a view to be updatable: - Do not include computed columns - Do not inlcude aggregate values (group by, compute) - Do not reference more than one table (update and insert sometimes are...

You can get the client version running "select @@version" from SQL Advantange. You can get the client version running "isql -v" from UNIX/MS-DOS command line

run the query "select @@version"

See sp_change_users_login.

You create a login for a server. You create a user for a database. You can link logins with users (this is the way you link logins and databases)

The hierarchy is a users is defined within a database which is defined within a server. But users can not log on to a server, "Logins" are used to connect to the server, and then mapped into "users" when accessing any database (a different user for each database, even if the user name is the...

We get the same message from EM than from QA.

We have a definition for a linked server, which was created using sp_addlinkedserver procedure. Now we want to drop taht definition, but when we try to use sp_dropserver procedure (BOL) we get error message 911: "Could not locate entry in sysdatabases for database 'distribution'. No entry...

I think there is no attach database command for Sybase, but you can try to create a new empty database with the same definiton (name, size, ... including database devices) as the original database, then replace the files created for this new database with the ones corresponding to your database.

You have both types of temporay tables Tables created as "create table tempdb..t1" are shared anong all connections, and tables created as "create table #t1" has a different table for each connection.

Book OnLine, the SQL Server manuals; you can install them with SQL Server, or find them in Microsotf web pages.

You are right, you are only replicating the articles listed when you created the replication definition unless you chage the published database schema through replication properties (or replication stores procedures) Hava a look to "Schema changes on publication databases" on BOL.

I don't know about Access Project, but if you want to lock records, can't you use SQL Server locking facilities ? you can jave a look on BOL ("Understanding Locking in SQL Server", "Locking hints",...)

I need a Transact-SQL to start a SQL Server Agent job (using "exec sp_start_job @job_name='jjj'")and then wait until the job is finished, avoiding to read system tables directly. (for SQL 2000 and 7.0) In other words, I'd like to wait until current_execution_status in sp_help_job is...