Topics
Started by
Posts
Last post
Hi All, I need to design a Payroll database for my Mid Size Company. Our Employees are all salary b…
12 replies
Does Sql Server supports 'Finally Block' in query? Begin Try End Try Begin Catch End Catch Beg…
2 replies
I have come across the following error: Msg 242, Level 16, State 3, Line 1 The conversion of a char…
4 replies
Hi friends, i am just wondering how can i get number of activity from the table which is having dat…
2 replies
I have this query here: SELECT top 10 left((convert(varchar(10), D_Date, 120)), 13) D_DateValue, …
6 replies
Why schemas, object names (tables) and columns are to be written using the right case when we work …
4 replies
Hi, Can any one explain what is the use of FETCH API_CURSOR and EXEC sp_cursorfetch I have a code i…
2 replies
I have a table that has a billing date field that is a date and time value. There is a record for e…
6 replies
If my SP has the following parameters a="hyderabad" string b=10.145 c=a+b I want my storedprocedure…
3 replies
I defined a variable and want to right its value to text file I used this code for transfer DECLAR…
5 replies
This code be used to pass variable value to text , when run it give Error = [Microsoft][ODBC SQL Se…
3 replies
I am looking to buy a TSQL programming (2005/2008) book, Can someone recommend a good Book. blog: h…
2 replies
hey, Normally we do write the queries using the joins (Ex.1), but we can write in the queires if di…
2 replies
How can I show total sales results for each customer and product by totaling each sales persons sal…
3 replies
hi I've mad a stored procedure that uses derived table to insert params into a table name TMovie bu…
11 replies
Viewing 15 topics - 6,076 through 6,090 (of 12,234 total)
You must be logged in to create new topics.