View Complete Post
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....
hello, i use filestream sqlserver 2008. When a file is inserted on sqlserver filestream, this file is put on a directory and rename with this: "00000055-000000f9-0009" for example. If you add extension (jpg for example), you can open this file. It's
good. But, i dont't know how get the name "00000055-000000f9-0009" for example when i have my colum filestream of my table and the uniqueidentifier.
It is important for me because i wan't to access to this file if my application have a problem. I am administrator DBA sqlserver and i wan't to retrieve the correspondance and file GUID of my table and file system "xxxxxxxx-xxxxxxxx-xxxx" created.