Topics
Started by
Posts
Last post
Dear all, I would like to know if it is possible to create a circular reference on a table. Example…
2 replies
I do understand what OR does :] I also tried to use IN but it did not work either(its an or written…
7 replies
This command works from one of our machines, but not on others: EXEC master..xp_cmdshell 'osql …
6 replies
Hi guys, I'm trying to create a user interactive stored procedure, which means every time the proce…
2 replies
sp_makewebtask can only be executed by the sysadmin role by default. I want to give some users the …
2 replies
Greetings, I am trying to set up a table which has 2 fields that have a foreign key constraint to t…
3 replies
I would like to grab 10,000 records, update a flag in those records, then return the recordset. I …
3 replies
Gurus, I have three after insert,update triggers defined on a table and I want to order the executi…
3 replies
Can other members advise please: I have written a 2-tier business application where I am progressiv…
14 replies
I have the following case statement in my select CASE WHEN DATENAME(weekday, (CONVERT(varchar(10…
3 replies
How can I optmize this query which takes too long to run. Any help will bve greatl appreciated. ===…
2 replies
What is the most efficient query to select all duplicate records in a large table?
1 replies
Hi to all, I have a nice problem to solve: We have one SQL Server 2000 Cluster (A) that holds fresh…
2 replies
I'm tyring to put some T-Sql together to drop users and then delete the logins from a Db. I issue a…
4 replies
Hi ! I've a dynamic query in a variable, like this : DECLARE @SQLString NVARCHAR(2000) DECLARE @TAB…
3 replies
Viewing 15 topics - 16,366 through 16,380 (of 17,082 total)
You must be logged in to create new topics.