IN Vs OR operator which is best to use sql server.4 8429
why cluster and non clusterindex are used in sqlserver 2000? explain with example1 3321
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 20003 3997
how to select a field with firstletter as capital and remaining are small letters11 12036
How to write stored procedure to update the data in 10 tables4 10880
How to write query to Delete the records in child table and corresponding records in parent table11 27168
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?2 4411
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?4 5402
what is curser.9 6858
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
how many no of arguments can be passed in procedures and functions
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is data modeling and Reterminal integrity?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
what is package and it uses and how can u call a package
How can we call UDF(User Define Function) using C# code in ASP.net ?
Comment,Datatypes are unlimited
how to do partition in sqlserver
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that