Topics
Started by
Posts
Last post
I have a number of SP's that I am reviewing and they all you TRY\CATCH exeption handling. Howvere s…
2 replies
code snippet: CREATE XML SCHEMA COLLECTION MovieSchema AS N' <xs:schema xmlns="http://schemas.sq…
4 replies
I have not used the new PIVOT operator and from BOL I'm not clear if or how the following would be …
15 replies
I want to list all the tables from all the databases in a select query, without using any cursor. I…
11 replies
Hi All, I have a table called employee. These having 4 columns which is ID, name , addre…
4 replies
Hello, I've trying to write an update statement that updates multiple columns in a table. One of th…
6 replies
In record set I have loaded the lacs of records in application, It Says time out expired error, But…
5 replies
Hello !! This is my first post on this forum, and I have a little problem at work that I don`t know…
8 replies
these 2 SELECT return the same result, but do they have the same meaning? Can I put the WHERE cond…
17 replies
In a BI project I'm trying to retrieve multiple company information. I'm not at all familiar with t…
4 replies
I have a view across all similar databases but in one of the database which is considered as Old do…
14 replies
I have a Empoyee table Emp_Id INT Att VARCHAR(10) -- Present/absent/Leave.... date datetime As you …
6 replies
I am trying to code in TSQL (without using the full-text indexing engine) a way to search fields fo…
8 replies
How generate Dates on the fly? At runtime for the last 5 years, current year -5 starting from 1st J…
55 replies
I need to join two tables and search using the contain statement, how do you do this ? It works wit…
3 replies
Viewing 15 topics - 7,231 through 7,245 (of 12,234 total)
You must be logged in to create new topics.