Topics
Started by
Posts
Last post
How do i set transaction isolation for just 1 database to snapshot. does it has any dis advantages
4 replies
Hello friends I have a tabe of LabTests and I need to add two new columns to this table with two di…
3 replies
I have a semi-complex table join structure and a couple of nested select statements in my where cla…
10 replies
Hi all, I'm currently attempting to write a stored procedure that will return the top 4 number of "…
7 replies
I've been tasked with adding default values on a number of different columns throughout our new-ish…
2 replies
I am a novice, and I need to dupicate a formula used in Access in a Stored Procedure of our Databas…
5 replies
Hi, This query works fine: SET @cnt = ( SELECT COUNT(*) FROM myTable ) How do I do this if I don't …
3 replies
Tables is called Table1. Has one column called Column1. Data type is XML. Data looks as follows:…
2 replies
HI all, I have created some sample sample data and what I would like my result set to be 🙂 [Code] /…
1 replies
I have been given a task of an already existing [developed by someone who's left! 🙁 ] stored proced…
4 replies
Hello comunity i have this string value on my table : V104 - Luis I need to return only V104 , i me…
3 replies
Hello, I have one problem in SQL, I want to Import excel data to SQL table using Formated excel fil…
5 replies
Hi all, I have a requirement to import data from csv files that originate outside my control. Thes…
7 replies
The below statement works fine without the last 'HAVING' clause. With the 'HAVING' though it gives …
9 replies
how to pass array in stroed Procedure i want to find alternate on the behalf of passing No of Para…
4 replies
Viewing 15 topics - 9,316 through 9,330 (of 12,234 total)
You must be logged in to create new topics.