Viewing 5 posts - 1 through 5 (of 5 total)
select 'drop procedure '+name from sys.procedures where name like'%%'
Copy the result and execute it
January 11, 2010 at 2:56 am
Thanks
for Your Immediate Response
But TestId is not unique ,number of male can give same test ,then
DECLARE @data TABLE (test_id INT , gender TINYINT NOT NULL CHECK (gender...
January 8, 2010 at 12:09 am
The answer is ABCD
as union remove all the duplicate values
if You want to retain all values please use UNION ALL 🙂
January 7, 2010 at 10:40 pm
Hello
you can create a non clustered on the column which is mainly used in where clause with fill factor of 90%
December 29, 2009 at 4:47 am
hello
temporary tables are least in use as they consume the memory resource
Instead of temporary tables you can use the table variable as the table variable is just like...
August 11, 2008 at 10:57 pm
Viewing 5 posts - 1 through 5 (of 5 total)