Topics
Started by
Posts
Last post
Hi professionals I have a table like so departmentid,Barcode,Invoiceno,expirydate 2036,xyz,12345,2…
4 replies
Hi all, Please help me to find out 2nd and 4th saturdays of current year. Thanks and Regards Shiris…
5 replies
I have 2 tables(label and product) both has the column called uniqueCode which is nvarchar(255) dat…
6 replies
I have this stored proc USE [SMS] GO /****** Object: StoredProcedure [dbo].[usp_Birthday] Scrip…
6 replies
How to get job schedule details, I mean detailed schedule like, all the jobs on all 7 days. …
2 replies
Hi All , I am trying to install MSSQL 2008 using the below command. Setup.exe /CONFIGURATIONFILE=” …
2 replies
i have productname column in my table and the query i need to get only the alphabets. column contai…
10 replies
Hi, if I have several SELECT statements with UNION how can I tell to sql to process which one first…
2 replies
We had found logical consistency errors in the database when we ran dbcc checkdb. The application v…
1 replies
Hi, this is my table structure: CREATE TABLE #table1 (ID INT, Col1 NVARCHAR(1), Col2 INT); INSERT …
1 replies
Hi, this is initializations: CREATE TABLE #table1(col1 nvarchar(1), col2 int); INSERT INTO #table1…
4 replies
Is there a way using union to overwrite null values? for example: I hava two views with following c…
2 replies
Can SQL Server guarantee that if I issue a command like: INSERT INTO T(...) SELECT t.a, t.b, 1 FRO…
6 replies
How would someone send multiple html tables with sp_send_dbmail? In the @body paramater I can only…
5 replies
Hi. Here is my table initialization: CREATE TABLE #table1(col nvarchar(1)); INSERT INTO #table1 SE…
4 replies
Viewing 15 topics - 9,481 through 9,495 (of 30,225 total)
You must be logged in to create new topics.