Topics
Started by
Posts
Last post
Guys, I have stored proc sp_generate_insert which will generate insert scripts for the tables. When…
30 replies
I have this datas... CREATE TABLE Query_Result ( id INTEGER, order_id INTEGER, supplierCode I…
3 replies
I have two tables: (1) tblTransaction (2) tblForMatching select tbltransaction.* from ( select 1…
13 replies
I have a zip code field that I imported from an excel spreadsheet. When I imported it into the dat…
4 replies
I want to execute a CREATE DATABASE statement with size = 200GB. I will then do a restore fro…
4 replies
Hi, For testing purposes, I need to make the next record in a table to get a value above 33000 for …
2 replies
Hi, We are facing Deadlock issues, when we try to execute a proceddure for different parameters sim…
8 replies
Hi All, I have a view which has the below like data as output …
11 replies
Hi, assume that we retrive some tuples from a table select * from product_information ID&nb…
8 replies
Is there a way to pass an expression to a stored procedure. Ex. stored procedure usp_XXX is expecti…
5 replies
From a table or database, how can i find which column has unique values in it. In most of the table…
12 replies
I have several tables that implements triggers to audit data change and put change into audit table…
4 replies
Hi, all, am back asking questions: I have the following 8 tables: CREATE TABLE [dbo].[FOODS] ( [FO…
28 replies
DECLARE @table TABLE (primary_key INT IDENTITY(1,1) NOT NULL, Itm_ID INT, Itm_Desc varchar(1000)) …
2 replies
Is there a way to link an excel file to SQL Server 7.0 like in Microsoft Access?
6 replies
Viewing 15 topics - 4,246 through 4,260 (of 17,082 total)
You must be logged in to create new topics.