Topics
Started by
Posts
Last post
I know I can get the information from sys.master_files and sp_heldb but how can I write a query to …
3 replies
Hi All, I have 4 tables, Employee: Id, code, name, pos_def_id 213, Z300, Diana Benk, 108 ShiftAssig…
4 replies
Hi All, I'm having two databases, I need to run a query in my aspx pageload that checks for any new…
8 replies
I have a pass through query that is like: execute spsocialcount '[BeginDate]','[EndDAte]','[Holiday…
7 replies
DDL & sample test data: create table #TEST ( idint, totdaysvarchar(6) ); GO INSERT TTEST …
4 replies
I am showing you dummy data select A,B,C from TEST Output: 1011 1012 1121 1122 1131 113…
2 replies
Can anyone spot what is wrong with this? EXEC [LinkedServerName].master.sys.sp_executesql 'BACKUP D…
4 replies
I have a problem with a heap table that has a single index (not clustered). For reasons that are no…
3 replies
Hi All, I wanted the resulted xml to look like this : <Root> <QueryWaiting version="B000"&…
1 replies
I writing a query as follow Select 'I87' [Location],PC.Company_Name [Company Name], Q.Department…
4 replies
Hi I have a requirement where i need to take the database default collation for creating the view. …
2 replies
Suppose I have one table that contains 10 columns and all can accept null value. Suppose there are …
5 replies
I have a large stored procedure that populates about 6 tables. It creates, populates, and uses many…
7 replies
Hi, I have 2 tables with the very same LONG structure (table_1 and table_2). I was wondering if it …
14 replies
Hello All, I need to create transactions to either add or remove items from a list. The transactio…
7 replies
Viewing 15 topics - 7,441 through 7,455 (of 10,647 total)
You must be logged in to create new topics.