Topics
Started by
Posts
Last post
USE Northwind SELECT Title, Customerid FROM Employees CROSS JOIN Orders So, what I wanna do is to g…
43 replies
SELECT DISTINCT emp FROM #tblseat INDEX((IX_placing),NOLOCK) I get the this error when i exec abov…
2 replies
Hi all, Below statement works fine in 2000 what is equivalent in 2005? SET Grant = 'GRANT ALL PRIVI…
3 replies
Hi, If I have the following SQL (see below) why does it never hit the CATCH block? Obviously the e…
6 replies
Hi all,, Is there any way to find out which database is being used currently using a TSQL command? …
1 replies
hi INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\test\Test.xls;', …
2 replies
Column name : ExecSummary, VARCHAR(8000) UPDATE dbo.tblRegistration SET ExecSummary=' extensive exp…
2 replies
I want to SQL Server 2000 more 3 table join using Inner Join and get more fields each tables. pl gi…
3 replies
I have a stored procedure that returns xml. Using the FOR XML type of query. It is fairly complic…
1 replies
Hi , I am new to trigger. I want to create a insert trigger for a table(table 1) ,in which w…
9 replies
I can't understand the behavior of WAITFOR DELAY. Why this code flows? WHILE NOT EXISTS (select * …
9 replies
How can I convert first result set to look like second one??? SQL to create and populate table is a…
3 replies
Hi there, I need to delete an entire Folder that gets created programmatically on a daily basis. I…
2 replies
Dear All How can I write a stored procedure based on condition. At the moment, my code is not work…
5 replies
My company want me to write the task that will send email out when the log file reach every 100MB (…
3 replies
Viewing 15 topics - 9,556 through 9,570 (of 12,234 total)
You must be logged in to create new topics.