Topics
Started by
Posts
Last post
Is it possible to run "EXEC sp_executesql @sql, ........" and return the query results into multip…
5 replies
Forgive me if this has been answered before, I searched around this site and others but couldn't fi…
10 replies
I have done a search here as well as BOL, but I cannot seem to find a function to show me our SP's …
30 replies
I am working on figuring out some medain calculations in our data and was getting fairly complicate…
4 replies
Hi, how can I make this query (I've tried with group by) I have table: Typ Value Date 1 …
1 replies
Is there some way of resetting identity generated number when deleting all records of the table. I…
13 replies
Hi People. I hope you can help me with the following error message that I get when debugging a new …
12 replies
I have a transaction: BEGIN TRAN SELECT * FROM dbo.PKSETUP WITH (SERIALIZABLE, XLOCK)--(XLOCK, R…
1 replies
Hi, I've been racking my brain over this. Can't seem to find a solution. I want to pull the latest …
2 replies
declare @t varchar(8) set @t='Admit' select * from @t Server: Msg 137, Level 15, State 2, Line 3 Mu…
5 replies
This trigger is supposed to change the phone number to all 1s if the first 3 numbers in the phone f…
1 replies
I have a table with identity column and primary key(pro_id) but had a few thousands records with du…
2 replies
select '$ '+ convert(varchar(30), sum(lu.Private)) as Private from ...... I need to insert this pri…
10 replies
howcome I can do something liek this... SELECT dbo.ReturnVal((SELECT MAX(val) FROM Table)) but I ca…
8 replies
I am looking for a solution to changing the owner of multiple objects within a database from one ow…
2 replies
Viewing 15 topics - 7,426 through 7,440 (of 17,082 total)
You must be logged in to create new topics.