Topics
Started by
Posts
Last post
Try: select case when 1=1 then 8 else sum(-10+1) end from Master.dbo.Items where 1=0 select case wh…
9 replies
Hi all, Is that possible to select The data from excel 2007 on sql server 2008 r2(64 bit),…
10 replies
I have 2 tables CREATE TABLE tbl_Student ( Student_ID INT , Name VARCHAR(10) ); GO CREAT…
5 replies
hi All, I am facing a typical problem in my SP, actually the SP is using may temp tables. For bett…
2 replies
i have a simple table with 3 columns and 3 rows. is it possible to generate a pdf document by direc…
6 replies
Query to find out 'is data and log file splits to multiple files '?
7 replies
Background: To add materials to our DB we often get xls files from users. I have the xls formatted…
2 replies
Hello Again...I am at my new intern place and the job my manager gave me is I have to run a query f…
16 replies
Hello, I have a fn and a sp, the fn returns table and the sp retrieves info from the table-fn. Both…
1 replies
Hi All, We upgraded SQL and windows on one of our servers last night, details are below: MS 2008 St…
5 replies
I am able to see the list of columns or table which is bound to my rule or default using sp_depends…
5 replies
I've been trying to find out why "Exec sp_executesql @sql" is supposed to be a better practice tha…
5 replies
Hello Everyone, I have done quite a bit of searching and have found several people asking the quest…
8 replies
Hi, I am (still) often challenged about having SQL Server as the underlying DB for high volume appl…
4 replies
Query to check processor count and maxdop is zero
3 replies
Viewing 15 topics - 13,201 through 13,215 (of 30,221 total)
You must be logged in to create new topics.