Topics
Started by
Posts
Last post
Hi All, I want to find whether a table is empty or not without using count() function. Say for exam…
12 replies
Below is a query which works fine. it dispays the table name,index name and associated column name.…
2 replies
I just dont get it .. whats the difference between create table guidPrimaryKey ( guidkey uniqueide…
2 replies
Friday afternoon challenge. Easy to do with cursors: - a certain number of subsets (number of subse…
14 replies
hello friends whats the best way to get las X records inserted in a Table ?
15 replies
Hi All, Please see the procedure below, CREATE PROCEDURE DBO.GetDetailsByMenuID ( @iGroupId INT=NUL…
1 replies
I have the below senario. Create table Emp ( Ecode_12345 varchar(25), Ecode_54321 varchar(25), Ecod…
1 replies
Why should we Information schema Views instead of System tables? Thanks in Advance!!
1 replies
I'm using the Date() and Time() Functions from Classic ASP (Haven't upgraded this particular site t…
2 replies
I need to do an insert where the month is missing with zero amounts. For example, the data is... g…
8 replies
I have a Table1 which I need to JOIN with either Table2 or Table3, depending if a related record ex…
12 replies
I have a sp that runs fine in QA by entering sp_name. I need to run the same sp as a sql server a…
1 replies
i have one column having date values like int 20081003 20080326 20081003 20081002 and time values l…
12 replies
I am stuck on a query that doesn't seam to have a proper set based approach. The query is suppose …
2 replies
I am trying to update data by using a SP to update a view that is made up of two tables. I ge…
7 replies
Viewing 15 topics - 2,371 through 2,385 (of 17,082 total)
You must be logged in to create new topics.